Excel Data Analysis

Excel Data Analysis

Module: XL-101

  • Introducing Excel
  • Entering and Editing Worksheet Data
  • Worksheet Operations
  • Working with Cells and Ranges
  • Tables
  • Worksheet Formatting
  • Understanding Excel Files
  • Using and Creating Templates
  • Printing

Module: XL-102

  • Formulas and Functions
  • Formulas That Manipulate Text
  • Dates and Times
  • Formulas That Count and Sum
  • Formulas That Look Up Values
  • Formulas for Financial Applications
  • Miscellaneous Calculations
  • Array Formulas

Module: XL-103

  • Custom Number Formats
  • Data Validation
  • Worksheet Outlines
  • Consolidating Worksheets
  • Importing and Cleaning Data

Module: XL-104

  • Pivot Tables
  • Analyze Data with Pivot Tables

Module: XL-105

  • Getting Started Making Charts
  • Learning Advanced Charting
  • Visualizing Data Using Conditional Formatting
  • Creating Sparkline Graphics
  • Pictures and Drawings
  • Area, Bar, Bubble, Category, Column, Line, Pie, Radar, Stock, Surface, xy, Histogram, Pareto, Waterfall, Box ^ Whisker, Sunburst, Treemap

Module: XL-106

  • What-If Analysis
  • Goal Seeking and Solver
  • Analysis Tool Pack
  • Get & Transform

Leave your comment; I love them!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s