Excel 2007: Essentials

Excel 2007: Essentials


Total Run Time: 4 hrs 38 min

This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!

This title is available in the
Total Training All-Access library.

Subscribe Now

SKU: N/A Categories: , , ,


Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers.

Sample clip

Course outline

Introducing the Ribbon User Interface
Introducing Workbooks & Worksheets
Introducing the Formula Bar
Saving with Different File Extensions
Customizing the User Interface

Getting Data into Excel
Importing Text Files
Using the Freeze Panes Functionality
Using the Zoom Functionality
Using Hot Keys
Managing Rows & Columns
Finding Data
Matching Case & Entire Cell Contents
Replacing Data
Finding & Replacing Empty Values
Sorting Data
Sorting Multiple Columns
Filtering Data

Formatting Numbers & Dates
Formatting Cells
Setting the Font Type, Color & Size
Using Borders & Cell Styles
Adding Shapes & Pictures
Creating WordArt

Lesson 04 FORMULA BASICS 33:52
Constants, Formulas & Cell References
Understanding the Order of Operations
Using Formulas with Dates & Text
Linking Cells & Using Comparison Operators
Creating an Absolute Reference
Defining Named Ranges
Exploring the Function Library
Using the AutoSum Function

Lesson 05 USEFUL FUNCTIONS 39:56
Using the INT Function
Using the Rounding Function
Using the ABS Function
Using the SUBTotal Function
Using Logical Functions
Using the AND & the OR Function
Using LEFT, RIGHT & MID Functions
Using the UPPER, LOWER, PROPER & TRIM Functions
Using COUNT Functions
Using the VLOOKUP Function

Lesson 06 CREATING REPORTS 33:00
Creating a Subtotal Report
Using Conditional Formatting
Creating & Managing Conditions
Creating a Chart
Refining Charts
Using Basic Chart Types

Inserting Headers & Footers
Adding Comments
Adjusting Page Layout
Distributing Your Worksheets
Protecting Your Worksheets
Understanding Compatibility

Lesson 08 TIPS & TRICKS 52:55
Using the Fill Handle
Filling in a Series of Numbers
Typing in Multiple Cells at Once
Leveraging a Custom List & Transposing a Range
Deleting & Inserting Blank Cells
Filling Holes in Your Data
Getting a List of Unique Records & Parsing Text
Rearranging Columns & Linking to Multiple Cells
Using Right Mouse Button Drag Options
Make Format Painter Persist & Paste Special Formats
Formatting Portions of Text & Multiple Sheets
Creating Cell Border Effects & Sorting on Color
Turning Formulas into Hard Data
Copy Formula References & Highlight Formulas
Creating Dynamic Charts & Combination Charts
Add a Secondary Axis, Average Line & Smooth Line
Comparing Data Dynamically with Charts
Final Comments & Credits

Presenter Info

Mike Alexander Headshot

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 14 years experience consulting and developing office solutions.  Michael started his career in consulting and development at the White House Communications Agency in Washington DC where he spearheaded the development of a standalone HRIS system for the White House’s Military Office. He parleyed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries.  

He currently lives in Frisco, TX where he serves as a Senior Program Manager for a top technology firm.  Michael is the author of several books on Microsoft Access and Excel, and is the principle behind DataPig Technologies where he shares basic Access and Excel tips to the Office community.