Ready to Checkout?

shopping-cart

Quality Training Since 2001

Microsoft Excel Training Course

demo-buttonbuy-now-buttonsyllabus-button

microsoft-excel-training-tutorial

Course Title: Mastering Excel Made Easy
Versions Covered: 2013, 2010 & 2007
Hours of Content: 10
Video Lessons: 222
Manuals: 3 (Introductory, Intermediate & Advanced)
Download/DVD-ROM: Standard: $40 | CPE: $50 | Buy
Online: Access to ALL courses. One low price. | Info
Multi-User: Network Installation | Info
CPE Credits: CPAs (14) | Verify


Course Description

Learn Microsoft Excel with this comprehensive Excel 2013 training course from TeachUcomp, Inc. Mastering Excel Made Easy features 222 video lessons with over 10 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more.

Whether you are completely new to Excel or upgrading from an older version, this Excel 2013 training course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs.  Simply launch the easy-to-use interface, click to start a video lesson or open one of the manuals and you’re on your way to mastering Excel.

 

Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view samples of the instruction manuals in PDF, click here: Introductory Excel | Intermediate Excel | Advanced Excel

CHAPTER 1- Getting Acquainted with Excel
Lesson 1.1- About Excel free
Lesson 1.2- The Excel Environment- 2013 free
Lesson 1.3- The Excel Environment- 2010
Lesson 1.4- The Excel Environment- 2007
Lesson 1.5- The Title Bar
Lesson 1.6- The Ribbon
Lesson 1.7- The “File” Tab and Backstage View
Lesson 1.8- The Microsoft Office Button- 2007 Only
Lesson 1.9- Scroll Bars
Lesson 1.10- The Quick Access Toolbar
Lesson 1.11- Touch Mode
Lesson 1.12- The Formula Bar
Lesson 1.13- The Workbook Window
Lesson 1.14- The Status Bar
Lesson 1.15- The Workbook View Buttons
Lesson 1.16- The Zoom Slider
Lesson 1.17- The Mini Toolbar
Lesson 1.18- Keyboard Shortcuts
CHAPTER 2- File Management
Lesson 2.1- Creating New Workbooks- 2013 free
Lesson 2.2- Creating New Workbooks- 2010
Lesson 2.3- Creating New Workbooks- 2007
Lesson 2.4- Saving Workbooks- 2013 free
Lesson 2.5- Saving Workbooks- 2010
Lesson 2.6- Saving Workbooks- 2007
Lesson 2.7- Closing Workbooks- 2013
Lesson 2.8- Closing Workbooks- 2010 and 2007
Lesson 2.9- Opening Workbooks- 2013
Lesson 2.10- Opening Workbooks- 2010
Lesson 2.11- Opening Workbooks- 2007
Lesson 2.12- Recovering Unsaved Workbooks
Lesson 2.13- Using the “Window” Command Group
Lesson 2.14- Switching to Full Screen View
Lesson 2.15- Working With Excel File Formats
CHAPTER 3- Data Entry
Lesson 3.1- Selecting Cells free
Lesson 3.2- Entering Text into Cells free
Lesson 3.3- Entering Numbers into Cells free
Lesson 3.4- AutoComplete
Lesson 3.5- Pick from Drop-Down List
Lesson 3.6- Flash Fill- 2013 Only
Lesson 3.7- Selecting Ranges
Lesson 3.8- Ranged Data Entry
Lesson 3.9- Using AutoFill
CHAPTER 4- Creating Formulas
Lesson 4.1- Ranged Formula Syntax free
Lesson 4.2- Simple Formula Syntax free
Lesson 4.3- Writing Formulas free
Lesson 4.4- Using AutoSum
Lesson 4.5- Inserting Functions
Lesson 4.6- Editing a Range
Lesson 4.7- Formula AutoCorrect
Lesson 4.8- AutoCalculate
Lesson 4.9- Function Compatibility- 2013 Only
CHAPTER 5- Copying & Pasting Formulas
Lesson 5.1- Relative References and Absolute References
Lesson 5.2- Cutting, Copying, and Pasting Data
Lesson 5.3- AutoFilling Cells
Lesson 5.4- The Undo Button
Lesson 5.5- The Redo Button
CHAPTER 6- Columns & Rows
Lesson 6.1- Selecting Columns & Rows
Lesson 6.2- Adjusting Column Width and Row Height
Lesson 6.3- Hiding and Unhiding Columns and Rows
Lesson 6.4- Inserting and Deleting Columns and Rows
CHAPTER 7- Formatting Worksheets
Lesson 7.1- Formatting Cells
Lesson 7.2- The Format Cells Dialog Box
Lesson 7.3- Clearing All Formatting from Cells
Lesson 7.4- Copying All Formatting from Cells to Another Area
CHAPTER 8- Worksheet Tools
Lesson 8.1- Inserting and Deleting Worksheets
Lesson 8.2- Selecting Multiple Worksheets
Lesson 8.3- Navigating Worksheets- 2013 Only
Lesson 8.4- Navigating Worksheets- 2010:2007
Lesson 8.5- Renaming Worksheets
Lesson 8.6- Coloring Worksheet Tabs
Lesson 8.7- Copying or Moving Worksheets
CHAPTER 9- Setting Worksheet Layout
Lesson 9.1- Using Page Break Preview
Lesson 9.2- Using Page Layout View
Lesson 9.3- The Page Setup Dialog Box
CHAPTER 10- Printing Spreadsheets
Lesson 10.1- Previewing and Printing Worksheets- 2013:2010
Lesson 10.2- Using Print Preview- 2007 Only
Lesson 10.3- Printing Worksheets- 2007 Only
CHAPTER 11- Helping Yourself
Lesson 11.1- Using Excel Help
CHAPTER 12- Creating 3D Formulas
Lesson 12.1- Creating 3D Formulas
Lesson 12.2- 3D Formula Syntax
Lesson 12.3- Creating 3D Range References
CHAPTER 13- Named Ranges
Lesson 13.1- Naming Ranges
Lesson 13.2- Creating Names from Headings
Lesson 13.3- Moving to a Named Range
Lesson 13.4- Using Named Ranges in Formulas
Lesson 13.5- Naming 3D Ranges
Lesson 13.6- Managing Named Ranges
CHAPTER 14- Conditional Formatting and Cell Styles
Lesson 14.1- Conditional Formatting
Lesson 14.2- Finding Cells with Conditional Formatting
Lesson 14.3- Clearing Conditional Formatting
Lesson 14.4- Using Table and Cell Styles
CHAPTER 15- Paste Special
Lesson 15.1- Using Paste Special
Lesson 15.2- Pasting Linked Formulas
CHAPTER 16- Sharing Workbooks
Lesson 16.1- Sharing Workbooks
Lesson 16.2- Highlighting Changes
Lesson 16.3- Reviewing Changes
Lesson 16.4- Using Comments
Lesson 16.5- Compare and Merge Workbooks
CHAPTER 17- Auditing Worksheets
Lesson 17.1- Auditing Worksheets
Lesson 17.2- Tracing Precedent and Dependent Cells
Lesson 17.3- Tracing Errors
Lesson 17.4- Error Checking
Lesson 17.5- Using the Watch Window
Lesson 17.6- Cell Validation
CHAPTER 18- Outlining Worksheets
Lesson 18.1- Using Outlines
Lesson 18.2- Applying and Removing Outlines
CHAPTER 19- Consolidating Worksheets
Lesson 19.1- Consolidating Data
CHAPTER 20- Tables
Lesson 20.1- Creating a Table
Lesson 20.2- Adding an Editing Records
Lesson 20.3- Inserting Records and Fields
Lesson 20.4- Deleting Records and Fields
CHAPTER 21- Sorting Data
Lesson 21.1- Sorting Data
Lesson 21.2- Custom Sort Orders
CHAPTER 22- Filtering Data
Lesson 22.1- Using AutoFilters
Lesson 22.2- Using the Top 10 AutoFilter
Lesson 22.3- Using a Custom AutoFilter
Lesson 22.4- Creating Advanced Filters
Lesson 22.5- Applying Multiple Criteria
Lesson 22.6- Using Complex Criteria
Lesson 22.7- Copying Filter Results to a New Location
Lesson 22.8- Using Database Functions
CHAPTER 23- Using What-If Analysis
Lesson 23.1- Using Data Tables
Lesson 23.2- Using Scenario Manager
Lesson 23.3- Using Goal Seek
CHAPTER 24- Table-Related Functions
Lesson 24.1- The Hlookup and Vlookup Functions
Lesson 24.2- Using the IF, AND, and OR Functions
CHAPTER 25- Sparklines
Lesson 25.1- Inserting and Deleting Sparklines
Lesson 25.2- Modifying Sparklines
CHAPTER 26- Creating Charts In Excel 2013
Lesson 26.1- Creating Charts
Lesson 26.2- Selecting Charts and Chart Elements
Lesson 26.3- Adding Chart Elements
Lesson 26.4- Moving and Resizing Charts
Lesson 26.5- Changing the Chart Type
Lesson 26.6- Changing the Data Range
Lesson 26.7- Switching Column and Row Data
Lesson 26.8- Choosing a Chart Layout
Lesson 26.9 Choosing a Chart Style
Lesson 26.10 Changing Color Schemes
Lesson 26.11- Printing Charts
Lesson 26.12- Deleting Charts
CHAPTER 27- Creating Charts in Excel 2010 & 2007
Lesson 27.1- Creating Charts
Lesson 27.2- Selecting Charts and Chart Elements
Lesson 27.3- Moving and Resizing Charts
Lesson 27.4- Changing the Chart Type
Lesson 27.5- Changing the Data Range
Lesson 27.6- Switching Column and Row Data
Lesson 27.7- Choosing a Chart Layout
Lesson 27.8- Choosing a Chart Style
Lesson 27.9- Printing Charts
Lesson 27.10- Deleting Charts
CHAPTER 28- Formatting Charts in Excel 2013
Lesson 28.1- Formatting Chart Objects
Lesson 28.2- Inserting Objects into a Chart
Lesson 28.3- Formatting Axes
Lesson 28.4- Formatting Axis Titles
Lesson 28.5- Formatting a Chart Title
Lesson 28.6- Formatting Data Labels
Lesson 28.7- Formatting a Data Table
Lesson 28.8- Formatting Error Bars
Lesson 28.9- Formatting Gridlines
Lesson 28.10- Formatting a Legend
Lesson 28.11- Formatting Drop and High-Low Lines
Lesson 28.12- Formatting Trendlines
Lesson 28.13- Formatting Up/Down Bars
Lesson 28.14- Formatting the Chart and Plot Areas
Lesson 28.15- Naming Charts
Lesson 28.16- Applying Shape Styles
Lesson 28.17- Applying WordArt Styles
Lesson 28.18- Saving Custom Chart Templates
CHAPTER 29- Formatting Charts in Excel 2010 & 2007
Lesson 29.1- Formatting Chart Objects
Lesson 29.2- Inserting Objects into a Chart
Lesson 29.3- Changing Chart Labels
Lesson 29.4- Changing Axes Display
Lesson 29.5- Changing the Chart Background
Lesson 29.6- Applying Chart Analysis Lines
Lesson 29.7- Naming Charts
Lesson 29.8- Applying Shape Styles to Chart Elements
Lesson 29.9- Applying WordArt Styles to Chart Elements
Lesson 29.10- Saving Custom Chart Templates
CHAPTER 30- Data Models
Lesson 30.1- Creating a Data Model from External Relational Data
Lesson 30.2- Creating a Data Model from Excel Tables
Lesson 30.3- Relating Tables in a Data Model
Lesson 30.4- Managing a Data Model
CHAPTER 31- PivotTables and PivotCharts- 2013
Lesson 31.1- Creating Recommended PivotTables
Lesson 31.2- Manually Creating a PivotTable
Lesson 31.3- Creating a PivotChart
Lesson 31.4- Manipulating a PivotTable or PivotChart
Lesson 31.5- Changing Calculated Value Fields
Lesson 31.6- Formatting PivotTables
Lesson 31.7- Formatting PivotCharts
Lesson 31.8- Setting PivotTable Options
Lesson 31.9- Sorting and Filtering Using Field Headers
CHAPTER 32- PivotTables and PivotCharts- 2010:2007
Lesson 32.1- Creating PivotTables and PivotCharts
Lesson 32.2- Manipulating a PivotTable
Lesson 32.3- Changing Calculated Value Fields
Lesson 32.4- Applying PivotTable Styles
Lesson 32.5- Creating a PivotChart
Lesson 32.6- Setting PivotTable Options
Lesson 32.7- Sorting and Filtering PivotTable Data
CHAPTER 33- PowerPivot
Lesson 33.1- Starting PowerPivot
Lesson 33.2- Managing the Data Model
Lesson 33.3- Calculated Columns and Fields
Lesson 33.4- Creating KPIs
Lesson 33.5- Creating and Managing Perspectives
Lesson 33.6- PowerPivot PivotTables and PivotCharts
CHAPTER 34- Power View
Lesson 34.1- Starting Power View
Lesson 34.2- Adding Report Visualizations
Lesson 34.3- Changing the Layout of Report Visualizations
Lesson 34.4- Using Undo and Redo in Power View
Lesson 34.5- Formatting the Power View Sheet
Lesson 34.6- Creating Multiples in a Chart
CHAPTER 35- Slicers and Timelines
Lesson 35.1- Inserting and Deleting Slicers
Lesson 35.2- Modifying Slicers
Lesson 35.3- Inserting and Deleting Timelines
Lesson 35.4- Modifying Timelines
CHAPTER 36- Security Features
Lesson 36.1- Unlocking Cells
Lesson 36.2- Worksheet Protection
Lesson 36.3- Workbook Protection
Lesson 36.4- Password Protecting Excel Files- 2013
Lesson 36.5- Password Protecting Excel Files- 2010:2007
CHAPTER 37- Making Macros
Lesson 37.1- Recording Macros
Lesson 37.2- Running and Deleting Recorded Macros
Lesson 37.3- The Personal Macro Workbook


Microsoft Excel Training Course Overview

Microsoft Excel is the most popular commercial spreadsheet software program on the market today. During this 10 hour Excel video training course, our expert instructor will show you how to effectively create and format spreadsheets, charts, pivot tables and much more. This Excel tutorial covers the same material as our three-day classroom training and was designed to provide a solid foundation in Excel.

We offer two types of Excel courses – Standard and CPE (Continuing Professional Education). The Standard training course includes all video lessons and printable classroom instruction manuals. The CPE edition includes the same training curriculum, plus a practice exam with evaluative feedback (find out why your answers are right or wrong), your final exam submission and a course certificate of completion. The Excel CPE training course also qualifies for continuing education credit for CPAs (Certified Public Accountants) in certain states.

At TeachUcomp, Inc., you choose how you want your Excel training delivered.

Online subscriptions offer the most flexibility and value. With online training, you can access your courses anytime and anywhere you have an internet connection (including all new releases and updates). Your subscription grants you instant access to ALL of our courses for one low price. There are no contracts and you can cancel at any time. You may choose between a monthly or annual plan.

Courses are also available individually via digital download or DVD-ROM for a one-time charge.

 

 

TOP