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/Online2 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.
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
Our Partners
