

Excel Level 2 - Mar 12, Mar 24, April 24
Microsoft Excel Level 2 Class
Service Description
Microsoft Excel Level 2 (2016, 2019, Office365) Course Description: Master advanced Excel techniques to enhance data analysis and presentation. Learn to create complex formulas, use specialized functions, protect your spreadsheets, and customize views for better decision-making. Course Content: Creating Advanced Formulas: Apply and Manage Range Names Use Range Names in Formulas Adding and Editing Range Names Use Specialized Functions: Function Categories and Syntax Excel Function Reference and Entry Dialog Boxes Nested Functions Workbook Calculations and Iterative Calculations Showing and Hiding Formulas Analyzing Data with Logical and Lookup Functions: Text Functions Logical Functions: AND, OR, IF Lookup Functions: VLOOKUP, HLOOKUP Date Functions Financial Functions: PMT, FV Create and Modify Tables: Table Components and Creation Table Tools and Styles Customizing Row Display Table Modification Options Sort and Filter Data: Sorting vs. Filtering Advanced Filtering and Filter Operators Removing Duplicates Use Subtotal and Database Functions: SUBTOTAL Functions Summary Functions in Tables Database Functions Visualizing Data with Charts: Creating and Modifying Charts Chart Types and Insertion Methods Resizing, Moving, and Adding Data Switching Between Rows and Columns
Upcoming Sessions
Contact Details
4313388726
BenninkTraining@shaw.ca
Winnipeg, MB, Canada