Mastering Excel Formulas and Functions

Program Period

Duration: 2-days

Targeted Audience:

This course is tailored for individuals with foundational Excel knowledge who seek to harness higher-level Excel functionalities.

Prerequisites:

Participants should possess basic Microsoft Excel proficiency with the following prerequisites:

• Navigate using the mouse – Point, Click, Drag, and Double Click
• Switch between task applications
• Create a spreadsheet with simple formatting
• Perform actions such as “Create,” “Save,” “Open,” and “Print” on a spreadsheet
• Utilize the “Undo” function
• Insert and delete Rows & Columns
• Print a spreadsheet with applied headers and footers
• Insert, delete, and rename worksheets
• Create basic formulas (addition, subtraction, multiplication, division)
• Use basic functions (Sum, Average, Count, Max, Min)

Module 1: $ Symbols in Formulas & Functions

Module 2: Effective Formatting and Logical Functions

Module 3: Date Formulas

Module 4: Handling Text Data, Database, and Subtotal Functions

Module 5: Searching Data with VLOOKUP Functions

Module 6: Data Consolidation and Protection