Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
  1. Courses
  2. /Office Productivity
  3. /MS Excel

Excel 2016 Beginners

Training Course

Created bySimon Sez ITworkspace_premiumBest Instructor
BeginnerUpdated Jan 21, 2025

What You'll Learn

  • check_circlePerfect for complete beginners Follow along exercises included 9 hours of detailed training in over 65 easy to follow videos Expert instructor Simon Sez IT has taught over 400k people essential software skills

About This Course

This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you from the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you're using Excel 2016 like a pro with advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business. This course starts with where to find Microsoft Excel and installing the program. Then you learn step-by-step, simple 1-2-3 methods for getting up and running with Excel 2016. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 16 chapters of video lessons and 5 exercise files to gradually become a proficient user. It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them. Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars, entering and editing data, backup and recovery, fill and series, and printing your projects. We also work with Worksheets and formulas and functions. Upon completion of this course you will know the essentials of Microsoft Excel 2016.

Course Content

1 activity • 64 videos • duration: 9h 29m

remove
Videos-Part164 videos • 9.5 hours
  • videocamAcquiring Excel 2016 and Information on Installation and Upgrade
    Duration 12:02
  • videocamExercise Files
    Duration 2:28
  • videocamNew and Improved Features in Excel 2016
    Duration 2:55
  • videocamOverview of Principles of Using Touchscreen
    Duration 5:36
  • videocamCreating and Saving a Workbook
    Duration 15:16
  • videocamOpening a Workbook
    Duration 10:13
  • videocamOnline Help and Contextual Help
    Duration 6:27
  • videocamPersonalizing your use of Excel
    Duration 10:50
  • videocamBasics of using the Ribbon
    Duration 14:56
  • videocamQuick Access Toolbar
    Duration 5:45
  • videocamTell Me Feature
    Duration 6:49
  • videocamMini Toolbars and Contextual Menus
    Duration 3:47
  • videocamStatus Bar
    Duration 5:02
  • videocamBasics of Entering and Editing Data in a Workbook
    Duration 13:29
  • videocamExercise 01
    Duration 1:50
  • videocamFormatting Dates
    Duration 12:36
  • videocamFormatting Numbers
    Duration 13:48
  • videocamExercise 02
    Duration 1:43
  • videocamAutoSave, Recover Unsaved Workbook, and Create a Backup Copy
    Duration 7:35
  • videocamWorking with Fill and Series
    Duration 9:08
  • videocamFlash Fill
    Duration 4:04
  • videocamWorkbook Views, Zoom, and Freeze
    Duration 8:41
  • videocamPrinting
    Duration 14:29
  • videocamExercise 03
    Duration 2:55
  • videocamMethods of Cutting, Copying, and Pasting
    Duration 13:32
  • videocamDelete and Clear
    Duration 13:45
  • videocamInsert, Hide, Column Width and Row Height, and Merge
    Duration 12:46
  • videocamAlignment
    Duration 12:05
  • videocamThemes and Styles
    Duration 11:19
  • videocamExercise 04
    Duration 1:44
  • videocamBasics of Formulas and Functions
    Duration 11:15
  • videocamComplex Examples of Formulas
    Duration 13:36
  • videocamExercise 05
    Duration 3:25
  • videocamRename, Insert, Move, and Reference a Worksheet
    Duration 8:40
  • videocamWorking with Multiple Workbooks
    Duration 15:48
  • videocamSaving in Different File Types
    Duration 12:58
  • videocamThe Spell Checker
    Duration 13:11
  • videocamInserting Comments
    Duration 4:54
  • videocamExercise 06
    Duration 3:01
  • videocamThe VLOOKUP Function
    Duration 14:06
  • videocamText Functions
    Duration 8:17
  • videocamDate and Time Functions
    Duration 6:47
  • videocamLogical Functions
    Duration 15:51
  • videocamCreating Graphs and Charts
    Duration 12:09
  • videocamCustomizing a Cluster Column Chart
    Duration 15:41
  • videocamCustomizing a Pie Chart
    Duration 13:35
  • videocamNew Chart Types in Excel 2016
    Duration 2:01
  • videocamExercise 7
    Duration 2:28
  • videocamManaging Data by Sorting
    Duration 9:39
  • videocamManaging Date by Filtering
    Duration 11:59
  • videocamCustomizing Tables
    Duration 13:23
  • videocamInserting Shapes and Pictures
    Duration 15:00
  • videocamExercise 08
    Duration 0:47
  • videocamConditional Formatting
    Duration 15:32
  • videocamProtecting Worksheets
    Duration 9:35
  • videocamProtecting Workbooks
    Duration 10:21
  • videocamGiving Items Names
    Duration 6:30
  • videocamExercise 09
    Duration 2:10
  • videocamFind and Replace
    Duration 7:09
  • videocamAdding Borders
    Duration 10:44
  • videocamInspecting a Workbook
    Duration 6:08
  • videocamTrust Center Privacy Options
    Duration 5:46
  • videocamSharing a Workbook
    Duration 8:30
  • videocamConclusion and Close
    Duration 0:56

Your Instructor

Simon Sez IT

Since 2008, we've taught 2 million learners in over 190 countries, with 200+ courses

menu_book151 courses
star9,304 reviews

Since its formation in 2008, Simon Sez IT has been educating learners with one goal in mind: to make business and technical software simple to learn. The company extensive library of over 10,000 videos across more than 200 courses delivers comprehensive training for the most popular software applications used by professionals worldwide. Courses include training in everyday IT applications, from Microsoft suite of office productivity tools to more niche applications such as QuickBooks, Power BI and many more. Aimed at every level of proficiency, Simon Sez IT courses are designed to give learners the ability to quickly evolve from beginner to advanced, or to drop in at their relevant level and acquire new skills to continue in their development path. Simon Sez IT subject matter experts bring knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply new knowledge and master learning goals. More than two million learners have relied on Simon Sez IT for its quality and engaging coursework. Student feedback is consistently ranked among the best in the industry, with particular emphasis on the quality, detail and delivery of the course materials. Many indicate that upon completion of a course, they are more confident and proficient in their area of study, and their skills have helped them progress in their careers.

Credit Information

Is this course eligible for my CPD requirements as a Canadian CPA?

Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.

Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.

What Students Are Saying

4.7 out of 5
Student's Choice
15 reviews
  • JB
    Julia B.
    starstarstarstarstar

    I really enjoyed the course. My only suggestion would be to focus a bit more on the easy things like using the right mouse key to access commands rather than going to the very complicated top area of the screen where all the commands are. To a newcomer this can be more confusing. Otherwise I enjoyed going through all the Excel functions and learned quite a few concepts that I will put to work.

  • JN
    Jennifer N.
    starstarstarstarstar

    It is a very comprehensive basic to intermediate Excel 2016 course. I learned a lot from this course.

  • SS
    Scott S.
    starstarstarstarstar

    I thought the exercises on locking worksheets was useful but it didn't comment on what happens if you forget what your password is.

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(556 reviews)
    2 CPD hrs
  • Finance: Budgeting & Financial Forecasting

    Critical Skills for CFOs & Controllers: Budgeting & Forecasting Strategies for Today’s World

    starRated5.0out of 5,(113 reviews)
    2.5 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(646 reviews)
    2.5 CPD hrs