Elite Crystal Hotel P.O. Box 11180 , Kingdom of Bahrain , Tel - +973 36805551
Please contact us at firstname.lastname@example.org
This course will teach you how to analyse and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. You will also learn how to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
1. Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
2. Using Goal Seek, Solver and VLookup
Setting up the Worksheet
Using Goal Seek
Generating Reports and Scenarios with Solver
Setting Solver Options
3. Analyzing Data
Enabling the Analysis ToolPak
Using Data Analysis Tools
Using Data Tables
4. Managing Data
Configuring Data Validation
Converting Text to Columns
5. Using the Inquire Add-In
Generating a Workbook Analysis Report
Viewing Workbook and Worksheet Relationships
Viewing Cell Relationships
Comparing Two Workbooks
6. Working with Slicers
Inserting and Using a Slicer
Renaming the Slicer
Changing Slicer Settings
Formatting a Slicer
Clearing the Slicer
7. Forecasting Data
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Creating a Scenario Summary Report
Use the Goal Seek Feature
Forecasting Data Trends
8. Introducing Power View
Enabling Power View
Creating a Power View
Adding and Removing Fields
Choosing a Visualization
Changing Tile Display
Setting Display Options
9. PivotTable Features
Creating a Basic PivotTable
Creating a Basic PivotChart
Using the PivotTable Fields Pane
Adding Calculated Fields
Sorting Pivoted Data
Filtering Pivoted Data
10. Introducing PowerPivot
Importing Access Data
Importing Excel Data
Integrating Data with Relationships
Creating a PivotTable with PowerPivot Data
11. Automating Workbook Functionality
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Gain Industry Relevant Skills : Learn Advance Excel skills and techniques which are applicable to any industry.
Career Growth : The program will be a great value-add to your resume, which can help you pursue a promising career
Enhanced Job Opportunities : Get hired as Data Analyst, Business Analyst, Operations Manager, Financial Analyst, Accountant, Sales and Marketing & HR Specialist etc.
Discuss Industry Trends : Live Web based sessions (classes) with faculty for discussion on current industry trends and doubt clearance of concepts.
Learn Data Analysis Techniques : Learn through case studies which explain data analysis in a real time scenario.
Prep for Microsoft Office Specialist Exam : The program is oriented towards preparing you for Microsoft Office Specialist certification exam.
Advanced Excel 2016 course is recommended for end users seeking proficiency in the use of Microsoft Excel 2016 at an advanced level or seeking to obtain Microsoft Office Specialist certification in Microsoft Excel 2016 at Expert level or an equivalent, A must for every professional from entry to senior level managers in any industry, Management graduates, For students aspiring for entry level jobs in any domain this is mandatory.
What version of Excel is used in Graspskills Training & Consulting Pvt Ltd.
Microsoft Excel 2016 is currently used by most of the classroom, online and corporate Training sessions.
BHD 529 (USD 1401)
BHD 449 (USD 1189)
Upto: 01st Mar 2018