Photo above and information below are provided by event organizer verbatim.
This training is for novice users of MS Excel who wishes to learn the fundamentals of the tool. It aims to prepare participants for advanced discussion in MS Excel.
For inquiries, contact us at firstname.lastname@example.org or send an SMS to 09771031800. You can also chat with us via www.facebook.com/InsightsManila
Module 1. Essential Excel Functions
Basic Arithmetic Formulas: SUM, AVERAGE, etc.
Text Functions: LEFT, RIGHT, CONCATENATE, etc.
Math Functions: SUM, COUNTIF, SUMIF, RANK, etc.
Absolute vs Relative Reference
Basic Logical Functions: IF
Basic Lookup Functions: VLOOKUP
Combining Functions (Basic)
Essential Excel Shortcut Keys
Module 2. Data Management
Text- to- Columns
Applying Conditional Formatting
Data Bars, Color Scales, and Icon Sets
Creating Basic Dropdown Lists
Other Data Validation Options
Module 3. Introduction to PivotTables
Modifying Value Field Settings