Microsoft Excel Basics for Real World Use: Full Course

Access for 7 days
Write your awesome label here.
In Canada? Purchase on our Canada E-Store

Course Description

Microsoft Excel is the most useful, and most often misunderstood, program in the Office Suite. Many of us shy away because it seems so complex and overwhelming, but learning the tools that will help get your daily work done is simple . . . if you have the right instructor. ZenTek developed this class for the beginning, or infrequent, user of Excel who wants to get a better handle on how to perform basic formatting, calculation, and data sorting functions in one of the most powerful programs on the market.
ZenTek Consultants, a certified Microsoft Cloud Solutions Provider, will show students the tools they need in order to use MS Excel on real-world jobs. This eight (8) hour course is delivered in four (4), two-hour long sessions.

Course Curriculum

Session 1 – Understanding the Basics
• Understanding and Creating Worksheets
• Working with Multiple Worksheets
• Understanding Cells and Columns
• Formatting and Aligning Cells
• Understanding and Editing Data Types
• How to Format, Merge, and Control Cells
Session 2 – Fun with Functions and Formulas
• Controlling Worksheet Views
• Using Automatic Fill Features
• Understanding Formulas and the Formula Bar
• Using Common Functions and Formulas
• Using Formulas across Worksheets
Session 3 – Delving into Data
• Working With Data Filters
• Understanding Data Sorting
• Removing Duplicate Values
• How to Merge and Split Data Cells
• Adding Data Validation
Session 4 – Summarizing Simplified
• Controlling Page Layouts
• Inserting Images and Symbols
• Creating Simple Charts
• Editing Chart Display Options
• Working with Pivot Tables
Please note that this course uses Microsoft Excel 2016.

PLEASE READ BEFORE PURCHASE:

  • Course is available for viewing for 120 consecutive hours (5 consecutive days) after purchase.
  • Once purchase is made, NO REFUNDS will be given.
  • Purchase is for one user only. Use for multiple persons can be arranged by contacting us.
  • Please read the full Terms and Conditions.

Course Contents

The course video comes with files that should be downloaded prior to starting the course. After purchase, you can download the files by clicking on the paper clip icon to the right of the video name below.
Share this page with a friend
Created with

We use cookies to provide you with an optimal experience and relevant communication. Learn more or accept individual cookies.

Necessary

Necessary cookies (First Party Cookies) are sometimes called "strictly necessary" as without them we cannot provide the functionality that you need to use this website. For example, essential cookies help remember your preferences as you navigate through the online school.

Functional

Functional cookies enable this website to provide enhanced functionality and personalization, by remembering information you have entered and choices you make. These preferences are remembered through the use of persistent cookies, so that you will not have to set them again the next time you visit the website.

Analytics

Analytics cookies track information about visits on our website so that we can measure and improve its performance, as well as optimize our course content. These cookies help us analyze user behavior by tracking the number of visits, how visitors use the website, which site or page they come from and how long they are staying for.

Marketing

Marketing cookies are used to deliver advertising material relevant to you and your interests. They are also used to limit the number of times you see an advertisement, resulting to more targeted advertising, as well as help us measure the effectiveness of our campaigns. They are usually placed by advertising networks we collaborate with, with our permission.