Office Productivity Training – Microsoft Office 2013 Excel Intermediate Series!

$49.00Add to cart


This course provides students with the knowledge and skills to advance their data analysis skills and abilities through the application of advanced Excel 2013 functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts.

Course Modules:

Module 01: Creating Advanced Formulas

(Duration: 30m )

  1. Workbook
  2. Topic A: Apply Range Names
  3. Worksheet without Range Names
  4. Worksheet with Range Names
  5. Excel 2013’s Save Options
  6. Where to Access Saved Versions
  7. Demo 1-1: Adding Range Names
  8. Demo 1-2 & 1-3: Editing and Deleting a Range Name
  9. Demo 1-4: Using Range Names in a Formula
  10. Topic B: Use Specialized Functions
  11. The Function Library
  12. Logical Functions
  13. Statistical Functions
  14. Syntax of the AVERAGE Function
  15. The Insert Function Dialog Box
  16. The Function Arguments Dialog Box
  17. Demo 1-5: Locating Functions by Using the Function Reference
  18. Demo 1-6: Using Functions
  19. Lesson 01 Review
  20. Review Quiz (Number of attempts allowed: Unlimited)

Module 02: Analyzing Data with Logical and Lookup Functions

(Duration: 26m)

  1. Workbook
  2. Topic A: Leverage Questions and Testing to Write Formulas
  3. Topic B: Use Logical and Lookup Functions to Find Answers to Questions
  4. Logical Functions
  5. Demo 2-1: Working with Logical Functions
  6. Demo 2-2: Combining IF and AND Functions
  7. The VLOOKUP Function
  8. The HLOOKUP Function
  9. Demo 2-3: Working with Lookup Functions
  10. Lesson 02 Review
  11. Review Quiz (Number of attempts allowed: Unlimited)

Module 03: Organizing Worksheet Data with Tables

(Duration: 1h 1m )

  1. Workbook
  2. Topic A: Create and Modify Tables
  3. A Sample Table
  4. The Create Table Dialog Box
  5. The TABLE TOOLS DESIGN Contextual Tab
  6. Demo 3-1: Converting a Range to a Table
  7. Topic B: Sort and Filter Data
  8. Data Sorted on a Single Column
  9. Data Sorted on Multiple Columns
  10. Filtered and Sorted Data
  11. Advanced Filter with Three Criteria
  12. Demo 3-2: Sorting Data and Removing Duplicate Records
  13. Demo 3-3: Filtering Records
  14. Topic C: Use Summary and Database Functions to Calculate Data
  15. The SUBTOTAL Function
  16. Demo 3-4: Using Subtotals with Range Data
  17. Summary Functions in Table Total Row: Example 1
  18. Summary Functions in Table Total Row: Example 2
  19. Compare SUM to DSUM
  20. Demo 3-5: Using Summary Functions in Tables
  21. Demo 3-6: Using Database Functions
  22. Lesson 03 Review
  23. Review Quiz (Number of attempts allowed: Unlimited)

Module 04: Visualizing Data with Charts

(Duration: 50 m)

  1. Workbook
  2. Topic A: Create Charts
  3. Data in a Table
  4. Data in a Chart
  5. The Insert Chart Dialog Box
  6. Demo 4-1: Creating Charts
  7. Topic B: Modify and Format Charts
  8. Demo 4-2: Modifying Charts
  9. Demo 4-3: Formatting Charts
  10. Topic C: Create a Trendline
  11. Trendlines Forecasting Out Two Years
  12. The Format Trendline Dialog Box
  13. Demo 4-4: Creating a Trendline
  14. Topic D: Create Advanced Charts
  15. A Dual-Axes Chart
  16. Demo 4-5: Creating a Dual-Axes Chart
  17. Lesson 04 Review
  18. Review Quiz (Number of attempts allowed: Unlimited)

Module 05: Analyzing Data with PivotTables, Slicers, and PivotCharts

(Duration: 40 m )

  1. Workbook
  2. Topic A: Create a PivotTable
  3. A Standard Table
  4. A PivotTable
  5. The PivotTable Field List Pane
  6. The Summarize Values By Options
  7. Summarizing Values by Using the MIN Function
  8. The Show Values As Options
  9. Showing Values As a Percent of the Grand Total
  10. Combining Summarize and Show (Example 1)
  11. Combining Summarize and Show (Example 2)
  12. Demo 5-1: Creating PivotTables
  13. Topic B: Filter Data by Using Slicers
  14. Slicers and a PivotTable
  15. Demo 5-2: Adding Slicers
  16. Topic C: Analyze Data by Using PivotCharts
  17. Slicers and a PivotChart
  18. Demo 5-3: Creating a PivotChart
  19. Lesson 05 Review
  20. Review Quiz (Number of attempts allowed: Unlimited)

Module 06: – Inserting Graphics

(Duration: 27 m)

  1. Workbook
  2. Topic A: Insert and Modify Graphic Objects
  3. The INSERT Tab’s Illustration Group
  4. Types of Shapes
  5. Demo 6-1: Inserting Pictures and Clip Art
  6. Topic B: Layer and Group Graphic Objects
  7. Layers
  8. A Hidden Layer
  9. The Same Layers in a New Stacking Order
  10. Three Graphic Objects, No Grouping
  11. Three Graphic Objects in One Group of Three
  12. Demo 6-2: Inserting and Grouping Shapes
  13. Topic C: Incorporate SmartArt
  14. The Choose a SmartArt Graphic Dialog Box
  15. Demo 6-3: Incorporating SmartArt
  16. Lesson 06 Review
  17. Review Quiz (Number of attempts allowed: Unlimited)

Module 07: Enhancing Workbooks

(Duration: 29 m )

  1. Workbook
  2. Topic A: Customizing Workbooks
  3. A Comment
  4. Demo 7-1: Inserting Comments and Hyperlinks
  5. Topic B: Manage Themes
  6. Built-in Themes
  7. Demo 7-2: Applying and Editing a Theme
  8. Topic C: Create and Use Templates
  9. An Expense Report Template
  10. Demo 7-3: Creating a Template
  11. Topic D: Protect Files
  12. File Protection Options
  13. The REVIEW Tab’s Changes Group
  14. The Protect Sheet Dialog Box
  15. The Protect Structure and Windows Dialog Box
  16. Demo 7-4: Protecting a Worksheet and a Workbook
  17. Lesson 07 Review
  18. Course Closure
  19. Review Quiz (Number of attempts allowed: Unlimited)

This course includes

  • On-demand video
  • 7 downloadable Pdf Workbooks
  • Unlimited time access (During Membership)
  • Access on mobile and Desktop
  • Certificate of Completion

Course Features Include:

  • Expert Lectures
    Learn on-demand from top instructors who are industry subject matter experts. Our highly certified expert instructors possess a superior understanding of the subject matter in their fields and have the ability to convey this knowledge in an effective, engaging, and professional manner to a wide audience.

  • Certificates of Completion
    Upon completion of a series of courses you can earn a certificate of completion from Career Academy. Certificates of Completion will display your full name, course completed, as well as the date of completion. Students have the ability to print this out or save it digitally to showcase your accomplishment.

  • PowerPoint Visuals:
    Many of the in-depth theories and processes discussed in our courses can be learned most efficiently through the detailed PowerPoint slides presented. These visuals are accompanied by an instructor voice-over to provide our students with a clear, efficient, and complete presentation of concepts.

  • Professional Development Activities
    Students are provided access to professional development activity files which allow for an individual to test out course theories and apply the knowledge they earned from the course.

  • Review Quizzes
    Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.

  • Mobile Access
    With our universal course player, you can learn from your computer, tablet as well as mobile devices. Keep up with your training on the go!

Trusted by Aspiring IT Professionals, Corporations and
Government agencies
for more than a Decade

Get unlimited online access learn anywhere, anytime using your computer or mobile device!