Learn Microsoft Excel 2016 in 1 Hour (+12 Excel Templates)

Master Microsoft Excel 2016 in 1 hour, elite step-by-step formula transforming beginners into Experts in Excel.
4.2 (21 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,752 students enrolled
88% off
Take This Course
  • Lectures 73
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

>> Special Price ONLY - Increasing To $190 Soon <<

>> Updated for February 2017 <<

How great would it be if you could learn Microsoft Excel in just 1 hour? Well that is now possible. You will be transformed from a beginner to an expert in Excel in just 1 hour, following 4 easy and simple steps.

Why should you take this course?

"I found this course very helpful. I have been struggling for 2 weeks trying to figure out Excel myself, trying to learn how to move around menu board only to get more and more frustrated. This course has been a blessing, no more frustration no more high blood pressure from stress. Excellent presentation and easy to understand." - Sandra Lee (student)

We Have trained 1000s of beginners Excel, where they have immediately been able to apply what they have learnt within this course.

Here we welcome you to the Learn Microsoft Excel 2016 in 1 hour course, where you will learn how to use Excel in real life scenarios based on a variety of case studies.

"I wanted a course that gets straight to point and I got it. The instructor's delivery is very good and provides good explanations on how different parts of excel work. Didn't think I could get through so much in just 1 hour. Nice and concise course." - Emma Morgan (student)

Guarantee: By the end of this course you will be able to use Excel in real life scenarios within just 1 hour.

Excel can be used for…

  • Scheduling
  • Pay roll systems
  • Weekly planners
  • Invoices
  • Bookkeeping
  • Budget keeping
  • Sorting and listing data
  • Employee and customer data
  • Almost anything that uses and requires data

And the best part is you can even use it at…

  • Work
  • Home
  • An educational establishment
  • Or just for fun - the possibilities are unlimited!

In our Learn Microsoft Excel 2016 in 1 Hour course we will give you the blueprint for getting the most out of Excel. Even if you are completely new to Excel the simple step by step video tutorials, instructions and material will give you thorough guidance - everything you need in just 4 easy steps.

No more feeling stressed and overwhelmed, as our fully accredited Microsoft certified instructors will provide all the answers to how Excel operates; we will focus on…

  • Creating spreadsheets which will turn you into an Excel expert in less than 1 hour
  • Applying Excel to real life situations to enhance your results in your working environment
  • Implementing the correct tools that will skyrocket your productivity by at least 33%

Plus you will receive 1 additional Bonus for enrolling…

Bonus: The 4 Step Excel 2016 Functions Guide - makes using functions and formulas easy and simple.

The 30 Day Money Back Guarantee

As always, we offer our 30 day money back guarantee. Providing value is of the utmost importance to us and if you are not receiving the results you desire then we will ensure to refund you for the course.

Special Introductory Price - Rising Soon

Normally we usually charge $397, $697 and $997 for our Excel courses, but we will keep this special introductory price before increasing it, just for the Udemy community.

Enroll and Take Action

Join now and make the commitment of going through our course. It is sure to enhance your skills and level of knowledge with Excel.

We look forward to seeing you in the course and remember to check out our previews.

See you then

How To Technology

What are the requirements?

  • No previous knowledge of Excel required - This course will teach you everything you need to know to go from beginner to expert.
  • A willingness to learn Excel.
  • A working environment where you will not be disturbed.
  • A working computer which allows internet access.
  • Microsoft Excel 2016 installed and ready to use on your computer.

What am I going to get from this course?

  • Create a variation of graphs and charts which can be used in real life scenarios.
  • Manipulate data the way you want.
  • Produce captivating and stunning pivot tables to perfectly analyse and sort data.
  • Apply calculations, functions and formulas to boost productivity with spreadsheets.

Who is the target audience?

  • If you want to become a guaranteed job ready Excel expert.
  • If you want to learn Excel in the fastest way possible.
  • If you want an easy, clear and no-nonsense guide to learning Excel.
  • If you want to refresh your memory and understanding of Excel.
  • If you want to take your knowledge and skills of Excel to the next level.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Excel Introduction - Beginner to Expert in 1 Hour

1.) Brief Introduction to the Learn Excel 2016 in 1 Hour Course.
2.) Introductory Course that will turn beginners into experts with Excel.
3.) Incorporates simple 4 step formula to ensure optimal comprehension of the Course.
4.) Will learn and understand how Excel will revolutionize your productivity and overall efficiency.
5.) Full commitment required!


1.) Our exclusive Facebook community.
2.) High value content.
3.) Grow and develop as a collective.


1.) Introduction to learning Excel.
2.) 4 easy and digestible steps.
3.) Core components of Excel.
4.) Part 1 - The ribbon.
5.) Part 2 - Quick access toolbar.


1.) Learning how to use the ribbon.


1.) Understanding the quick access toolbar.


1.) To ensure you have a good comprehension of the ribbon and quick access toolbar.
2.) Take action - Practice using the ribbon and quick access toolbar.

Section 2: Step 1A: Mastering Workbooks & Worksheets

1.) Work files to download for the course.


1.) Part 1 - Working with workbooks.
2.) Part 2 - Using worksheets.


1.) How to create a new workbook within Excel.


1.) Knowing how to save a new workbook within Excel.


1.) Going over how to navigate within Excel.
2.) An overview of Excel basics such as the namebox, formula bar, cells and worksheets.


1.) How to add and remove worksheets.
2.) Renaming worksheets.


1.) How copying and moving worksheets between workbooks will save you a tremendous amount of time.


1.) How to hide and unhide worksheets.


1.) To make sure you fully understand how worksheets and workbooks function.
2.) Take action - Test out and experiment using worksheets and workbooks within Excel.

Section 3: Step 1B: Incredible Benefits Of Editing And Entering Data

1.) Part 1 - Data types: dates, numbers & text.
2.) Part 2 - Working with cells.
3.) Part 3 - Columns and rows.


1.) Using various data types within Excel.


1.) How to edit data within cells and the formula bar.


1.) Using copy, cut and paste within Excel.


1.) Gaining an understanding of drag and drop.
2.) How to drag and drop cells between worksheets.


1.) Learning how to add and delete columns and rows.


1.) Knowing how to use find and replace in the most effective manner.


1.) Going over how to adjust column widths and row heights.


1.) Going over different methods of sorting columns and rows of data.


1.) To make sure you have a good knowledge of how to enter and edit data.
2.) Take action - Experiment and test out entering and editing data.

Section 4: Step 2A: Supreme Excel Formatting Fundamentals

1.) Part 1 - Using borders.
2.) Part 2 - Cell modification.
3.) Part 3 - Cell formatting.


1.) Adding different types of borders to cells.


1.) An overview of how to merge cells together.


1.) How to wrap text in cells,
2.) Allowing multiple lines of text in cells.


1.) Transforming the appearance of worksheets with font size, color and text.


1.) Applying the date format to cells.


1.) Looking at various types of number formats.
2.) Applying number formats to cells.


1.) Going over how to create a table within Excel.
2.) Creating your own weekly planner.


1.) To Ensure that you fully comprehend how to format cells.
2.) Take action - Practice and test out your understanding of formatting within Excel.

Section 5: Step 2B: Attaining Perfection With Functions And Formulas

1.) Part 1 - Formula basics.
2.) Part 2 - Working with functions.


1.) How to effectively use addition and subtraction formulas.


1.) How to effectively use multiplication and division formulas.


1.) Knowing how to use the SUM function.


1.) Understanding the most effective method of copying formulas.


1.) The importance of absolute cell referencing.
2.) How to effectively use absolute cell referencing.


1.) Boost your work rate with using formulas across worksheets.
2.) Master how to use formulas across worksheets.


1.) Demystifying VLOOKUPS.
2.) Understanding the various methods of using VLOOKUPS.


1.) Mastering IF STATEMENTS.
2.) Understanding the various methods of using IF STATEMENTS.

2 pages

1.) Your exclusive #1 guide for Excel functions and formulas.

4 questions

Midterm quiz time. Let's put that brain to good use!


1.) To make sure you have a good understanding of functions and formulas.
2.) Take action - Experiment using various types of functions and formulas.

Section 6: Step 3A: Superb Printing & Page Setup

1.) Part 1 - Printing Essentials.
2.) Part 2 - Page layout.
3.) Part 3 - Printer setup.


1.) Going over how to add print titles to worksheets.


1.) A guide on how to print a selected area within Excel.


1.) Going over various types of paper sizes.
2.) Selecting the appropriate orientation.


1.) Learning how to use margins in order to fit more data onto a worksheet.


1.) Looking at the different methods of scaling worksheets.
2.) How to apply the correct scaling to your worksheets.


1.) Working with various methods of using headers and footers.
2.) How to use custom headers and footers.


1.) Everything you need to know about getting the most out of printing worksheets,
2.) Adjusting printer settings for optimum functioning.


1.) To make sure you fully understand print options within Excel.
2.) Take action - Practice and test out print options and settings within Excel.

Section 7: Section 7 - Step 3B: Creating Graphs & Charts With Ease

1.) Part 1 - Graphs And Charts Creation.
2.) Part 2 - Graphs And Charts Alteration.


1.) The easy way of creating graphs and charts.


1.) The even easier way of creating graphs and charts.


1.) How to effectively create pie charts.


1.) Learning how to use sparklines within Excel.


1.) To ensure you have a good grasp of graphs and charts.
2.) Take action - Produce and test out graphs and charts.

Section 8: Section 8 - Step 4A: Awesome Pivot Tables (APT)

1.) Part 1 - Pivot Table Creation.
2.) Part 2 - Pivot Table Modification.


1.) How to create outstanding pivot tables.


1.) An overview of how to analyse and sort data using pivot tables.


1.) To ensure you have a good comprehension of how pivot tables function.
2.) Take action - Experiment and test out using pivot tables.

Section 9: Section 9 - Step 4B: The Importance Of Conditional Formatting

1.) Part 1 - Utilizing Values
2.) Part 2 - Working With Rules


1.) Understanding how to change a cell's appearance based on its value.


1.) Working with duplicate values.


1.) Looking at how top and bottom rules function and operate.


1.) Learning how average rules work.


1.) How to remove conditional formatting rules.


1.) How to use data bars, color scales and icon sets.


1.) To make sure you have a good understanding of conditional formatting.
2.) Take action - Test out and experiment with conditional formatting.

Section 10: Conclusion

1.) Wrapping up all knowledge and information together for the final action step.

4 questions

Time for another quiz. Show off everything that you have learnt with this final quiz!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

How To Technology, Elite Technical Training

Wouldn't it be great if you could learn technology whilst having fun?

At How To Technology we've made that a reality. We have managed to combine learning whilst having fun, where you'll be able assimilate and put into practice everything you have learnt.

How We Make Technology Fun

Providing elite technical training for 1,000's of clients and students, we are renowned for our high quality and delivery of IT training, courses and guides. We make it our obligation to turn those who are beginners into experts.

We at How To Technology have made sure that all of our experts teach clients, using our elite step by step formula. This way all individuals being taught are gaining the most from their learning experience. This can range from students and clients learning shortcuts and tips for applications, performing practical tests or being provided with tutorial guides. Our experts also regard engagement and interactivity as a major component of the succession of teaching to our clients. With this they are always striving to train individuals to the highest degree possible.

Products & Services

*Specialize in providing step-by-step guides and tutorials focused on software and hardware. *Methods of teaching and training involve using high quality narrated tutorials, webinars, guides and videos to deliver superior training.

*Training and teaching is provisioned by Microsoft Certified and CompTIA Engineers, who are truly passionate in wanting to help others succeed.

*Flexible and bespoke training and teaching solutions to accommodate your needs.


*Fully Accredited Microsoft & CompTIA Certified Engineers

*During mid 2014 was our peak period of enhancing the skill-set of our clients, where we had achieved our highest success rate from over the last 3 years

*Internationally renowned *Delivered training and courses in more than 50 different countries

Industries & Areas

Some examples of where we have implemented our products and services:

*Business Intelligence

*Data Management

*Internet Marketing


Examples of the content provided

*Server & desktop support





Our Mission

To spread our message of "Making Technology Fun"

Ready to start learning?
Take This Course