Basic MS Excel Training

Insights Training

Date Time: March 18, 2023 | 8:30 am
Time Zone: GMT+8:00 China Taiwan Time

Total Hours

3.5 Hrs

Learn the basics of MS Excel–skills that are important to use this tool and start your journey in learning this program.
No Paypal, no problem! Pls visit or email or chat for other payment options.
This training is on March 18, 2023; 8:30 AM-12NN Philippine Time via web meeting (Zoom.)
Module 1. Designing Your Worksheets
-Formatting Cells: Borders, Fill Colors, etc.
-Sorting and Filter
-Freeze Panes
-Hiding and Inserting Rows, Columns, and Sheets
Module 2. Essential Excel Functions
-Basic Arithmetic Formulas: SUM, AVERAGE, etc.
-Text Functions: UPPER, LOWER, CONCATENATE, etc.
-Math Functions: SUM, COUNTIF, SUMIF, etc.
-Absolute vs Relative Reference
-Basic Logical Functions: IF
Module 3. Data Tab and Formatting Tools
-Using Text- to- Columns to Separate Texts
-Applying Basic Conditional Formatting
-Creating Basic Dropdown Lists
Module 4. Introduction to PivotTables
-Creating PivotTables
-Formatting Fields
-Using Slicers to Filter Data

About the Event