Video description
In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.
You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Guy also covers some basic Macro operations within Excel for optimizing your workflow.
By the completion of this computer based training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.
Table of contents
- Getting Started
- Using Mathematical Functions
- IF Functionality
- Performing Data Lookups
- Sparklines
- Further Mathematical Functions
- Outlining
- Scenarios
- 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
- Useful Data Functions
- Some Other Useful Functions
- Auditing And Troubleshooting Formulas
-
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
- Goal Seek And 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
Product information
- Title: Advanced Microsoft Excel 2013
- Author(s):
- Release date: January 2013
- Publisher(s): Infinite Skills
- ISBN: 9781771370646
You might also like
video
Microsoft Excel 2013
In this Microsoft Excel 2013 training course, veteran trainer Guy Vaccaro takes you through the basics …
video
Microsoft Excel Beginners 2016
This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading …
video
Learning Microsoft Excel 2016
In this Learning Microsoft Excel 2016 training course, expert author Guy Vaccaro will teach you everything …
book
Microsoft Excel 365 Bible
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365 Excel …