Brightmoon Consulting & Training

  • Home
    • Gallery
    • Testimonial
  • Contact Us
  • Home
    • Gallery
    • Testimonial
  • Contact Us
Microsoft Excel Intermediate

Microsoft Excel 2010/ 2013 (Intermediate)

Duration: 2 Days
Contact Hours: 14

Course Mode

  • Lectures
  • Hands-on

Target Audience

  • Office administrator
  • Secretaries
  • Managers
  • General PC users who intend to enhance knowledge & ability to support more advanced features in Microsoft Excel

Benefits

  • Transform from raw data into desired message in the form of charts/ tables
  • Delegates are shown the strategy to uncover the solution

Course Overview

Conditional Formatting
  • Conditional format with data bars
  • Conditional format with icon sets
  • Conditional format with formulas
  • Conditional format with colour scales
  • Conditional format with cell rules

Function
  • Date & time function
  • Text function
  • Sum & count function
  • Information function
  • Lookup & reference function

Advanced Function
  • Using lookup functions: VLOOKUP, HLOOKUP, LOOKUP
  • Using logic function: IF, AND, OR, NOT

Managing data in list
  • Sorting database list
  • Filtering database list
  • Subtotal data
  • Using functions with lists
  • Using advanced filtering and AutoCalculate

Performing Calculation on Named Groups
  • Understand relatives and absolute reference
  • Naming methods
  • Creating and redefining range names
  • Creating formulas with range names

Data Validation
  • What is data validation?
  • Types of validation criteria

Data Analysis
  • Consolidate data in single workbook
  • Consolidate data in multiple workbook
  • Subtotal

Presenting Data in Charts
  • Overview of Excel charting features
  • Creating chart
  • Charts modifications

Pivot Table
  • Pivot table
  • Create pivot table

    I'm interested. Let's get connected.

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