Excel Training and Business Software Tutorials Designed For Everyone
BooksTraining.com
You have no items in your shopping cart

Training For Microsoft Excel That Works For You...

See How To Use MS Excel With Self-Paced Tutorials In Our Comprehensive Video Course.

Finally, an easy way to quickly become an expert user of Microsoft Excel.

  • Improve how you use MS Excel.

  • For beginner, intermediate, and even advanced users of Microsoft Excel.

With this professional course, the most comprehensive collection of Excel video tutorials available, you will see tips for gaining efficiency and becoming better informed in your business.

Get everything that could be covered in a three day MS Excel training class but in the comfort of your office or home.

  • 10 full hours of professional Microsoft Excel training.

  • 14 CPE Credits. Three days worth of instruction.

  • 198 Complete Excel video lessons designed by professional software trainers.

  • Practice Exams.

  • Final exam submission.

  • Certificate of Completion.

The Microsoft

Excel Training

Course Tutorials

Versions: 2019 & Microsoft 365

Only $399.99 + s&h

Instant Rebate Savings: $150.99

Just $ 249.00  + s&h

limited time offer
order now and save

add to cart


For beginner, intermediate,
and advanced users of
Microsoft Excel software.

Training Course for Microsoft Excel

- Press Play For This Important Message -

Free Microsoft Excel Training Demo


May I see a demo of this Excel course or the other business software tutorials?

Yes. Simply enter your best email address and we will send you  free online demos for each of our courses

We respect your email privacy

Getting Acquainted with Excel

  1. About Excel
  2. The Excel Environment
  3. The Title Bar
  4. The Ribbon
  5. The "File" Tab and Backstage View
  6. Scroll Bars
  7. The Quick Access Toolbar
  8. Touch Mode
  9. The Formula Bar
  10. The Workbook Window
  11. The Status Bar
  12. The Workbook View Buttons
  13. The Zoom Slider
  14. The Mini Toolbar
  15. Keyboard Shortcuts

File Management

  1. Creating New Workbooks
  2. Saving Workbooks
  3. Closing Workbooks
  4. Opening Workbooks
  5. Recovering Unsaved Workbooks
  6. Opening a Workbook in a New Window
  7. Arranging Open Workbook Windows
  8. Freeze Panes
  9. Split Panes
  10. Hiding and Unhiding Workbook Windows
  11. Comparing Open Workbooks
  12. Switching Open Workbooks
  13. Switching to Full Screen View
  14. Working With Excel File Formats

Data Entry

  1. Selecting Cells
  2. Entering Text into Cells
  3. Entering Numbers into Cells
  4. AutoComplete
  5. Down List
  6. Flash Fill
  7. Selecting Ranges
  8. Ranged Data Entry
  9. Using AutoFill

Creating Formulas

  1. Ranged Formula Syntax
  2. Simple Formula Syntax
  3. Writing Formulas
  4. Using AutoSum
  5. Inserting Functions
  6. Editing a Range
  7. Formula AutoCorrect
  8. AutoCalculate
  9. Function Compatibility

Copying & Pasting Formulas

  1. Relative References and Absolute References
  2. Cutting, Copying, and Pasting Data
  3. AutoFilling Cells
  4. The Undo Button
  5. The Redo Button

Columns & Rows

  1. Selecting Columns & Rows
  2. Adjusting Column Width and Row Height
  3. Hiding and Unhiding Columns and Rows
  4. Inserting and Deleting Columns and Rows

Formatting Worksheets

  1. Formatting Cells
  2. The Format Cells Dialog Box
  3. Clearing All Formatting from Cells
  4. Copying All Formatting from Cells to Another Area

Worksheet Tools

  1. Inserting and Deleting Worksheets
  2. Selecting Multiple Worksheets
  3. Navigating Worksheets
  4. Renaming Worksheets
  5. Coloring Worksheet Tabs
  6. Copying or Moving Worksheets

Setting Worksheet Layout

  1. Using Page Break Preview
  2. Using The Page Layout View
  3. Opening the Page Setup Dialog Box
  4. Page Settings
  5. Setting Margins
  6. Creating Headers and Footers
  7. Sheet Settings

Helping Yourself

  1. Using Excel Help
  2. The Tell Me Bar
  3. Smart Lookup and Insights

Creating 3D Formulas

  1. Creating 3D Formulas
  2. 3D Formula Syntax
  3. Creating 3D Range References

Named Ranges

  1. Naming Ranges
  2. Creating Names from Headings
  3. Moving to a Named Range
  4. Using Named Ranges in Formulas
  5. Naming 3D Ranges
  6. Deleting Named Ranges

Conditional Formatting and Cell Styles

  1. Conditional Formatting
  2. Finding Cells with Conditional Formatting
  3. Clearing Conditional Formatting
  4. Using Table and Cell Styles

Paste Special

  1. Using Paste Special
  2. Pasting Linked Formulas

Sharing Workbooks

  1. About Sharing Workbooks
  2. Simplified Workbook Sharing
  3. Traditional Workbook Sharing
  4. Highlighting Changes
  5. Reviewing Changes
  6. Using Comments
  7. Compare and Merge Workbooks

Tables

  1. Creating a Table
  2. Adding and Editing Records
  3. Inserting Records and Fields
  4. Deleting Records and Fields

Making Macros

  1. Recording Macros
  2. Running and Deleting Recorded Macros
  3. The Personal Macro Workbook

If Analysis and Forecasts

  1. Using Data Tables
  2. Using Scenario Manager
  3. Using Goal Seek
  4. Forecast Sheets

Creating Charts In Excel

  1. Creating Charts
  2. Selecting Charts and Chart Elements
  3. Adding Chart Elements
  4. Moving and Resizing Charts
  5. Changing the Chart Type
  6. Changing the Data Range
  7. Switching Column and Row Data
  8. Choosing a Chart Layout
  9. Lesson 26.9 Choosing a Chart Style
  10. Lesson 26.10 Changing Color Schemes
  11. Printing Charts
  12. Deleting Charts

Auditing Worksheets

  1. Auditing Worksheets
  2. Tracing Precedent and Dependent Cells
  3. Tracing Errors
  4. Error Checking
  5. Using the Watch Window
  6. Cell Validation

Outlining Worksheets

  1. Using Outlines
  2. Applying and Removing Outlines

Consolidating Worksheets

  1. Consolidating Data

Sorting Data

  1. Sorting Data
  2. Custom Sort Orders

Filtering Data

  1. Using AutoFilters
  2. Using the Top 10 AutoFilter
  3. Applying a Custom AutoFilter
  4. Creating Advanced Filters
  5. Applying Multiple Criteria
  6. Using Complex Criteria
  7. Copying Filter Results to a New Location
  8. Using Database Functions

Related Functions

  1. The Hlookup and Vlookup Functions
  2. Using the IF, AND, and OR Functions

Sparklines

  1. Inserting and Deleting Sparklines
  2. Modifying Sparklines

Formatting Charts in Excel

  1. Formatting Chart Objects
  2. Inserting Objects into a Chart
  3. Formatting Axes
  4. Formatting Axis Titles
  5. Formatting a Chart Title
  6. Formatting Data Labels
  7. Formatting a Data Table
  8. Formatting Error Bars
  9. Formatting Gridlines
  10. Formatting a Legend
  11. Formatting Drop and High/Low Lines
  12. Formatting Trendlines
  13. Formatting Up/Down Bars
  14. Formatting the Chart and Plot Areas
  15. Naming Charts
  16. Applying Shape Styles
  17. Applying WordArt Styles
  18. Saving Custom Chart Templates

Data Models

  1. Creating a Data Model from External Relational Data
  2. Creating a Data Model from Excel Tables
  3. Relating Tables in a Data Model
  4. Managing a Data Model

PivotTables and PivotCharts

  1. Creating Recommended PivotTables
  2. Manually Creating a PivotTable
  3. Creating a PivotChart
  4. Manipulating a PivotTable or PivotChart
  5. Changing Calculated Value Fields
  6. Formatting PivotTables
  7. Formatting PivotCharts
  8. Setting PivotTable Options
  9. Sorting and Filtering Using Field Headers

Power Pivot

  1. Starting Power Pivot
  2. Managing the Data Model
  3. Calculated Columns
  4. Measures
  5. Creating KPIs
  6. Creating and Managing Perspectives
  7. Power Pivot PivotTables and PivotCharts

Power View

  1. Starting Power View
  2. Adding Report Visualizations
  3. Changing the Layout of Report Visualizations
  4. Using Undo and Redo in Power View
  5. Formatting the Power View Sheet
  6. Creating Multiples in a Chart
  7. Filtering Power View Using the Filter Area
  8. Filtering Visualizations

Slicers and Timelines

  1. Inserting and Deleting Slicers
  2. Modifying Slicers
  3. Inserting and Deleting Timelines
  4. Modifying Timelines

Security Features

  1. Unlocking Cells
  2. Worksheet Protection
  3. Workbook Protection
  4. Password Protecting Excel Files

How to receive your 14 Continuing Professional Education (CPE) credits* with this training for Microsoft Excel...

Complete this Microsoft Excel course at work or home and at your own pace.

  1. Submit your exam within one year of your receipt date.

  2. Pass the exam with a score of 70% or above.

  3. Then be awarded your Certificate of Completion.

Can I view these tutorials without the Excel software installed on my computer?

Yes. You can view the Microsoft Excel course sessions as many times as you want whether or not you have Excel installed.

Is it easy to install your training courses?

Yes. Simply insert the CD into your computer and the Excel course training menu will launch automatically.

Do you offer a money back guarantee on this program?

Yes. Just take advantage of your instant rebate savings now. Simply reserve your course right now so you can receive your course.

If you aren't delighted, return your unopened merchandise to us within 30 days from the shipping date for a full refund (minus shipping and handling).

Where can I purchase the Microsoft Excel software that goes with this system?

Click here to order the most recent version of Microsoft Excel spreadsheet and financial reporting software.

Buy Microsoft Excel Software



Other students have shared opinions like these...

"...liked it better than the Excel skills class I took at my community college..."
Bonnie K

"I had to go slow and only do a module or two per day over a couple of weeks because of a busy schedule but it was certainly worth it... ...great way to learn."
Sarah T

"Good software. Your tutorials helped me answer my questions."
Ben F

"...now I know how to use Excel for my work... ...it can also help me stay organized at home..."
Flynn P

"Not only did I grow my skills, what I learned helped me get a promotion at my job..."
Stephanie O

"...I had high expectations because I needed to learn PivotTables and charts for a project at my company... Success. Above all, I'm glad this showed me the way while still being so affordable compared to other professional courses."
Terry M

"...so can I admit that I had fun? ...I learned a lot!"
Keith J

"We received your bookkeeping course and your Excel training materials... ...after going through them both.. ...I know how to use my software... ...it really helped me see where I can save time."
Barb A

"...the other course my daughter's college professor recommended was over $1000... Thank you."
Kim S

"...but your Excel course might not be for everyone because it does cover a lot and quickly. I thought it was great, though."
John K

"...and practically anyone who uses a computer could benefit from Microsoft Excel. ...glad we have your training programs in our office reference library."
Pat G

Why courses or training classes for Microsoft Excel?

Are you new to Microsoft Excel or are you an Excel expert? Regardless of your experience level with using MS Excel, you will know how to work even smarter with this popular Microsoft Excel training course.

This comprehensive Microsoft Excel course can show you how to optimize your spreadsheets, worksheets, applications, and projects. Among the many things this course reveals, your training will demonstrate more good ways to accomplish tasks and how you can complete your work in less time.

Students have reported that this training for Microsoft Excel can reveal an entire world of functionality that most people don't know about. Excel database features can provide you with a different way of sorting and removing data out of your Excel worksheets without tedious copy and pasting. Objects from images to hyperlinks can enhance the look and functionality of your workbooks. Well designed macros allow you to automate redundant tasks and you will know how to create your own functions.

This MS Excel training class will help you eliminate inefficient habits that may have been the proper way to do things years back but aren't the easiest method to approach problems today.

Get started now and grow your Microsoft Excel skills. Learn with step by step course videos that show you how to use MS Excel more efficiently. Save time with professional tutorials that show you tips and shortcuts. Your Excel training videos and computer based tutorials will help you learn how to use your software as if you were attending a live training class or seminar course but in the comfort of your office or home.

Secure your training for Microsoft Excel now and explore the real potential of your software.


The Microsoft

Excel Training

Course Tutorials

Versions: 2019 & Microsoft 365

Only $399.99 + s&h

Instant Rebate Savings: $150.99

Just $249.00  + s&h

limited time offer
order now and save

add to cart

For beginner, intermediate,
and advanced users of
Microsoft Excel software.

Training Course for Microsoft Excel

May I see a free demo?

We respect your email privacy