Expert@Excel: 2 in1 For Beginners +and Pivot tables: A Step by Step Guide to Learn and Master Excel To Get Ahead @ Work, Business and Personal Finances - Softcover

Reed, Daniel

Softcover

ISBN 10: 179522326X ISBN 13: 9781795223263

Publisher: Independently published, 2019

Synopsis

Do you feel intimidated by how complex Excel can seem? Confused by Pivot tables?

I know how you feel but keep on reading if you want to know how to overcome this…. 

Did you know that up to 78% of middle-skill jobs require applicants to be proficient in MS Excel? It is shown that those who were able to prove their mastery of the program were set to receive up to 30% more than their peers. But there’s far more to Excel than just being a potent addition to your resume. It is estimated that on average people only use 20% of functions available on excel because they are unaware of what each button and function does, are you part of the average? Well go beyond being average and learn new skills that will set you apart from the rest.    

Topics Covered In This Book Include:

Book 1) For Beginners

• Reasons why excel is and will continue to be one of the most important software tools to get ahead in your career and personal finance. 
• How to navigate around the Excel interface
• An in-depth look at formulas and functionsand when to use them
• Essential terms and vocabulary you must be familiar with in order to become a fluent excel user 
• Sorting and filtering data.Common mistakes that users make when using this function and how this could be used more efficiently.  
• Amazing charts and reportsis the best way of presenting data. We will take a look at how to create charts and reports that can be used in meetings or present your monthly income and expenditure. 
• Learn simple techniques to get your data message across clearly by making your worksheet presentable and less intimidating to others at work. 
• Pivot tables. What are they and the advantages of them over other excel functions with examples and exercises on how and when to use them
• What are Macros? This will be explained with examples of how and when they are used in excel?
• How are macros created? This leads to introducing what VBA programming is

Book 2) Pivot Tables

• The history of the Pivot table and the mechanics of how it works. 
• A step-by-step guide on when and how to use Pivot Tables. I will navigate you through examples. 
• Concepts you need to understand when you are working with Excel Pivot Tables such as generating reports with pivot tables. 
• The first steps of feeding data into the pivot table and techniques on advanced visualisation. 
• Find out the Various Functions You Can Undertake Using Pivot Tables such as creating a dynamic range of data. 
• Did you know that there are different types of Pivot tables such as a time tracking pivot table, which uses WEEKNUM function. 
• How pivot tables can create monthly reports and the other 8 functions of using Pivot Tables 
• The benefits of using Pivot Tables over other excel functions
• Include End of Chapter Exercises That Will Test Your Newly Acquired knowledge with answers included. 

And much more!

Don’t delay BUY TODAY scroll up, click the BUY button and start learning what EXCEL 2 BOOKS IN 1 has to offer!

Edition details

• Publisher: Independently published
• Publication date: 2019
• Language: English
• ISBN 10: 179522326X
• ISBN 13: 9781795223263
• Binding: Paperback
• Number of pages: 154