Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
21 Hour(s) 33 Minute(s)
Language
English
Taught by
Simon Sez IT
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
The Most Convenient Way to Boost Your Confidence And Learn Microsoft Excel 2016 Inside And Out.
Learn Microsoft Excel 2016 Inside and Out
Includes 16 hours of high-quality training by your professional trainer
Practice along using exercise files
Watch and learn with demo project files
Progresses logically from beginning with an easy intro to advanced topics
This course includes:
16 hours of video tutorials
Over 100 individual video lectures
Exercise files to practice what you learned
Demo files used by the trainer
Close captions to follow along
Certificate of completion
Contents and Overview
This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user.
It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them.
You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.
Upon completion of this course you will know the essentials of Microsoft Excel 2016.
Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets.
You'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars.
Upon completion of this course you will know the essentials of Microsoft Excel 2016.
Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course.
* Includes quizzes, exercise files, demo files, close captions and certificate of completion.
Here’s what our students are saying…
“A comprehensive and well structured course, and the examples and explanations are clearly presented; and the instructor is very engaging, easy to listen to and even entertaining (which is always a plus for keeping ones interest).”
– Arnold Schwartz
I love it! He takes the time to explain how and why the operation is performed, gives you examples, and allows your brain time to absorb.
– Barbie E. Deen
“Extremely detailed and user friendly! I knew more than I thought I did, but definitely extremely useful information as I try to increase my skillset in Excel for future career options! Thank you for being so detailed.”
– Michelle McGinnis
Did you know?
Simon Sez IT teaches all sorts of software, including:
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Word
- Microsoft Project
- Microsoft Outlook
- QuickBooks
- Photoshop Elements
- Web Development Languages
- And so much more!
Course Content
- 44 section(s)
- 118 lecture(s)
- Section 1 Introduction
- Section 2 What's New
- Section 3 Using Touch
- Section 4 Getting Started
- Section 5 Using Help
- Section 6 Excel Options
- Section 7 The Ribbon and Toolbars
- Section 8 Entering and Editing Data
- Section 9 Backup and Recovery
- Section 10 Fill and Series
- Section 11 Viewing and Printing
- Section 12 Cut, Copy, and Paste
- Section 13 Formatting a Worksheet
- Section 14 Formulas and Functions
- Section 15 Managing Worksheets
- Section 16 Working with Multiple Workbooks
- Section 17 Saving Workbooks
- Section 18 Proofing
- Section 19 Inserting Comments
- Section 20 Basic Functions in Excel
- Section 21 Graphs and Charts
- Section 22 Sorting and Filtering Data
- Section 23 Shapes and Pictures
- Section 24 Formatting Cells Based on Content
- Section 25 Protection and Security
- Section 26 Naming Items
- Section 27 Finding and Replacing Words
- Section 28 Borders
- Section 29 Workbook Inspection
- Section 30 Privacy Options
- Section 31 Sharing Options
- Section 32 Microsoft Excel 2016 Intermediate - Functions
- Section 33 Date and Time Functions
- Section 34 Text Functions
- Section 35 Logical Functions
- Section 36 Lookup Functions
- Section 37 Financial Functions
- Section 38 Statistical Functions
- Section 39 Connecting to External Data
- Section 40 Tables
- Section 41 Pivot Tables
- Section 42 Extras
- Section 43 Congratulations!
- Section 44 Additional Training
What You’ll Learn
- Discover new and improved features in Excel 2016.
- How to effectively use Excel 2016 on a touchscreen device.
- How create, save, and open a workbook.
- Learn how to personalize your use of Excel using Excel Options.
- How to use and how to customize the Quick Access Toolbar.
- Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
- The basics of entering and editing data in a workbook.
- Discover how to format dates and numbers.
- Learn practical methods in which you can backup and recover your Excel spreadsheets.
- Effectively use autofill and flashfill so you are more productive.
- Discover the essentials of using fomulas and functions.
- How to rename, insert, move, and reference an Excel 2016 worksheet.
- Discover how to create charts and graphs
- Learn practical methods to sort and filter your data
- How to protect and secure your Excel data
- Working with dates and times
- Averages, percentiles, and LINEST functions
- Calculating depreciation
- Using financial functions to determine payments
- Sparklines and data bars
- How to import and export data to and from Excel
- Create and effectively use pivot tables
- How to use Excel for data analysis
- Discover practical methods for financial & statistical Functions
- Practice what you learned with included exercise files
Skills covered in this course
Reviews
-
LLorraine Consoliver
It was a good match and the amount of material and increasing difficulty was great. I thought the section that was the most difficult - nested, look-up functions, using logic functions could have used more time, but other than that, I was very pleased with this.
-
TTracey
Yes, but feel like the functions and formulas could be explained in a more basic or slower way
-
CCarey Winter
I truly enjoyed this course. Toby is an amazing instructor that demonstrates and explains the use of Excel functions step-by-step! Exercises are also provided to get more practice! Well worth the time and money spent!
-
WWanda Driggers
I am not very computer savvy. Now I do feel better equipped to work with Excel though I realize that I will never use some of the sections. All in all, this was very easy to follow and grasp the information needed for future Excel use in my work. Toby spoke clearly and was easy to listen to. I would recommend it to others. Though I enjoyed the course, I am upset that I am unable to get my certificate. I did not want to order any of the items listed in the 2 bonus sections after completing the course and therefore it shows I only completed 141 of 143 sections and I cannot get my certificate. That brings my very positive rating down. I did order a different course and hope I do not run into this same issue. If so, I will never use Udemy again.
