Microsoft Excel 2019 – Advanced
Microsoft Excel 2019 – Advanced is designed for the participant who wants to leverage on the Advanced functions and features to improve productivity and enhance your spreadsheets to simplify your daily work activities.
You will learn how to use advanced functions such as text formulas, lookup functions, understand formula errors, Manage names, Consolidate data, organise and analysis data, create Pivot tables and macros.
Some of the Topics includes :-
- Using and Managing Defined Names
- Displaying and Tracing Formulas
- Understanding Formula Errors such as #N/A, #VALUE!, #REF!,#NUM!, #NAME?, or #NULL!
- Using Financial Functions such as PMT – it is a financial function that returns the periodic payment for a loan
- Using Logical Functions (IF, AND, OR, SUMIF, COUNTIF & etc)
- Using Lookup & Reference Functions (VLOOKUP, HLOOKUP, MATCH & INDEX)
- Using Text Functions (PROPER, CONCATENATE, UPPER, LEFT, RIGHT, TRIM, LEN & etc)
- Using Date & Time Functions
- Using Data Validation to control the data being accepted. The common types of validation options are whole number, text length, Drop list & etc.
- Creating Scenarios & Scenario Report
- Working with Data Tables
- Using Goal Seek & Solver
- Using Text to Columns
- Grouping and Outlining Data & Using Subtotals
- Consolidating Data by Position or Category
- Consolidating Data Using Formulas
- Sharing a Workbook & Track changes
- Compare and Merge Workbook
- Creating & Specifying PivotTable Data
- Changing a PivotTable’s Calculations
- Working with PivotTable Layout
- Grouping PivotTable Items & Updating a PivotTable
- Creating a PivotChart & a Standalone PivotChart
- Use Slicers
- Sharing Slicers Between PivotTables
- Creating Relationships between Tables
- Recording a Macro
- Playing and Deleting a Macro
- Adding a Macro to the Quick Access Toolbar
For learners who need to enhance productivity by automating repetitive tasks or simplify the complex task, you may consider to attend the Visual Basic for Applications in Microsoft Excel – Fundamental. Learn Macros and the programming knowledge behind the Excel programs.