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
- Converting text, validating and consolidating 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 pivot table
- Adding fields to a pivot table
- Removing fields from a pivot table
- Changing the layout of a pivot table
- Selecting pivot table data
- Modifying pivot tables
- Grouping pivot table data
- Hiding and showing source details
- Understanding calculated fields
- Adding page fields
- Displaying a specific page
- Displaying page fields on separate sheets
HNI Partners
Our Partners
We are proud to collaborate with leading organizations that share
our commitment to excellence and growth.
our commitment to excellence and growth.
