Skip to product information
1 of 1

MASHED AVOCADO

Australia | AEDT | MS Excel Online Live Workshop for Beginners

Australia | AEDT | MS Excel Online Live Workshop for Beginners

Regular price $120.00 AUD
Regular price $180.00 AUD Sale price $120.00 AUD
Sale Sold out
Shipping calculated at checkout.
Date

Live workshop via Google Meet

This workshop is for Individuals with no prior experience with Microsoft Excel.

  • Gain a foundational understanding of the Excel interface and its key components.
  • Master basic formatting techniques to enhance data presentation.
  • Apply essential Excel functions for various calculations and data manipulation.
  • Utilize lookup functions (VLOOKUP and XLOOKUP) to efficiently retrieve data.
  • Explore the power of PivotTables for data summarization and analysis.
  • Create impactful charts and graphs to visually represent data.
  • Understand the basic functionalities of Solver for optimization.
  • Implement conditional formatting for automatic data visualization and highlighting.

Course Structure:

  • Module 1: Introduction to Excel: Getting started, Navigating the spreadsheet, Entering and editing data.
  • Module 2: Basic Formatting: Cell formatting, Conditional formatting
  • Module 3: Essential Excel Functions: Mathematical functions, logical functions, Date & Time functions, 
  • Module 4: Lookup Functions: VLOOKUP, XLOOKUP
  • Module 5: PivotTables and Charts: Creating Pivot tables, Analysing data, creating charts. Best practices while presenting charts.
  • Module 6: Advanced Topics: Solver, Data Validation

Please note: You will receive a separate email invitation for this workshop in the coming days. Please accept the invitation to ensure it is added to your calendar.

View full details