Excel 2013

Intermediate
Request a Free Trial

Course Overview

Instructor: Ed McCrae
Subject: Excel 2013
Duration: 04 Hour 18 Minutes
Level: Intermediate
Pre-requisites: Excel Introduction course or equivalent experience.

Description

This course is designed to be the intermediate level of Excel 2013. Students will learn intermediate functions and formulas, be introduced to and work with PivotTables and Tables, work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.

Introduction
Introduction1min 22sec
Customizing Excel
Customizing the Ribbon6min 43sec Customizing the Quick Access Toolbar5min 26sec Customizing General Formula Options1min 58sec Customizing AutoCorrect Options2min 46sec Customizing Save Defaults1min 56sec Customizing Advanced Excel Options2min 11sec
Linking Workbooks & Worksheets
Linking Workbooks and Worksheets3min 39sec Linking Worksheets with 3D References3min 01sec Updating Workbook Links1min 43sec Understanding the Consolidate Feature4min 56sec
Working with Range Names
What Are Range Names?3min 04sec Creating Range Names Using the Name Box and Define Name3min 52sec Creating Range Names Using Create From Selection2min 23sec Using the Name Manager to Manage Range Names2min 11sec Using Range Names in Formulas4min 36sec
Analyzing Data with Common Logical Functions
Working with the Most Common Logical Functions2min 23sec Evaluating Data with the AND Function2min 53sec Evaluating Data with the OR Function2min 34sec Understanding IF Functions4min 08sec Nesting AND & OR Inside an IF Function4min 36sec
Analyzing Data with Common Lookup Functions
What are Lookup Functions?2min 35sec Using VLOOKUP7min 38sec Using HLOOKUP2min 38sec
Sorting and Filtering Range Data
Understanding the Differences between Sorting and Filtering1min 42sec Sorting Lists3min 50sec Filtering Lists3min 40sec
Analyzing and Organizing with Tables
Creating and Exploring the Benefits of Tables2min 14sec Elements of a Table4min 07sec Formatting a Table3min 30sec Sorting Tables1min 50sec Filtering Tables2min 29sec Filtering with Slicers3min 02sec Calculating with Tables2min 57sec Removing Erroneous Table Data2min 26sec Exporting, Refreshing, and Converting Tables2min 21sec
Using Conditional Formatting
What is Conditional Formatting?1min 35sec Using Highlight Cells and Top/Bottom Rules3min 55sec Using Data Bars, Icon Sets, and Color Scales4min 47sec Using Custom Fonts and Colors2min 07sec Using Custom Conditional Formatting2min 39sec Modifying or Removing Conditional Formatting2min 49sec
Outlining with Subtotals and Grouping
What are Subtotals and Grouping?1min 35sec Creating Subtotals3min 16sec Grouping and Ungrouping Data1min 30sec
Displaying Data Graphically
What are Charts?2min 07sec Creating Charts2min 40sec Understanding Chart Elements3min 20sec Modifying Charts Elements6min 18sec Changing and Moving Charts3min 05sec Filtering a Chart2min 02sec Formatting Charts6min 05sec Adjusting Numbering4min 33sec Creating Dual Axis Charts2min 59sec Forecasting with Trendlines4min 07sec Creating a Chart Template1min 44sec Displaying Trends with Sparklines4min 11sec
Understanding PivotTables, PivotCharts, and Slicers
What is a PivotTable?3min 31sec Creating a PivotTable3min 42sec Working with the PivotTable Fields Pane6min 40sec Basic Data Organization and Analysis with PivotTables3min 36sec Formatting PivotTables5min 01sec Creating a PivotChart2min 35sec Modifying and Formatting a PivotChart2min 41sec Adding Slicers and Timeline Slicers3min 40sec Formatting Slicers2min 16sec
Working with Flash Fill
What is Flash Fill?1min 55sec Using Flash Fill and AutoFill3min 39sec Filling Various Series3min 12sec
Working with Date and Time Functions
What are Date and Time Functions?2min 16sec Using TODAY, NOW, and DAY Functions2min 27sec Using NETWORKDAYS and YEARFRAC Functions2min 43sec
Working with Common Text Functions
What are Text Functions?1min 33sec0%1min 33sec Using CONCATENATE2min 58sec Using Text to Columns1min 49sec Using LEFT, RIGHT, and MID Functions3min 06sec Using UPPER, LOWER, and PROPER Functions1min 51sec
Conclusion
Course Recap1min 53sec

Ed McCrae

Ed specializes in Excel Workbook development, Access Database Design, and SharePoint site creation and administration. Ed has been in the technical training industry since 2006 and has taught Microsoft Office 97-2016, Microsoft Project, SharePoint 3.0 – 2013, as well as a host of other applications and business skills classes.

Learn More About Ed McCrae

© 2017 NH Learning Solutions | Terms and Conditions | Privacy