Library

Course: MS Excel Crash Course

MS Excel Crash Course

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

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 this course is for:

  • 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
Basic knowledge
  • Students must have a copy of Excel 2016, 2013, 2010 or 2007 in order to benefit from this course
What you will learn
  • Learn and use time-saving techniques, basic formulas, and produce a chart, plus move through a spreadsheet lightening fast
Curriculum
Number of Lectures: 11
Total Duration: 00:39:47
Greeting from the Instructor
  • Introduction  

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

MS Excel Crash Course
  • The Quick Access Bar  

    Set up your Excel window to be fully functional.

  • Mouse Cursors  

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

  • Screen Elements  

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

  • Calculations  

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

  • Calculations 2.0  

    Learn the AutoSum super secrets with level 2 of Calculations.

  • Formatting  

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

  • The Control Key  

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

  • Charts  

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

  • Name Box  

    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.

Conclusion
  • Thank you for your time and Keep Learning!!  

    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.

Reviews (1)
3 months before
Excellent teacher, I know advanced excel and learned some things I didn't know, Thanks Andy!