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
Purchase this course from our e commerce site at www.AuditExcel.com
|
Downloads and Free Trial
See how it
works with our
free Excel 2003
beginner course.
OR 
Convince you manager to pay for your education
OR 
More about the training material and how it works
Looking for something else? Search the site
|
.gif)
.gif)
