Be An AllYouLike VIP Member Now
Jun 07

Infiniteskills Microsoft Excel 2013 Training Bundle – Video Tutorial + Exercise Files for Windows and Mac

infiniteskills microsoft excel training bundle

A Practical Excel Training Course That Teaches Real World Skills. In this project-based Microsoft Excel 2013 Training Bundle video tutorial series, you’ll quickly have relevant skills for real-world applications.

Follow along with our expert instructor in this training course to get:

Concise, informative and broadcast-quality Microsoft Excel 2013 Training Bundle training videos delivered to your desktop
The ability to learn at your own pace with our intuitive, easy-to-use interface
A quick grasp of even the most complex Microsoft Excel 2013 Training Bundle subjects because they’re broken into simple, easy to follow tutorial videos

Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Microsoft Excel 2013 Training Bundle tutorial, online or offline… so you’ll know the exact steps for your own projects.

01. Learning Microsoft Excel 2013 – Start Here

0101 Let’s Get Started With Excel 2013
0102 The Excel Workbook Explained
0103 Signing Up For Your Own Free SkyDrive
0104 Customize The Quick Access Toolbar
0105 Using The Included Working Files
0106 About The Author

02. Learning Microsoft Excel 2013 – Managing Excel Workbooks And Worksheets

0201 Creating And Saving A New Workbook
0202 Opening Workbooks And Save As Options
0203 Saving And Opening SkyDrive Files
0204 Navigating An Excel Workbook
0205 Adding And Removing Worksheets
0206 Renaming Copying And Moving Worksheets

03. Learning Microsoft Excel 2013 – Entering And Editing Data In Cells

0301 Entering Text, Numbers, And Dates
0302 Entering Numbers As Text
0303 Editing The Contents Of A Cell
0304 Undo And Redo Actions
0305 Cut, Copy, And Paste
0306 Dragging And Dropping Cells
0307 The Fill Handle
0308 Inserting And Deleting Cells Columns And Rows
0309 Changing Column Widths And Row Heights
0310 Hiding And Un-Hiding Columns And Rows
0311 Searching For Values In A Workbook

04. Learning Microsoft Excel 2013 – Math Basics

0401 Getting Started With Basic Math Formulas
0402 Order Of Operation With BODMAS
0403 Introduction To Basic Formulas
0404 Copying Formulas And Functions
0405 Displaying Formulas On A Worksheet

05. Learning Microsoft Excel 2013 – Formatting Worksheets

0501 Selecting Cells For Formatting
0502 Modifying Typeface Font, Size, And Colour
0503 Merging And Wrapping Cell Contents
0504 Using Number Formats
0505 Cell Content Alignment And Orientation
0506 Adding And Removing Borders From A Selection
0507 Applying A Date Format To A Cell Or Range
0508 The Format Painter
0509 Finding And Replacing Formats
0510 Clearing Cell Contents Vs. Clearing Cell Formatting

06. Learning Microsoft Excel 2013 – Workbook And Worksheet Management

0601 Worksheet Navigation And Coloured Worksheet Tabs
0602 Moving Or Copying Worksheets Within And Between Workbooks
0603 Viewing And Scrolling Multiple Workbooks At The Same Time
0604 Hiding And Un-Hiding Sheets
0605 Modifying More Than One Worksheet At A Time

07. Learning Microsoft Excel 2013 – Page Setup And Printing

0701 Using Print Titles And Print Areas
0702 Paper Size, Orientation, Margins, And Scaling Options
0703 Creating Headers and Footers
0704 Using The Page Break And The Page Layout Views
0705 Printing A Range Of Cells
0706 Running The Spell Checker
0707 Controlling Most Print Settings In One Place

08. Learning Microsoft Excel 2013 – Mathematical Formulas

0801 The Sum Function
0802 Copying Formulas And Functions
0803 Other Mathematical Functions: Average, Min, And Max
0804 Useful Count Functions
0805 Absolute Referencing Explained
0806 Formulas Across Worksheets
0807 3D Referencing
0808 Making Use Of Named Cells And Ranges

09. Learning Microsoft Excel 2013 – Advanced Formatting

0901 Enhancing Worksheets Using Themes
0902 Adding, Editing, And Deleting Comments
0903 Creating Your Own Autofill List
0904 Converting Data To A Table For Formatting

10. Learning Microsoft Excel 2013 – Security

1001 Activating And Deactivating Worksheet Protection
1002 Protecting Part Of A Worksheet To Aid Data Entry
1003 Password Protecting The Whole Workbook

11. Learning Microsoft Excel 2013 – Excel 2013 Templates

1101 Using The 2013 Templates
1102 Creating And Using Your Own Template

12. Learning Microsoft Excel 2013 – Graphics Objects

1201 Obtaining And Inserting Online Images
1202 Using SmartArt Graphics
1203 Inserting Shapes And Screenshots
1204 Formatting Graphical Objects
1205 The Stacking Order
1206 Grouping Multiple Objects Together
1207 Using Graphical Objects And Mathematical Formulas

13. Learning Microsoft Excel 2013 – Using Charts In Excel

1301 The New Recommended Charts Option
1302 Create A Chart Using The Long Or The Short Method
1303 Formatting A Chart With The 2013 Shortcut Options
1304 Modifying The Chart Type
1305 Formatting Chart Elements
1306 Adding A Trendline
1307 The Pie Chart In Detail
1308 Mini Graphs: Sparklines

14. Learning Microsoft Excel 2013 – Excel As A Database

1401 Fixing On Screen Rows And Columns
1402 Fixing Print Rows And Columns
1403 Sorting Data In Excel
1404 Filtering Data To Reduce Dataset Size
1405 Removing Duplicate Entries In The Data
1406 Adding Subtotals To A Worksheet Of Data
1407 Using Text To Columns Effectively
1408 Linking To Data On A Webpage

15. Learning Microsoft Excel 2013 – Advanced Formulas

1501 Using An If Formula
1502 Use Of The If Function To Hide Excel Error Messages
1503 Datedif: A Useful But Hidden Formula
1504 Text Manipulation Using Functions
1505 Use The Text Function To Format Numbers
1506 Date Manipulation Functions
1507 Introducing Sumif, Countif, And Averageif
1508 Use Of Rank To Calculate Placings
1509 Flash Fill: The Magic Touch

16. Learning Microsoft Excel 2013 – Conditional Formatting

1601 Altering Cell Appearance Based On The Cell Value
1602 Displaying Data Bars, Color Scales, Or Icon Sets
1603 Using Top And Bottom Rules For Formatting
1604 Creating A Formatting Rule From Scratch
1605 Managing The Conditional Formatting Rules

17. Learning Microsoft Excel 2013 – What’s Next

1701 The New Office Apps For Excel 2013
1702 Ready To Go Advanced

01. Advanced Microsoft Excel 2013 Training – Getting Started

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

02. Advanced Microsoft Excel 2013 Training – Using Mathematical Functions

0201 The Basic SUM, COUNT, MIN, And MAX
0203 SUMIF For Selective Adding Up
0204 COUNTIF For Selective Counting
0205 AVERAGEIF For The Mean Of Selected Cells
0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
0207 Area And Volume Calculations

03. Advanced Microsoft Excel 2013 Training – IF Functionality

0301 IF Syntax And Uses
0302 Nesting The IF Statement
0303 Use Of The AND Operator Within An IF
0304 Use Of The OR Operator Within An IF
0305 The NOT Operator Within AND And OR Statements
0306 Display Cell Formulas In Another Cell

04. Advanced Microsoft Excel 2013 Training – Performing Data Lookups

0401 VLOOKUP: Syntax And Usage
0402 VLOOKUP In Live Action
0403 HLOOKUP: Variation On A Theme
0404 Using A Near Match In The Lookup
0405 Dealing With Missing Data In A Lookup
0406 Managing The Lookup Table
0407 Lookups Nested Within Lookups

05. Advanced Microsoft Excel 2013 Training – Sparklines

0501 Creating A Sparkline
0502 Altering The Design Of Sparklines
0503 Dealing With Empty Cells
0504 Comparing Sparklines Within A Sparkline Group
0505 Removing Sparklines From A Worksheet

06. Advanced Microsoft Excel 2013 Training – Further Mathematical Functions

0601 Working With Time In Excel
0602 Calculations Using Time
0603 Useful Time And Date Functions
0604 Rounding Decimal Places
0605 MOD And INT Functions And Uses
0606 Generate And Use A Random Number
0607 Loan And Investment Calculations
0608 Loan Calculation Elements And Functions

07. Advanced Microsoft Excel 2013 Training – Outlining

0701 Create An Outline Automatically
0702 Adding An Outline Manually
0703 Editing And Removing Outlining

08. Advanced Microsoft Excel 2013 Training – Scenarios

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

09. Advanced Microsoft Excel 2013 Training – Custom Views

0901 Custom Views Explained
0902 Use Of Outlining To Help Setup Custom Views
0903 Editing And Deleting Custom Views
0904 Add Quick Access To Custom Views

10. Advanced Microsoft Excel 2013 Training – Functions For Manipulating Text

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

11. Advanced Microsoft Excel 2013 Training – Arrays

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

12. Advanced Microsoft Excel 2013 Training – Useful Data Functions

1201 Using The MATCH Function
1202 How The INDEX Function Works
1203 Handling Out Of Range Index Requests
1204 The CHOOSE Lookup Function
1205 MATCH And INDEX Functions Working Together

13. Advanced Microsoft Excel 2013 Training – Some Other Useful Functions

1301 Introducing IS Functions
1302 Error Checking Using ISERR, ISERROR, And IFERROR
1303 OFFSET Function Syntax
1304 OFFSET Function: Creating A Dynamic Named Range
1305 INDIRECT Function To Build Dynamic Formulas
1306 Dealing With INDIRECT Errors
1307 The CELL Function And Determining File Or Sheet Names

14. Advanced Microsoft Excel 2013 Training – Auditing And Troubleshooting Formulas

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

15. Advanced Microsoft Excel 2013 Training – PivotTables

1501 What Is A PivotTable?
1502 The New Recommended PivotTable Route
1503 Creating Your Own PivotTables
1504 Changing The Formatting And Formulas In PivotTable Summaries
1505 Creating Multiple PivotTables On The Same Dataset
1506 Moving And Deleting PivotTables
1507 Making Use Of The Report Filter Options
1508 Sorting The PivotTable Columns
1509 Refreshing A PivotTable
1510 Drilling Down Behind The Pivot Numbers
1511 Multiple Fields In Row, Column, Or Data Sections
1512 Controlling Grand Totals And Subtotals
1513 Dealing With Empty Cells And Other Additional Options
1514 PivotTable Styles
1515 Creating Your Own PivotTable Styles
1516 Creating And Using Calculated Fields
1517 Using The New Timeline Filter Option
1518 Adding And Using The Data Slicer
1519 Using Data From An SQL Server In A PivotTable
1520 Managing The External Connection To SQL Server

16. Advanced Microsoft Excel 2013 Training – PivotCharts

1601 Creating A PivotChart
1602 Changing The Fields Used In A PivotChart
1603 Formatting The PivotChart
1604 Changing The PivotChart Type
1605 Filtering A PivotChart
1606 Hiding The PivotChart Buttons
1607 Moving And Deleting PivotCharts

17. Advanced Microsoft Excel 2013 Training – Goal Seek And Solver

1701 What-If Analysis Using Goal Seek
1702 Activating The Solver Add-In
1703 Using Solver To Complete A What-If
1704 Adding Constraints To Solver

18. Advanced Microsoft Excel 2013 Training – Macros

1801 What Is A Macro
1802 Creating And Running Your First Macro
1803 Saving Workbooks With Macros
1804 Macro Security Settings For Workbooks With Macros
1805 The Personal Macro Workbook
1806 Deleting Macros
1807 Use Of Relative Or Absolute Referencing
1808 Trigger A Macro With A Keyboard Shortcut
1809 Formatting With A Macro
1810 Switch Scenarios And Views With Macros
1811 Use Of Worksheet Buttons To Trigger Macros
1812 Customizing Form Buttons And Other Shape Triggers
1813 Assigning Macros To Ribbon Icons
1814 Create Your Own Ribbon
1815 View And Edit Macro Code
1816 Add An Are You Sure Box To Macros

19. Advanced Microsoft Excel 2013 Training – Summary And Credits

1901 What Have I Learned
1902 About The Author

written by maxdugan

Leave a Reply