Microsoft Excel 2019 Level 1 - Beginner Excel 2019
.MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 44100 Hz, 2ch | 3.88 GB
Duration: 6.5 hours | Genre: eLearning | Language: English

Learn Microsoft Excel skills that will give you a solid foundation (Microsoft Excel 2010, 2013, 2016, 2019 and 365).
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
Requirements
You will need Excel installed on your computer to follow along and complete the exercise files
Videos have been recorded using Excel 2019, and most features will work in Excel 2010, 2013, 2016 and 365
Description
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!
Who is the target audience?
This Microsoft Excel 2019 Beginner Level 1 course is for anyone who is just starting out in Excel and also wants the latest, newest features available in Excel 2019 and Office 365 Excel skills
For those who've used Excel, but want to find out some little-known tips, tricks and shortcuts and become more efficient