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.
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.
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
Subtract in Excel
Multiply in Excel
Divide in Excel
Learn more about simple formulas
Use AutoSum
Avoid rewriting the same formula
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
Arithmetic Operators
Comparison Operators
Text Concatenation Operator
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
Freeze Row
Freeze Column
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
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
Registration
Join to become PRO