Best Excel Training Online in Dubai, Toronto, Riyadh and Jeddah

Excel

MOS Excel 2016 – Excel 77-727

Core Data Analysis, Manipulation and Presentation

This course prepares the students with the technical skills and knowledge to take Microsoft Certification Exam 77-727: Excel 2016 Core Data Analysis, Manipulation and Presentation, we provide you with the resources including study materials, skills management systems access for practice and simulations that will not only help you pass the exam but also ensure that you will be more effective and productive and gain valuable skills that help you succeeds in your career.

By the end of the course student will be able to accomplish the following technical skills :

01. Create and Manage Worksheets and Workbooks

1.1.Format worksheets and workbooks
1.2.Customize Options and views for worksheets and workbooks
1.3.Configure worksheets and workbooks for distribution

03. Create Tables

3.1.Create and Manage Tables.
3.2.Manage Table Styles and Options
3.3.Filter and Sort a Table.

05. Create Charts and Objects

5.1.Create Charts
5.2.Format Charts
5.3.Insert and Format Objects.

02. Manage Data Cells and Ranges

2.1.Insert date in cells and ranges
2.2.Format cells and ranges.
2.3.Summarize and organize data

04. Perform Operations with Formulas and Functions

4.1.Summarize Data by using Functions.
4.2.Perform Conditional Operations by using Functions
4.3.Format and Modify Text by using Functions.

MOS Excel 2016 – Excel Expert 77-728

Interpreting Data for Insights

This course prepares the students with the technical skills and knowledge to take Microsoft Certification Exam 77-728: Excel 2016 Expert: Interpreting Data for Insights.
We provide you with the resources including study materials, skills management systems access for practice and simulations that will not only help you pass the exam but also ensure that you will be more effective and productive and gain valuable skills that help you succeeds in your career.

By the end of the course student will be able to accomplish the following technical skills :

01. Manage Workbooks

1.1.Save a workbook as template
1.2.Copy macro between workbooks
1.3.Reference data in anther workbook
1.4.Reference data by using structured references
1.5.Enable macros in a workbook
1.6.Display hidden ribbon tables

03. Apply Custom Data formats and Validation

3.1.Create custom number formats
3.2.Populate cells by using advanced fill series options
3.3.Configure data validation

05. Prepare a Workbook for Internationalization

5.1.Display data in multiple international formats
5.2.Apply international currency formats
5.3.Manage multiple options for body and heading fonts

07. Apply Advanced Date and Time Functions

7.1.Reference the data and time by using NOW and TODAY functions
7.2.Serialize numbers by using date and time functions

09. Troubleshoot Formulas

9.1.Trace precedence and dependence
9.2.Monitor cells and formulas by using the watch window
9.3.Validate formula by using error checking rules
9.4.Evaluate formulas

11. Create Advanced Charts

11.1.Add trendlines to charts
11.2.Create dual –axis charts
11.3.Save chart s a template

13. Create and Manage Pivot Charts

13.1.Create Pivot Charts
13.2.Manipulate options in existing Pivot Charts
13.3.Apply styles to Pivot Charts
13.4.Drill down into PivotChart details

02. Manage Workbook Review

2.1.Restrict editing
2.2.Protect a worksheet.
2.3.Configure formula calculation options
2.4.Protect workbook structure
2.5.Manage workbook versions
2.6.Encrypt workbook with a password

04. Apply Advanced Conditional Formatting and Filtering

4.1.Create custom color formats
4.2.Create and modify cell styles
4.3.Create and modify simple macros
4.4.Insert and configure form controls

06. Lookup Data by using Functions

6.1.Lookup data by using VLOOKUP
6.2.Lookup data by using HLOOKUP
6.3.Lookup data by using MATCH
6.4.Lookup data by using INDEX

08. Perform Data Analysis and Business Intelligence

8.1. Import, transform, combine, display, and connect to data
8.2.Consolidate data
8.3.Perform what if analysis by using Goal Seek and Scenario Manager
8.4.Use cube functions to get data out of the excel data model
8.5.Calculate data by using financial functions

010. Define Named Ranges and Objects

10.1.Name Cells
10.2.Name data ranges
10.3.Name tables
10.4.Manage named ranges and objects

012. Create and Manage PivotTables

12.1.Create PivotTables
12.2.Modify field selections and options
12.3.Create slicers
12.4.Group PivotTable data
12.5.Reference data in a PivotTable by using the GETPIVOTDATA function
12.6.Add calculated fields
12.7.Format data