ONLINE- Excel 2007 Advanced Training Series- 12 hrs
 

ONLINE- Excel 2007 Advanced Training Series- 12 hrs

SKU EXCEL-2007-ADVANCED-TRAINING-SERIES
Skill Level Required to enjoy this course: Intermediate

Summary:
Gain the required Excel 2007 Advanced knowledge to create complex business applications in Microsoft Excel. This series will teach you to analyse data, use formulae and apply filters.
Audience:
Anyone interested in learning about advanced data analysis features of Excel 2007.
Excel 2007 Advanced: Filtering and Sorting Data 2 hrs
  • Removing duplicate records in Excel 2007
  • Using Excel 2007 filters
  • Setting filter options
  • Data Sorting
  • One-click and custom sorting
Excel 2007 Advanced: Using Pivot Tables 2 hrs
  • Creating Excel 2007 Pivot Tables
  • Viewing Pivot Tables
  • Pivot Tables Formatting
  • Grouping and Filtering Data in Pivots
  • Exploring Pivot Tables

Excel 2007 Advanced: Working with Functions 3 hrs

  • Using Excel 2007 functions
  • Math Functions
  • Date and time functions in Excel
  • Adjust text with Excel functions
  • Decisions with logical functions
  • Testing with information functions
  • Using  lookup functions to find data
  • Financial functions and calculating payments
  • Determining relationships with statistical functions
Excel 2007 Advanced: Using Data Analysis Tools 1 hr
  • What-If Analysis in Excel 2007
  • Creating Scenarios with Scenario Manager
  • Using Goal Seek
  • Exploring Solver
Excel 2007 Advanced: Automating with VBA Macros 2 hrs
  • Setting VBA security
  • Recording Macros and Running them
  • Use of the End Key
  • Filtering via Macros
  • Understanding VBA Code
  • Writing Macros
  • Controlling and Combining Macros
Excel 2007 Advanced: Adding Connections and Importing Data 2 hrs
  • Connecting Worksheets
  • Connecting Workbooks
  • Connecting to Data from a Web Page
  • Connecting to a Text File
  • Connecting to a Database
    Your Price $125.42
    Quantity
     

    Customer Reviews


    Write A Review