Excel 2016, The Key Ingredients
4.9 (253 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,946 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016, The Key Ingredients to your Wishlist.

Add to Wishlist

Excel 2016, The Key Ingredients

Get started fast or brush up on Excel 2016 with these 8 Excel tips that power users have known for years!
4.9 (253 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,946 students enrolled
Created by Andy Lanning
Last updated 5/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 39 mins on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn and use time-saving techniques, basic formulas, and produce a chart, plus move through a spreadsheet lightening fast
View Curriculum
Requirements
  • Students must have a copy of Excel 2016, 2013, 2010 or 2007 in order to benefit from this course.
Description

The best "Must-Know" tips to get you started or brush up your skills in Microsoft Excel 2016. These 8 short videos will launch you into Excel and get you going in just over 30 minutes.  Whatever your level, beginner, long time user, or advanced, you will learn a few good nuggets of information that will absolutely improve your productivity. Along with the videos are matching PDF materials to reinforce the lessons.  The course includes calculations, charts, and formatting, as well as setting up the Excel window to be useful and helpful. Become a better Excel user and finally be the Boss of Excel!

Who is the target audience?
  • All levels of users will benefit. If you are self-taught (as most of us are) you will learn some excellent time-savings tips in this course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Hello from your Instructor
1 Lecture 01:04

Welcome to Excel 2016 Crash Course and buckle-up to learn!

Preview 01:04
+
MS Excel 2016 Crash Course
9 Lectures 37:01

Set up your Excel window to be fully functional.

Preview 04:01

There are multiple mouse cursors that do different jobs. This video reviews them so you won't be confused.

Preview 03:47

Take a tour of the screen elements and discover the hidden treasures tucked into the sidewalls of the Excel window.

Preview 04:11

Calculating numbers is the purpose of using Excel. Learn to add, subtract, multiply, divide and average in this lesson.

Calculations
04:24

Learn the AutoSum super secrets with level 2 of Calculations

Calculations 2.0
03:53

Every good spreadsheet has formatted text and professional looking numbers. Learn some good tips in this lesson.

Formatting
04:22

The Control Key has super strength if you know how and why to use it. This lesson is key to learning Excel productivity.

The Control Key
04:35

Charts create a picture of your numbers. Learn the 2-step chart and how to format it to look great!

Charts
03:49

The Name Box is the best kept secret in Excel. This single tip will change how you use Excel forever and you will happily "skip through" your spreadsheets.

Name Box
03:59
+
Conclusion
1 Lecture 00:42

So glad you finished the course and hope you learned some great new tools. Please continue to right-click and read those lists!  You will become a master at all software with that one tip alone.  Andy L.

Thank you for your time and Keep Learning!!
00:42
About the Instructor
Andy Lanning
4.9 Average rating
577 Reviews
9,192 Students
5 Courses
Instructor

Andy Lanning, Owner/Trainer
Computer Software Training, LLC

Maybe you are entering the workforce; maybe you are RE-entering the workforce; or - maybe the Work Force has forced you to re-evaluate your skills...

Andy is a self-taught computer “nerd” and has been training individuals and groups since 1996.  She is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 20+ years experience in the computer industry, Andy focuses every class on using software to solve common workflow issues.

Be prepared to learn more than you bargained for in her class. Andy always teaches the 4 Super Secrets to computers and believes firmly in efficiency training.

“My goal is to lower frustration and raise productivity.
And maybe have some laughs along the way!”

Software specialty areas include:
· Microsoft Office: Word, Excel, Outlook, PowerPoint, Publisher
· Office Processes: mail merges, forms, databases, data analysis
· Internet and E-mail
· Computer Basics