Course Content

Formulas & Functions

  • Lookup Functions: VLOOKUP, HLOOKUP
  • Logical Functions (Advanced): IF (Nested IFs), AND, OR, NOT
  • Statistical Functions: AVERAGEIFS, COUNTIFS, SUMIFS
  • Financial Functions (Intro): PMT (Loan Payments), NPV (Net Present Value)
  • Text Manipulation: Combining Text Functions for Complex Tasks
  • Error Handling: Using IFERROR to Manage Errors in Formulas

Conditional Formatting

  • Icon Sets: Adding Icons to Data Based on Values
  • Custom Conditional Formatting: Using Formulas to Define Rules
  • Managing Conditional Formatting Rules: Editing and Deleting Rules

Sort & Filters

  • Advanced Filtering: Using Multiple Criteria, Wildcards
  • Custom Filters: Creating Custom Filter 
  • Criteria Filtering with Formulas: Using Formulas in Filter Criteria

Pivot Tables

  • Creating Pivot Tables: Summarizing Data with Drag-and-Drop Interface
  • Formatting Pivot Tables: Changing Layout, Number Formats
  • Grouping Data: Grouping Dates, Numbers, and Text
  • Calculated Fields: Adding Custom Calculations to Pivot Tables

Charts

  • Advanced Charting: Creating Combo Charts, Scatter Plots, Bubble Charts
  • Customizing Charts: Formatting Chart Elements, Adding Images
  • Chart Templates: Saving Custom Chart Formats

Course Content

No content available. Please add it via the ACF field.

COURSE SCHEDULE & FEES

FEB
28
FRI
2:00 PM - 5:00 PM
Training Session
Online
Online Session
6253
Inclusive of all taxes

DOWNLOAD COURSE CONTENTS

Please click the button below to download the course content. You'll need to provide your contact information to receive the document.

×

Download Course Content

Please fill out the form below to download the course content PDF.

INCOMPANY/GROUP TRAINING REQUEST

Why Choose Our Incompany Program?

  • 🎯 Tailored content specific to your business goals
  • 👥 Train entire teams together, saving time and cost
  • 📍 Delivered at your location or virtually
  • 📅 Flexible scheduling to suit your timelines
  • 📈 Increase retention and application of skills


    Current topic: [decoded_course_title]

    Any customisation Required