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
- The VLOOKUP function
- The HLOOKUP function
- The SUMPRODUCT function
- The CHOOSE function
- Trace precedents/dependents tools
- 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
- Introducing macros
- Discovering two methods of recording a macro
- Securing the entire workbook using file
- protection options
- Protecting worksheets
- Protecting the workbook structure
- Data table
- Using goal seek
- Using scenarios
- Using solver
- 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
