Excel 2007

This course is included (as well as over 200 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 2007 Beginner

Sign up to view this video Video Description
  • 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 Numbers 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
 

Excel 2007 Intermediate

Sign up to view this video Video Description
  • 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
 

Excel 2007 Advanced

Sign up to view this video Video Description
  • 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/Text 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

Related Courses

Why Choose Anytime

Over 450,000 students since 1996

Over 20 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