Menu
Insights Training
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • MS Office Training
  • >
  • Basic Excel Training (1 Day)

Basic Excel Training (1 Day)

  • Facebook
  • Twitter
  • Pinterest
  • Google+
₱999.00
₱999.00
Unavailable
per item
SKU:
Add to Cart
This module contains the most essential formulas and tools in MS Excel.

Who is this for: General non-heavy users of MS Excel

Topics:
​
I.  Essential Excel Functions
  • Basic Arithmetic Formulas: SUM, AVERAGE, etc.
  • Text Functions: LEFT, RIGHT, CONCATENATE, etc.
  • Math Functions: COUNTIF, SUMIF, RANK, etc.
  • Basic Logical Functions: IF
  • Basic Lookup Functions: VLOOKUP
 
II.  Data Management
  • Text- to- Columns
  • Conditional Formatting
    • Applying Conditional  Formatting
    • Data Bars, Color Scales, and Icon Sets
  • Flash Fill
  • Subtotal
  • Consolidate Tool
  • Data Validation
    • Creating Basic Dropdown Lists
    • Other Data Validation Options
               
III.  Charting
  • Review of Basic Chart Elements
    • Gridlines
    • Axes
    • Data Tables
    • Data Labels
    • Legends
 
VII.  Introduction to PivotTables
  • Creating  PivotTables
  • Modifying Value Field Settings

Email us to reserve your class: [email protected]
Or contact us at 0977-103-1800

Home

Courses

Public Classes

Contact

Copyright © 2022