Advance Ms Excel

In-Person/Online

2 Days

English/Arabic

Learning Objectives

Use the restricting input with data validation, importing data and naming ranges.
Illustrate the uses of different advanced excel functions.
Identify pivot tables, adding calculated field, and formatting pivot tables.
Utilize trace precedents/dependents tools.
Determine the essentials of data management to import and export data in excel.
Explain macros and how to use them in excel.
Comprehend the “what-if” functions and how to use them beneficially.

In-Person/Online

2 Days

English/Arabic

Learning Objectives

Modules

Module 1: Advanced Excel Functions

The VLOOKUP function
The HLOOKUP function
The SUMPRODUCT function
The CHOOSE function
Trace
Precedents/dependents tools

Module 2: Data Management in Excel

Importing and exporting data in excel
Convert text and validate and consolidate data
Exporting excel data tables & charts to word
Linking excel data tables & charts in word
Exporting excel data tables charts to PowerPoint
Linking excel data tables and charts in powerpoint
Exporting excel workbooks to other systems

Module 3: Macros Management

Introducing macros
Discovering two methods of recording a macro

Module 4 : Protecting Worksheets and Workbooks

Securing the entire workbook using file
protection options
Protecting worksheets
Protecting the workbook structure

Module 5: What If Functions

Data table
Using goal seek
Using scenarios
Using solver

Module 6: Working With Pivot Tables

Creating pivot tables
Editing pivot tables:
- Updating information in a pivotable
- Adding fields to a pivotable
- Removing fields from a pivotable
- Changing the layout of a pivotable
- Selecting pivotable data
Modifying pivot tables
- Grouping pivotable data
- Hiding and showing source details
- Understanding calculated fields
- Adding page fields
- Displaying a specific page
- Displaying page fields on separate sheets