About Us|Contact Us|Learn Now: Find a Course
Like us and Save!  Join our Mailing List and Save!
Connect with us for News & Exclusive Offers:
View Cart
Contact Us


Microsoft Excel 2013 Advanced Tutorial

SPECIAL OFFER: 20% DISCOUNT & FREE SHIPPING!
 Professionally created, self-study video training.

About this Tutorialshow details
Learn how to conquer the more complex features and functions of this industry standard spreadsheet software with the help of these Microsoft Excel 2013 Advanced tutorial videos.

Taking over from where the beginner course left off, expert MS Excel tutor Guy Vaccaro uses step-by-step training videos help break down the more complex and challenging aspects of the 2013 release, which will take your Excel skills to a whole new level.

The same MS Excel files that the trainer demonstrates on are also included with the CD and download purchase options allowing you to work in parallel with Guy's on-screen actions.

Through over ten hours of professionally created video training, the tuition includes an overview of the mathematical functions, learning to perform data Lookups, how to create a sparkline, outlining explained, making use of Arrays, lessons on PivotTables and PivotCharts, using Macros and so much more...

The complete training course contents are listed below and you can start learning right away, click any blue linked lesson to sample the Microsoft Excel 2013 Advanced video tutorials and discover how effective this practical teaching method is...
Learn this Software - See below for FREE TUTORIALS
BEGINNER COURSE...
We also have the
Beginners Microsoft Excel 2013 Tutorial


Each Course on 1 or 2 CDs or Download
For Mac and PC


FREE Shipping on ALL Orders
Microsoft Excel 2013 Advanced Tutorial Info
Tutor: Guy Vaccaro
Duration: 10 hrs / 128 video lessons
This course is currently on offer:
20% OFF & FREE Shipping!
UK Price: £79.95 £63.95 + VAT

EU Price: €84.95 €67.95 + VAT

US & Canada: $124.95 $99.94
Product Code: 01755
DELIVERY DETAILS:
Downloads: Training downloadable when payment processed (by next working day)
CDs: Please allow 2-3 days for UK, Europe, US & Canada.
3-5 days rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 8, 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Share |


Don't take our word for it, see our CUSTOMER TESTIMONIALS
Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers provide a beginners guide using simplistic terms and minimal jargon.
  Personal Tutoring - Step-by-step video training from your own desktop. Delivered via best selling DVD/CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses, seminars, workshops & classes.
  You can jump to and from lessons allowing you to learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals, basic handbooks, and for dummies books.
Customer Testimonials
Associated Training CDs:
Microsoft OneNote 2013 | Microsoft Office 2013 | Microsoft Access 2013 | Complete Range of Microsoft Excel Tutorials | Microsoft Project 2013 | Microsoft Word 2013 | Microsoft Outlook 2013 | Microsoft PowerPoint 2013 | Microsoft Windows 8 | Complete Range of Advanced Excel Tutorials | Complete Range of Microsoft Office 2013 Tutorials | Microsoft Visio 2013
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials have a higher sound & video quality.

FREE Sample Videos from this Course

Will I Be Able To Keep Up?
Area And Volume Calculations
Using A Near Match In The Lookup
Creating A Sparkline
Loan And Investment Calculations
Add Quick Access To Custom Views
CONCATENATE: Building Strings From Multiple Cells
Arrays And Creating A New Array Formula
What Are Tracer Arrows
What Is A PivotTable?
Creating A PivotChart
Use Of Worksheet Buttons To Trigger Macros
About The Excel Tutor

We hope you enjoyed the FREE lessons. To view the complete contents, including ALL the lessons below & above, please purchase the course via CD or Download


Getting Started
Will I Be Able To Keep Up?
Using The Included Files
New For 2013: Its All In The Cloud
The Very Clever Flash Fill

Using Mathematical Functions
The Basic SUM, COUNT, MIN, And MAX
AVERAGE, MODE, MEAN, And MEDIAN
SUMIF For Selective Adding Up
COUNTIF For Selective Counting
AVERAGEIF For The Mean Of Selected Cells
Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
Area And Volume Calculations

IF Functionality
IF Syntax And Uses
Nesting The IF Statement
Use Of The AND Operator Within An IF
Use Of The OR Operator Within An IF
The NOT Operator Within AND And OR Statements
Display Cell Formulas In Another Cell

Performing Data Lookups
VLOOKUP: Syntax And Usage
VLOOKUP In Live Action
HLOOKUP: Variation On A Theme
Using A Near Match In The Lookup
Dealing With Missing Data In A Lookup
Managing The Lookup Table
Lookups Nested Within Lookups

Sparklines
Creating A Sparkline
Altering The Design Of Sparklines
Dealing With Empty Cells
Comparing Sparklines Within A Sparkline Group
Removing Sparklines From A Worksheet

Further Mathematical Functions
Working With Time In Excel
Calculations Using Time
Useful Time And Date Functions
Rounding Decimal Places
MOD And INT Functions And Uses
Generate And Use A Random Number
Loan And Investment Calculations
Loan Calculation Elements And Functions

Outlining
Create An Outline Automatically
Adding An Outline Manually
Editing And Removing Outlining

Scenarios
Setting Up A Set Of Scenarios
Displaying And Editing The Different Scenarios
How To Work Out Which Scenario You Are Displaying
Merging And Deleting Scenarios
Producing A Summary Of Scenarios

Custom Views
Custom Views Explained
Use Of Outlining To Help Setup Custom Views
Editing And Deleting Custom Views
Add Quick Access To Custom Views

Functions For Manipulating Text
LEFT And RIGHT: Text Manipulation
LEN And TRIM: String Extractions
FIND And MID: Text Functions Working Together
CONCATENATE: Building Strings From Multiple Cells
Changing Case Functions
REPLACE And SUBSTITUTE: Two More String Manipulation Functions
Use Of CHAR Function For More Obscure Characters
Formatting Numeric And Date Values Using TEXT
Keeping The Values Created By String Manipulation

Arrays
Arrays And Creating A New Array Formula
Array Formulas With IF Statements
Conditional Evaluation With No IFs
The Array-Only TRANSPOSE Function

Useful Data Functions
Using The MATCH Function
How The INDEX Function Works
Handling Out Of Range Index Requests
The CHOOSE Lookup Function
MATCH And INDEX Functions Working Together

Some Other Useful Functions
Introducing IS Functions
Error Checking Using ISERR, ISERROR, And IFERROR
OFFSET Function Syntax
OFFSET Function: Creating A Dynamic Named Range
INDIRECT Function To Build Dynamic Formulas
Dealing With INDIRECT Errors
The CELL Function And Determining File Or Sheet Names

Auditing And Troubleshooting Formulas
What Are Tracer Arrows
Adding And Removing Tracer Arrows
Auditing Tools: Error Checking And Tracing
Step-By-Step Formula Processing
Using The Watch Window In Troubleshooting

PivotTables
What Is A PivotTable?
The New Recommended PivotTable Route
Creating Your Own PivotTables
Changing The Formatting And Formulas In PivotTable Summaries
Creating Multiple PivotTables On The Same Dataset
Moving And Deleting PivotTables
Making Use Of The Report Filter Options
Sorting The PivotTable Columns
Refreshing A PivotTable
Drilling Down Behind The Pivot Numbers
Multiple Fields In Row, Column, Or Data Sections
Controlling Grand Totals And Subtotals
Dealing With Empty Cells And Other Additional Options
PivotTable Styles
Creating Your Own PivotTable Styles
Creating And Using Calculated Fields
Using The New Timeline Filter Option
Adding And Using The Data Slicer
Using Data From An SQL Server In A PivotTable
Managing The External Connection To SQL Server

PivotCharts
Creating A PivotChart
Changing The Fields Used In A PivotChart
Formatting The PivotChart
Changing The PivotChart Type
Filtering A PivotChart
Hiding The PivotChart Buttons
Moving And Deleting PivotCharts

Goal Seek And Solver
What-If Analysis Using Goal Seek
Activating The Solver Add-In
Using Solver To Complete A What-If
Adding Constraints To Solver

Macros
What Is A Macro
Creating And Running Your First Macro
Saving Workbooks With Macros
Macro Security Settings For Workbooks With Macros
The Personal Macro Workbook
Deleting Macros
Use Of Relative Or Absolute Referencing
Trigger A Macro With A Keyboard Shortcut
Formatting With A Macro
Switch Scenarios And Views With Macros
Use Of Worksheet Buttons To Trigger Macros
Customizing Form Buttons And Other Shape Triggers
Assigning Macros To Ribbon Icons
Create Your Own Ribbon
View And Edit Macro Code
Add An Are You Sure Box To Macros

Summary And Credits
What Have I Learned
About The Excel Tutor