About this Event
T his training will review and strengthen the basics of Excel and enhance this further with knowledge of advanced functions and tools of the program.
IF FULL DAY CLASS, JOIN IN CUBAO
- lunch (fast food)
- 1 AM snack
- 1 PM snack
- printed handout
- printed certificate
- overflowing coffee
- WIFI access
- BRING OWN LAPTOP
IF VIA ZOOM
- PDF certificate
- PDF handout
Where in Cubao:
Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City
INCLUSIONS if joining via Zoom
- PDF handouts
- PDF certificate
Outline
This training includes a thorough discussion of the advanced topics. Participants will be exposed to various practical and complicated scenarios.
Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365, Microsoft 365
Part 1. Basic to Advanced MS Excel Functions
Text Functions
- Combining Texts (CONCATENATE)
- Extracting Values from Texts (LEFT, RIGHT, MID)
- Changing Case (UPPER, LOWER, PROPER)
- Other Accessory Text Functions (TRIM, VALUE, SUBSTITUTE)
Logical Functions
- Basic IF Statements
- Nested and Series IF Statements
- Combining Logical Statements with AND and OR
Math Functions
- Basic Math Functions (SUM, AVERAGE, MAX, MIN, COUNT)
- Named Ranges
- Conditional Math Functions (COUNTIF, SUMIF, AVERAGEIFS, etc.)
Shortening Long Formulas with Arrays
Lookup Functions
- VLOOKUP
- Advanced Usage of VLOOKUP
- INDEX and MATCH
Part 2. Managing Data Using Excel Tools
Conditional Formatting
- Basic Conditional Formatting
- Formula-Based Formatting
Data Validation
- Basic Dropdown Menus and Cell Validations
- Advanced Dropdown Menus
Subtotal Tool
Part 3. Analyzing and Presenting Data Using PivotTables
- Basic PivotTable Features
- Refresh and Change Data Source
- Grouping Data
- Using Slicers
- PivotCharts
Part 4. Introduction to Macros (if time permits)
- Understanding Macro Security
- Macro Recording
Event Venue & Nearby Stays
Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines
PHP 262.48 to PHP 2518.71
