Menu
Insights Training
  • Home
  • 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
  • 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
  • Code Verifier
  • Blog
  • Home
  • 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
  • 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
  • Code Verifier
  • Blog

Basic Excel Training

inquire@insightsmanila.com
​0977.103.1800

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.

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 Tools
  • Text- to- Columns
  • Conditional Formatting
    • Applying Conditional  Formatting
    • Data Bars, Color Scales, and Icon Sets
  • Subtotal
  • Data Validation
    • Creating Basic Dropdown Lists
    • Other Data Validation Options

Module 3.  Introduction to PivotTables
  • Creating  PivotTables
  • Modifying Value Field Settings
  • Grouping Data

Related Courses

Advanced MS Excel

Macros and VBA Programming
Find Public Class
Download Outline
Send Email

    We get booked fast.  Request a quote now.

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