top of page

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


Get In Touch

Bennink Training

Winnipeg, Manitoba
Phone: (431) 338-8726

Email: BenninkTraining@shaw.ca

  • Facebook
  • Twitter
  • Instagram
  • YouTube

© 2024 Bennink Training. All Rights Reserved.

We've Received Your Message!

bottom of page