Comprehensive Excel 2016 Training 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.
Course Objective Comprehensive Excel 2016 Training:
- Master Basic and Advanced functions in Microsoft Excel 2016
- Learn to effectively analyze data with excel tools.
Target Audience Comprehensive Excel 2016 Training:
- Students, MBA’s, BBA’s, Gradates & Post- graduates.
- Working Professionals from any business domain.
- Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker
- Anyone interested in more powerful features and functions of Microsoft Excel 2016
What are the pre-requisites for the Comprehensive Excel 2016 Training?
- Passion to learn and apply Microsoft Excel
- A computer with internet to view training material