Excel Experts


Training Objectives
The objectives of this course are:..

Understand Excel

Basic Excel

Intermediate Excel

Advanced Excel

Prerequisites
Basic Knowledge of Computers

Training Duration
20 Hours

Syllabus

Basic Excel

    • The Basics
      • Getting Started
      • Signing In
      • Creating a New Workbook
      • Parts of a Workbook
      • Saving a Workbook
      • Opening a Workbook
    • Your First Workbook
      • Selecting Data
      • Entering and Deleting Data
      • Using Undo and Redo
      • Using Cut, Copy, and Paste
    • Working with Data
      • Inserting Rows and Columns
      • Merging and Splitting Cells
      • Moving Cells
      • Using Paste Special
      • Using Find and Replace
      • Hiding and Unhiding Cells

Intermediate Excel

    • Using Excel Tools
      • Understanding Cell References and Formulas
      • Using Basic Formulas
      • Using Basic Functions
      • Using Advanced Functions
      • Using Spell Check
      • Using Sort and Filter
    • Using Timesaving Tools
      • Using AutoFill
      • Using Flash Fill
      • Using AutoSum
      • Using AutoComplete
      • Using AutoCalculate
    • Formatting Text
      • Changing the Font Face, Size, and Color
      • Applying Text Effects
      • Applying Borders and Fill
      • Using the Font Tab of the Format Cells Dialog
      • Clearing Formatting
    • Formatting Data
      • Wrapping Text
      • Changing the Size of Rows and Columns
      • Adjusting Cell Alignment
      • Changing Text Direction
      • Changing Number Format
    • Formatting the Workbook
      • Using Cell Styles
      • Formatting Data as a Table
      • Changing the Theme
      • Inserting Page Breaks
      • Adding a Background
    • Inserting Art and Objects
      • Inserting SmartArt
      • Inserting Text Boxes
      • Inserting Pictures
      • Inserting Equations
      • Drawing Shapes
    • Charting Data
      • Creating Sparklines
      • Inserting Charts
      • Inserting PivotTables
      • Inserting PivotCharts
      • Using Slicers
      • Creating Timelines
    • Viewing, Printing, and Sharing Your Workbook
      • Using Views
      • Saving a Workbook as PDF or XPS
      • Printing a Workbook
      • E-Mailing a Workbook
      • Sharing Your Workbook on OneDrive

Advanced Excel

  • Customizing the Interface
    • Changing Ribbon Display Options
    • Customizing the Quick Access Toolbar
    • Hiding and Showing Ribbon Tabs
    • Creating Custom Ribbon Tabs
    • Resetting Interface Changes
  • Using Macros
    • Recording a Macro
    • Writing a Macro using the Visual Basic Editor
    • Editing a Macro
    • Running a Macro
  • EXCEL DASHBOARD
    • Bar Charts / Pie Charts / Line Charts
    • Planning a Dashboard
    • Adding Tables to Dashboard
    • Adding Charts to Dashboard
    • Adding Dynamic Contents to Dashboard