Simpliv Course on Microsoft Excel 2016 Beginner Level

Simpliv Course on Microsoft Excel 2016 Beginner Level

 

Invite friends

Contact Us

Page Views : 5

About The Event

Description

This training provides you with everything you need to know about getting started with the basics of Microsoft Excel.

Begin with the fundamentals, and after taking this class you’ll have a sure foundation to build upon in Microsoft Excel with a greater level of confidence in its use and execution.

You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed and taught by the most experienced and multi-certified Microsoft Office trainer on the web, this course provides the most comprehensive and introductory coverage to Microsoft Excel. A Microsoft Certified Trainer and Professional, Microsoft Office Specialist, Expert and Master Instructor since 2000, with over 16 years of experience teaching individuals of all ability levels on “how to use” and “certify” in Microsoft Office, Kirt Kershaw has added, refined, designed and perfected this course to make it easy for you to master the fundamental basics of Microsoft Excel.

As you participate in this course you will master essential Excel tools that will clear away the pain of stumbling through your daily tasks. Additionally, you will have the basics, and built a solid foundation of knowledge and skills to prepare you to continue your progress up to my next course: Microsoft Excel 2016 Intermediate Level 2.

At completion of this course you will have mastered the most popular basic Excel tools, and come out with confidence to complete these Excel tasks with efficiency and grace.

Taking this course, along with my Microsoft Excel 2016 Intermediate Level 2, includes all the training you need to help you pass Microsoft’s Excel 2016 Core (77-727) Exam and become certified. Add those courses together with my third and final course in this series, Microsoft Excel 2016 Advanced Level 3, and have all training you need to help you pass the Microsoft Excel Expert (77-728) Exam and become certified.

 

Basic knowledge
  • No other prerequisites: The course covers everything you need to begin learning Microsoft Excel
  • To view the videos, you’re good! However, if you’d like to work on the exercises after having watched the videos, to practice what you’ve learned, then you’ll need Microsoft Excel installed to work on the Excel exercises
  • This Microsoft Excel course was created in Excel 2016 and most features will work and is compatible with previous version of Excel including: Excel 2007, Excel 2010, or Excel 2013

 

What you will learn

In only five hours of videos, provided to you in 54 separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:

  • Learn how to customize Excel Environment
  • Learn how customize the Ribbon and Quick Access Toolbar with Excel commands
  • Learn how to navigate around Excel
  • Learn how to create an Excel basic spreadsheet
  • Learn how to save and create backups of your Excel Workbook
  • Learn how to enter and edit data in Excel
  • Learn how to write formulas quickly and easily, or use the point and click method
  • Learn how to create powerful calculations with Excel functions
  • Learn how to move, copy, cut and paste data in Excel
  • Learn how to use relative, absolute, and mixed references in Excel
  • Learn how to instantly extract data and fill in one column from an adjacent column of data with AutoFill and FlashFill
  • Learn how to break up groups of data into smaller, more meaningful parts, or into cells with Text to Columns
  • Inserting, or removing extra or unwanted columns, rows and cells for a more organized, and effective looking spreadsheet
  • Learn how to find and, or replace data instantly throughout your worksheet, or entire Excel workbook
  • Learn how to "freeze columns and rows" with freeze panes in Excel
  • Learn how to "transpose data" - switching the columns and rows in Excel
  • Learn how to format worksheets in Excel for impact and appeal
  • Learn tips, tricks and shortcuts about Excel
  • Learn how to apply basic and custom number formats including: how to add text to a number without Excel seeing it as part of the number
  • Increase your productivity with formatting shortcuts to rapidly apply a selected format to other cells throughout your Excel spreadsheet
  • Learn how to flag, or alert yourself with color based upon a cell displaying certain data with Conditional Formatting in Excel
  • Learn how to print row and, or column page titles so the reader knows what column, or row of data they’re looking at when they turn past the first page in Excel
  • Include in printing your Excel spreadsheets, at the top or bottom of every page, text, images, logos, page numbers, date and time with Headers and Footers
  • How to manage large amounts of data in Excel
  • Use Page Breaks to help control the amount of data you don’t want breaking to soon or late across other pages when printing your spreadsheets in Excel
  • And so much more in this Excel course.

Additional bonus materials include:

  1. Exercise Files – you can download all that are used in the Excel videos for your personal, “hands-on” practice
  2. Quiz – you can download the Excel quiz that has one questions per video to test on what you’ve learned
  3. Instructor Notes – you can download as a quick Excel reference guide of the main points covered in each video, without having to watch the video over again.

Another great part of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION.

All three of my Excel classes are guaranteed to teach you Microsoft Excel, and if desired, to help you pass the Excel Core and Expert Exams and become certified. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review, or to learn new material about how to use Excel. Described as “fun” and “easily understandable” and “amazing” Kirt Kershaw’s Excel training will forever change the way you work with numbers. Try this course for yourself and see how you too can quickly and easily learn Microsoft Excel.

Register Here