Excel for Working Professionals - Beginner Plus Level (PKGIME170A)

Dennis Taylor
Language: English | Duration: 2.5 Hrs | CPE - 2.0 CPE Credits |
Loading the player...

What Will I Learn?

  • Basic Excel features and functions including the all-important AutoSum
  • Basics of data entry and indispensable shortcuts to simplify the task
  • Basic formulae and functions for data analysis
  • Cut/copy/paste techniques and keystroke shortcuts
  • Sorting and filtering techniques to re-arrange and hide data
  • Adding calculated fields to perform additional analysis
  • Using PivotTables to create summary information from a list
  • Creating a PivotChart that is in sync with a PivotTable
  • Dealing with dynamic source data and the “refresh” concept


One of the most widely used software programs in the world, Microsoft Excel has become the de facto standard for a variety of office applications and day-to-day tasks. Most people think of Excel as a spreadsheet program, and it is – but it's a whole lot more.

Using Excel to its full potential can open up a new world: Its powerful features and functions include everything from simple organization to complicated sorting and analytics. On the most basic level, Excel can help professionals at all levels stay organized and present information in easy-to-read charts. This Microsoft Excel Basics course will help you better understand Excel features and functions and will equip you with the tools and techniques you need to start using Excel to its full potential.

This course will help you learn not just the basics of Excel but also some creative ways to use this flexible program in your daily work. Excel expert Dennis Taylor, who has taught thousands of Excel seminars and classes, will provide a step-by-step guide on how to use Excel to complete any spreadsheet-based project – as well as projects that you may not have realized could benefit from better organization and presentation. You will also learn to use PivotTables and start unleashing the analytical power of Excel.

Practical Applications Include:
  • Using Excel's powerful and extensive menu system
  • Setting up worksheets and workbooks
  • Using shortcuts in data entry
  • Preparing data for analysis by PivotTables
  • Sorting and filtering relevant data from large data sets
  • Creating a PivotTable with a minimum number of steps
  • Manipulating the appearance of a PivotTable via dragging and command techniques
  • Creating ad hoc and date-based groupings within a PivotTable
  • Using the Slicer feature to filter PivotTable layouts

After completion of this course, you will have a chance to test your new skills with a helpful quiz. Enroll now, and master sorting, organizing and analyzing your data with Excel!

Dennis Taylor

Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses both for online and DVD distribution.


Chapter 1

  • Data Entry Basics
  • Different Tabs in Ribbon Menu System
  • Difference between Worksheet and Workbook
  • Fill Handle Feature
  • Quick Access Toolbar
  • Undo, Erase Data
  • Make Changes to Multiple Cells
  • DAlign Data in Cell
  • Different Ways of Writing Formulas
  • Basic functions - SUM, AVERAGE, AUTOSUM
  • Find all the Formulas in Worksheet
  • Copying Data
  • Formatting Features
  • View Multiple Workbooks
  • Sort Data
  • Filter Data
  • Create Different Chart Types
  • Introduction to Pivot Tables

Chapter 2

  • Preparing data to be analyzed by PivotTables
  • The Pivot Table Field List
  • The Pivot Table Tools
  • Different Ways to Combine Data
  • Pivot Charts, Slicers, How Excel Works with Dates

2.0 CPE Credits

Online Course



  • One year access
  • 2.0 CPE Credits
  • Certificate of Completion
  • 2 sessions one hour each
  • Quiz 10 minutes

Coming Soon

  • Intermediate Course
  • Advance Course