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 inquire@insightsmanila.com or send an SMS
to 09771031800. You can also chat with us via
www.facebook.com/InsightsManila
[https://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
Conditional Formatting
Applying Conditional Formatting
Data Bars, Color Scales, and Icon Sets
Data Validation
Creating BASIC DROPDOWN LISTS
Other Data Validation Options
Module 3. Introduction to PivotTables
Creating PivotTables
Modifying Value Field Settings
Grouping Data
culture
sports
909
Views
21/06/2019 Last update