Advanced MS Excel Training

Insights Training is a pool of traning consultants offering their courses at an affordable investment.  We believe that training must be affordable but effective (and fun!) at the same time.Visit our website at www.insightsmanila.com for more details.Our office is located at 7F Finman Bldg., 131 Tordesillas St., Salcedo Village, Makati.  You may reach us at info@insightsmanila.com, 0977.103.1800.

Insights Training

This interactive live training includes a thorough discussion of advanced functions and tools in MS Excel.

Mpower Learning Manila

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 <ul><li>lunch (fast food)</li><li>1 AM snack</li><li>1 PM snack</li><li>printed handout</li><li>printed certificate</li><li>overflowing coffee</li><li>WIFI access</li><li>BRING OWN LAPTOP</li></ul> IF VIA ZOOM<ul><li>PDF certificate</li><li>PDF handout</li></ul> Where in Cubao:Mpower Learning Manila222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City TIMEAll schedules are set at 8AM-5PM. However, if the headcount is low, the training may be set at 9AM-4PM or 9AM-5PM. Your certificate, still, will indicate 8 hours.The start time and end time will be finalized three days before the class. Please look for an email from inquire@insightsmanila.com or chat with us to confirm.

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<ul><li>Combining Texts (CONCATENATE)</li><li>Extracting Values from Texts (LEFT, RIGHT, MID)</li><li>Changing Case (UPPER, LOWER, PROPER)</li><li>Other Accessory Text Functions (TRIM, VALUE, SUBSTITUTE)</li></ul>Logical Functions<ul><li>Basic IF Statements</li><li>Nested and Series IF Statements</li><li>Combining Logical Statements with AND and OR</li></ul>Math Functions<ul><li>Basic Math Functions (SUM, AVERAGE, MAX, MIN, COUNT)</li><li>Named Ranges</li><li>Conditional Math Functions (COUNTIF, SUMIF, AVERAGEIFS, etc.)</li></ul>Shortening Long Formulas with Arrays Lookup Functions<ul><li>VLOOKUP</li><li>Advanced Usage of VLOOKUP</li><li>INDEX and MATCH</li></ul>Part 2. Managing Data Using Excel Tools Conditional Formatting<ul><li>Basic Conditional Formatting</li><li>Formula-Based Formatting</li></ul>Data Validation<ul><li>Basic Dropdown Menus and Cell Validations</li><li>Advanced Dropdown Menus</li></ul>Subtotal Tool Part 3. Analyzing and Presenting Data Using PivotTables<ul><li>Basic PivotTable Features</li><li>Refresh and Change Data Source</li><li>Grouping Data</li><li>Using Slicers</li><li>PivotCharts</li></ul>Part 4. Introduction to Macros (if time permits)<ul><li>Understanding Macro Security</li><li>Macro Recording</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}