Menu
Insights Training
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2019 Class Pics/ Clients
    • 2018 Class Pics / Clients
    • 2017 Class Pics / Clients
  • Testimonials
  • Self-Paced
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Laptops for Rent
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • DBSC Upload
  • Upload_infinitovba032021
  • upload_asurion
  • Upload Excel Public Class
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2019 Class Pics/ Clients
    • 2018 Class Pics / Clients
    • 2017 Class Pics / Clients
  • Testimonials
  • Self-Paced
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Laptops for Rent
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • DBSC Upload
  • Upload_infinitovba032021
  • upload_asurion
  • Upload Excel Public Class

Advanced MS Excel Training
​(1 Day Compressed)

inquire@insightsmanila.com
​0977.103.1800

Advanced MS Excel Training

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
  • Understanding Macro Security
  • Macro Recording
 

Join a public class

    We get booked fast.  Request a quote now.

Submit
Powered by Create your own unique website with customizable templates.