Excel 2016 - The Ultimate Microsoft Excel Course

Join the Comprehensive Excel 2016 Training from edu CBA and learn basic and advanced excel functions. Knowing excel is must in this worrld and this course will help you to work with data more effectively. You will learn about starting with excel, Excel Ribbons, quick access toolbar, different tabs in excel, how to use data functions, work with texts, pivot tables, important excel tools and new charts option in Advanced Excel 2016.

You will learn in detail about:

• How to start the excel sheet and various shortcuts associated with it.
• How to apply useful excel functions
• Learn Data entry in excel using Excel functions.
• Learn about various calculation indicators and their use.
• Learn how to format your data using various Formatting functions
• Learn about Pie charts and pivot tables in details.
• Learn data functions such as Choose function, VLOOKUP, HLOOK UP, Match and index, database function, offset, forecast function
• Learn what if analysis using one dimensional, two dimensional data tables, solver and goal seek.
• Know how to use and apply array function, transpose and frequency
• Learn about various important excel tools such as Text to Columns, Grouping Tabs, Subtotal Function, Hyperlinks, Data Validation, Random Numbers, Custom View etc
• The final section deals with charts. Here you will get to learn about the New charts in Excel 2016 such as the waterfall chart, box & whisker chart, tree map chart and sun burst chart.