Take this
course

Office Productivity / Microsoft

Excel 2013 Intermediate

Take your Excel 2013 skills to the next level. Learn how to create subtotals, work with PivotTables, format charts, and more.

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. 


Instructor: Ed McCrae

Full details

Curriculum

  • Introduction
    Introduction
    1:17
    Course Exercise Files
  • Customizing Excel
    Customizing the Ribbon
    6:44
    Customizing the Quick Access Tool Bar
    5:27
    Customizing General and Formula Options
    1:59
    Customizing AutoCorrect Options
    2:47
    Customizing Save Defaults
    1:57
    Customizing Advanced Excel Options
    2:12
  • Linking Workbooks & Worksheets
    Linking Workbooks and Worksheets
    3:40
    Linking Worksheets with 3D References
    3:02
    Updating Workbook Links
    1:44
    Understanding the Consolidate Feature
    4:57
  • Working with Range Names
    What Are Range Names?
    3:05
    Creating Range Names Using the Name Box and Define Name
    3:53
    Creating Range Names Create From Selection
    2:24
    Using the Name Manager to Manage Range Names
    2:12
    Using Range Names in Formulas
    4:37
  • Analyzing Data with Common Logical Functions
    Working with Most Common Logical Functions
    2:24
    Evaluating Data with the AND Function
    2:54
    Evaluating Data with the OR Function
    2:35
    Understanding IF Functions
    4:09
    Nesting AND & OR Inside an IF Function
    4:37
  • Analyzing Data with Common Lookup Functions
    What are Lookup Functions
    2:36
    Using VLOOKUP
    7:39
    Using HLOOKUP
    2:39
  • Sorting and Filtering Range Data
    Understanding the Differences between Sorting and Filtering
    1:43
    Sorting Lists
    3:51
    Filtering Lists
    3:41
  • Analyzing and Organizing with Tables
    Creating and Exploring the Benefits of Tables
    2:15
    Elements of a Table
    4:08
    Formatting Tables
    3:31
    Sorting Tables
    1:51
    Filtering Tables
    2:30
    Filtering with Slicers
    3:03
    Calculating with Tables
    2:58
    Removing Erroneous Table Data
    2:27
    Exporting, Refreshing, and Converting Tables
    2:22
  • Using Conditional Formatting
    What is Conditional Formatting?
    1:36
    Conditional Formatting Highlight Cells and Top/Bottom Rules
    3:56
    Conditional Formatting Data Bars, Icon Sets, and Color Scales
    4:48
    Using Custom Fonts and Colors
    2:08
    Using Custom Conditional Formatting
    2:40
    Modifying or Removing Conditional Formatting
    2:50
  • Outlining with Subtotals and Grouping
    What are Subtotals and Groupings?
    1:36
    Creating Subtotals
    3:17
    Grouping and Ungrouping Data
    1:31
  • Displaying Data Graphically
    What are Charts?
    2:09
    Creating Charts
    2:41
    Understanding Chart Elements
    3:21
    Modifying Chart Elements
    6:19
    Changing and Moving Charts
    3:06
    Filtering a Chart
    2:03
    Formatting Charts
    6:06
    Adjusting Numbering
    4:34
    Creating Dual Axis Charts
    3:00
    Forecasting with Trendlines
    4:08
    Creating a Chart Template
    1:45
    Displaying Trends with Sparklines
    4:12
  • Understanding PivotTables, PivotCharts, and Slicers
    What is a Pivot Table
    3:32
    Creating a Pivot Table
    3:43
    Working with Pivot Table Fields Pane
    6:41
    Basic Data Organization and Analysis with Pivot Tables
    3:37
    Formatting PivotTables
    5:02
    Creating a Pivot Chart
    2:36
    Modifying and Formatting a PivotChart
    2:42
    Adding Slicers and Timeline Slicers
    3:41
    Formatting Slicers
    2:17
  • Working with Flash Fill
    What is Flash Fill?
    1:56
    Using Flash Fill and Autofill
    3:40
    Filling Various Series
    3:13
  • Working with Date and Time Functions
    What are Date and Time Functions?
    2:17
    Using TODAY, NOW, and DAY Functions
    2:28
    Using NEWTWORKDAYS and YEARFRAC Functions
    2:44
  • Working with Common Text Functions
    What are Text Functions
    1:34
    Using CONCATENATE
    2:59
    Using Text to Columns
    1:50
    Using Left, Right, Mid Functions
    3:07
    Using Upper, Lower, and Proper Functions
    1:52
  • Conclusion
    Course Recap
    1:54

Skills

  • Microsoft Excel

Similar Courses

More Courses by this Instructor