Excel 2007 Training

This course is included (as well as over 60 others) in every subscription!
Description
Materials

Who it's for:  Office workers, business people, teachers, support staff, and anyone who wants to use the computer to track, figure out, and report information.

What it is:  Excel is the world’s most popular spreadsheet program. Millions of people use it to track, store, arrange and calculate data.

What you'll learn:  Our Excel course is designed for beginners and advanced users alike. Students learn how to easily work with data and use Excel’s hidden features. You’ll learn about spreadsheet design, manipulating data, and about how to utilize the world’s most popular business tool.  

Excel Beginner

Module 1: Introduction to Excel Module 2: Working with Formatting and Functions
  • Introduction to Excel
  • Navigating Worksheets
  • Quick Access Toolbar
  • Customize Quick Access Toolbar
  • Interactive Guide to the Ribbon
  • Navigating a spreadsheet
  • Save-As choices
  • Convert 2003 to 2007 format
  • Select multiple cells
  • Undo
  • Review
  • Numbers vs Math
  • New Workbook file
  • Build New Workbook
  • Entering Data
  • Format #s and text
  • Bad Formulas
  • Autofill formulas
  • Functions
  • Compatibility Checker
  • Save the file
  • Relative vs Absolute References
  • Auto Fill Tricks
  • Fill several cells at once
  • Sum, Max, Min
  • Entering Formula
  • Autofill Functions
  • Function vs. Formula
  • Insert row, fix formulas
  • Columns
  • Move & copy data
  • Copy & Paste
  • Insert Sheet
  • Autofill a Series
  • Autofill Numbers
  • Cell Formatting
  • Number Formats
  • Formatting Text
  • Format as Table
  • Templates
  • Formatting Multiple Sheets
  • Copying Entire Sheets
  • Spell-check
  • Convert Table to Range
  • Freeze Panes
  • More Freezing Panes
  • Page Layout View
  • Repeating Rows
  • Page Setup
Sign up to view this video Video Description Sign up to view this video Video Description

Excel Intermediate

Module 3: Data and Charts Module 4: Additional Queries, & Importing/Exporting Data Data
  • Well Defined List
  • Sorting
  • Sort by Multiple Fields
  • Auto Filters
  • Checkbox Filters
  • Removing Duplicates
  • Subtotal by One Field
  • Subtotal 2nd field
  • Subtotals at top
  • Format as Table
  • Color to Table
  • Total Row
  • Column Chart
  • Row Vs. Column
  • Format Series vs. Point
  • Color Gradient
  • Add Chart Title
  • Deleting Columns
  • Line chart
  • Data labels
  • Making pie charts
  • Saving Chart Template
  • Using Chart Template
  • Printing Charts
  • Import from Access
  • Update in Access
  • Update in Excel
  • MS Query
  • Import Link to Text
  • Pivot Table
  • Multiples in pivot table
  • Formatting Pivot Tables
  • Report Filter
  • Table and Pivot Table
  • Filtering in Pivot Tables
  • Linking cells between Workbooks
  • Link by formula
  • Link by pasting
  • Totals From Other Workbook
  • Custom views
  • Finding Top 3
  • Thresholds
  • Color Scales
  • Traffic Light Icons
  • Data Validation
  • Validation Boundaries
  • Conditional Format
  • Protect sheet
  • Password protect the Excel file
Sign up to view this video Video Description Sign up to view this video Video Description

Excel Advanced

Module 5: Formulas and LookUp Actions Module 6: Creating Reports
  • Named Ranges
  • Create Names from Selection
  • IF  Function
  • Formula auditing arrows
  • If with number answers
  • Date functions
  • The TODAY function
  • VLookup
  • Adjust for other columns
  • VLookup with TRUE
  • HLookUp
  • D-functions for databases
  • Changing Criteria
  • DAverage
  • Text parts
  • Concatenation
  • Formula that Concatenates
  • Paste as Values/Tex to Columns
  • Open Template
  • Goal Seek
  • Goal Seek with Percent
  • Install the Solver
  • Constraints
  • Maximum Shipping
  • Exact Solution
  • Data Table
  • 2-Variable Data Table
  • Scenarios
  • Consolidate
  • Consolidations
  • Absolute References in macros
  • Running Macro
  • Understanding Relative Macro
  • Visual Basic Editor
  • Relative Reference Macro
  • Relative macro VBasic
  • Bad Relative Macro & Solution
  • Macro Keyboard Shortcut
  • Macro Buttons
  • Save as Macro-enabled workbook
Sign up to view this video Video Description Sign up to view this video Video Description

Included in your 'all you can eat subscription' access to over 200+ modules, including these...

Title for other trust builders:

Over 450,000 students since 1996

17 years teaching software to industry leaders

100% 7-day money back guarantee

Feel secure: Ask a teacher if you have questions

Classroom Training available in Downtown San Francisco - 33 New Montgomery, SF CA 94102