No Paypal, no problem! Pls visit https://bit.ly/insightjoin or email inquire@insightsmanila.com or chat www.facebook.com/InsightsManila 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