top of page

Introduction

Be a Spreadsheet Pro with Excel, is a 12-session series.  Slot 1. learn to format your spreadsheet like a pro with Effective Formatting. Learn Excel formula concepts in Slot 2. Slot 3, learn to search data effectively and in the second part, learn Data Analysis. Slot 4, Explore useful Excel features.

Final-FBlive_edited.jpg
Projects: Projects

Effective Formatting

June 23, 2021 8.30PM

Formatting Essentials

  • Format Painter 

  • Quick view for Formatting shortcut 

  • Basic Format cell setting 

  • Alignment Format 

  • More detail about Date Format & Number Format 

  • Cell Styles 

June 30, 2021 8.30PM

Custom Format Using Format Cell Code

  • Understand Format Cell Code 

  • Number Formatting 

  • Text Formatting 

  • Date Formatting 

  • Time Formatting 

  • Format Color Code 

  • Format leading zeros 

July 7, 2021 8.30PM

Conditional Formatting

This is your Schedule Item. Provide details about the event or activity, where it’s located and any other relevant information for your visitors. Add photos to make it shine.

Projects: Schedule

Excel Formulas Concept

August 4, 2021 8.30PM

Overview of formulas in Excel

  • Create a formula that refers to values in other cells

  • See a formula

  • Enter a formula that contains a built-in function

  • Use Excel as your calculator

  1. Subtract in Excel

  2. Multiply in Excel

  3. Divide in Excel

  4. Learn more about simple formulas

  5. Use AutoSum

  6. Avoid rewriting the same formula

  7. What can I use in a formula to mimic calculator keys?

August 11, 2021 8.30PM

Calculation Operators and Precedence in Excel

  • Types of operators

  1. Arithmetic Operators

  2. Comparison Operators

  3. Text Concatenation Operator

  4. Reference Operators

  • The order in which Excel performs operations in formulas

  • How Excel converts values in formulas

August 18, 2021 8.30PM

Switch Between Relative, Absolute and Mixed References

  • Relative References

  • Absolute References

  • Mixed References

  1. Freeze Row

  2. Freeze Column

Projects: Schedule

Searching and Analyzing Data

July 14, 2021 8.30PM

Combining VLOOKUP with other Tools & Functions

  • The main Concept of VLOOKUP

  • Performing Dynamic VLOOKUP

  • Simplify the Database

  • VLOOKUP Rounded Numbers

  • VLOOKUP Repeated Items

  • Retrieve Continuous Information

July 21, 2021 8.30PM

PivotTable: Part 1 – The Essentials

  • 10 Things that you Must Know as a PivotTable user

July 28, 2021 8.30PM

PivotTable: Part 2 – Adding Formulas to Further Analyse Data

  • Modifying the Standard Calculations

  • Modifying the Advanced Calculations to Analyse the Report

  • Writing Formulas in Raw Data

  • Solving a Common Miscalculation in PivotTable

Projects: Schedule

Useful Excel Features that you should Explore

August 25, 2021 8.30PM

Consolidate Data in Multiple Worksheets and Protection

  • Ways to Consolidate Data

  • How to Consolidate?

  • Use Formula

  • Worksheet Protection

  • Workbook Protection

September 1, 2021 8.30PM

Data Validation

  • What is data validation?

  • Types of validation

  • Validation Error

  • How to create validation?

  • Validation with formula

September 8, 2021 8.30PM

Array Formula & Data Table

  • A single-cell array formula

  • A multi-cell array formula in Excel

  • Using an Excel array function to return a multi-cell array

  • Data Table

Projects: Schedule
The-Microsoft-Excel-Course-Advanced-Exce

Registration

Join to become PRO

Choose your course:

Thanks for submitting! Our admin will contact you shortly!

Projects: Sales Lead
bottom of page