Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 23 Minute(s)
Language
English
Taught by
Kirt Kershaw
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn Microsoft Excel skills that will give you a solid foundation (Microsoft Excel 2010, 2013, 2016, 2019 and 365).
Quickly Get a Solid Foundation on Excel 2019 Basics
During this Microsoft Excel Level 1 – Beginner course you will gain a solid foundation on which you will build the rest of your Excel experience on. Enroll now and I'll guide you step-by-step, through the basics of working with the basics on formulas and functions. In very little time you will master the basics of Excel that'll provide a sure foundation for more intermediate to advanced Excel techniques.
At completion of this course you will have mastered the most popular Excel basic tools and have the foundational skills with a sureness to complete many daily Excel tasks with efficiency and ease. Below are just a few of the topics that you will master:
Build a solid understanding on the basics of Microsoft Excel
Writing formulas and performing calculations
SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE functions
Inserting headers and footers, and adjusting margins
Print row and, or column page titles
Color code data that meet certain criteria with Conditional Formatting
Save time applying formatting to other cells with shortcuts
Copy formulas about with accuracy by applying Absolute and, or Mixed References
Save time entering data using the AutoFill and FlashFill features
Split Worksheet, Freeze Panes and add Multiple Views
New to Excel 2019! Sound Feedback, Check Accessibility one click fix, Translate and more!
Course Content
- 8 section(s)
- 59 lecture(s)
- Section 1 Introduction
- Section 2 Practice Activities and Instructor Notes
- Section 3 Basics
- Section 4 Functions & Formulas
- Section 5 Editing Worksheets
- Section 6 Formatting
- Section 7 Print
- Section 8 Modifying Worksheet Appearance
What You’ll Learn
- Build a solid foundation on the Basics of Microsoft Excel
- Create a Basic Worksheet from scratch
- Write simple Formulas and performing Calculations
- Use Relative, Absolute and Mixed References
- Learn how to do basic and setup your own custom number formats
- More tips, tricks and shortcuts by a Multi-Certified Microsoft Trainer with over 18 years of Excel training
Skills covered in this course
Reviews
-
SStephanie Griffith
Explanations are clear and move along at a good pace.
-
SSarah Zarling
I had to pause & rewind a lot, especially if I took too long of a pause (days or weeks) between the videos, in order to even remember what I learned to be able to take the quiz. Which, I guess is really my fault. It was quite a bit of information to absorb for a person that is brand new at Excel. I am thankful that I will be able to review the exercises time & time again, until the more difficult ones become more natural to apply to my daily life. Thank you!
-
CChris Russell
Excellent course. If you need a better understanding of Excel and need it explained in everyday language with a splash of humor in each lesson then I would say this is the course to get and the instructor for you. Enjoyed it thoroughly and will be taking more courses from you in the future.
-
DDale Barth
very infomative
