USA | EST | MS Excel Online Live Workshop for Beginners
USA | EST | MS Excel Online Live Workshop for Beginners
Regular price
$113.00 CAD
Regular price
$169.00 CAD
Sale price
$113.00 CAD
Unit price
per
Live workshop via Google Meet
3 x 2 hour sessions
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.