Microsoft Excel Course Information

Course: Microsoft Excel

Excel Course Information Structure
Excel For Business-An Overview
In the class, Microsoft Excel, you will learn time-saving ways of of using Microsoft Excel as a tool to calculate, store and retrieve, and analyze data. Also be able to access Excel’s Templates such as Invoices, Receipts, Certificates and other tools.

 

Course Levels Offered:
  • 2007/2010 Basic and Beyond
  • 2007/2010 Level 2
  • 2007/2010 Level 3 and Troubleshooting Tips
Class Goals and what you can expect to learn depending on class level:
  • Excel 2007/2010 Basic and Beyond
    • Navigating Excel
      • New Features to Excel
      • Exploring the Excel Ribbon and Tabs
      • Configuring and using the Quick Access Toolbar
    • Entering Data in Excel
    • Formatting data in Excel
    • Working with Excel formulas
      • Creating Excel formulas
      • Editing and troubleshooting Excel formulas
      • Locating additional Excel formulas
      • Displaying formulas
      • Copying formulas
    • Worksheet Formats and Management
      • Using Conditional formatting
      • Using Custom Formatting
      • Highlight data with color and borders
    • Insert/Delete Excel columns and rows
    • Adjust size of Excel columns and rows
    • Excel Features and Tools
      • Find
      • Sort
      • AutoFill
    • Excel Chart Tools
      • Creating Excel charts
      • Managing/Editing Excel charts
      • Formatting Excel charts
    • Printing Excel Worksheets
    • Keyboard Shortcuts
  • Excel 2007/2010 Level 2
    • Navigating Excel worksheets
    • Managing large worksheets
      • Freeze Pane
      • Split Pane
      • Vlookup & HLookup functions
    • Exploring Excel views
    • Copying Excel worksheets
    • Working with multiple worksheets
      • Linking Excel Data
      • Consolidating Excel Data
      • Inserting hyperlinks
      • Creating Named cell ranges
    • Using Excel Tables
    • Excel data range
    • Create Excel table
    • Sort and Filter data using Excel table
    • Analysis Tools:
      • Subtotals
      • Outlines
    • Inserting Graphics into an Excel Worksheet
      • Images
      • Pictures
      • SmartArt
      • ClipArt
      • Shapes
    • Worksheet Protection
      • Protect cells and worksheet data
    • Excel Templates
      • Excel Templates
      • Accessing Templates
      • Saving and organizing Excel Templates
    • Keyboard Shortcuts
  • Excel 2007/2010 Level 3 and Troubleshooting
    • Advanced Excel Tools
    • Pivot Tables
    • Pivot Table charts
    • Creating, managing and using Excel macros
    • Advanced Analysis Tools

      • Financial functions
      • Additional functions
      • Text functions
    • Data Analysis
      • Goal Seek
      • If functions
      • Logical functions
      • Troubleshooting functions
      • Data validation
      • Creating trendlines
      • Creating Sparklines
    • Integrating Excel data
      • Mail Merge
      • Using Excel data with Microsoft Access
      • Using Excel data with Microsoft PowerPoint
    • Keyboard Shortcuts
Intended Audience:
  • Business Professionals
  • Small Business Owners
  • Individuals
Class Prerequisites:
  • Basic Computer Navigation
Class Outline:
  • New Features/Tools (Office Button (Office 2007) or File Tab (Office 2010), Ribbon, Tabs/Groups
  • Spreadsheet Navigation and Components
  • Why Use Excel (Budgeting, Address Book or Database, Lists, Scenario finder, Goal Seek)
  • Fundamentals in creating a Budget
  • How to Find Excel Tools
  • Fundamentals in using Excel as a filter to analyze data
  • Fundamentals in using Excel as a filter to analyze data
  • Excel Templates and Small Business Tools
Class Duration:
  • 3 Hours
Addition sites and/or information concerning software: