Excel 2016 - 10 Easy Steps for Beginners
0.0 (0 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.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 - 10 Easy Steps for Beginners to your Wishlist.

Add to Wishlist

Excel 2016 - 10 Easy Steps for Beginners

Learn how to create spreadsheets the EASY way - step by step guidance with Excel 2016's new features
0.0 (0 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.
1 student enrolled
Created by Gilly Dow
Last updated 4/2017
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
  • 6 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You will know how to input text easily, especially if your typing skills aren't good
  • You will know how to create simple calculations
  • You will know how use percentages in calculations
  • You will know how to create formulas
  • You will know how to format data to bring your spreadsheets to life
  • You will know how to use tables
  • You will know how to create charts to visualize your data quickly and easily
  • You will know how to print with confidence
View Curriculum
  • Students need to be excited about learning a new skill that is highly sought after
  • No previous experience of Excel is necessary, I'm going to teach you all you need to know to get you started with confidence
  • A computer with Excel 2016 installed - Excel 2013 will have most features but not all

This online Excel course will teach you how to create amazing spreadsheets and charts whether you have used Excel before and just want a refresher or you are totally new to it and are scared the world will end if you press the wrong button!

While there are plenty of Excel courses that will teach you Excel, it’s really hard to find one that doesn’t jump around with different data examples and can cause confusion when you’re just starting out.

This course, centres around a fictitious company called AdventureWorks and you start at the beginning and work through to the end with the same data set, building your knowledge, understanding and confidence as the company introduces new stock and suppliers.

You will learn how to create calculations to see how the company profits are doing in the easiest of easy ways – you don’t need to be an accountant to work this out – it’s easy!

You will generate reports both manually and automatically using Excel feature-rific tools – which are AMAZING – such as the Quick Analysis Tool and Flash Fill

On the strength of your report creation skills, you will present these reports visually in Charts and edit them just like the boss likes them!

Here’s just a few things you’ll learn:

  • AutoFit
  • AutoComplete
  • Auto Fill
  • Amending spreadsheets
  • Simple calculations
  • Working with percentages
  • Formatting data
  • Cell addressing
  • Flash Fill
  • Working with tables
  • Sorting & Filtering
  • Creating charts
  • Printing

Improve Your Career Prospects, Acquire More Skills, Make More Money

This course will provide you with a solid foundation to hone your skills that will take you to the next level. You will feel confident and chomping at the bit to improve – Excel does that. It grabs hold of you and each new skill you acquire drives you further and further.

Excel is packed with endless possibilities and my aim is to open the door for you to explore. Your earning potential will increase as your skills develop – you’ll get noticed and with that recognition comes reward! Master the basics of this amazing application and boost your income with a relevant and highly sought after skill

Don’t Put It Off Any Longer. Start Now. With Me. Today.

By the end of this course, your confidence as an Excel user will soar. You will have a thorough understanding of the fundamentals that drives Excel to be the most powerful application in the Microsoft suite of programmes.

Download the Excel 2016 - 10 Easy Steps for Beginners 70 page, screen-shot packed user guide containing all the course steps and exercises. Follow along with me in the Sales Report workbook and consolidate, embed and underpin your knowledge with practice exercises that I show the solutions to. Smash the quizzes with your understanding of Excel's tools and options.

This course will take you from scared to PREPARED – for anything that needs calculating, reporting, presenting or printing!

Who is the target audience?
  • This course is for anyone who wants to learn how to use Excel 2016 but were too afraid
  • In other words.... ALL absolute beginners who want to become a skilled Excel user
  • This course is for office workers, mums, dads, grandparents, kids ... anyone that wants to organise their schedule, bills, lists, workload properly
  • This course is for anyone who wants to improve their career prospects
  • This course is for anyone who just wants to prove to themselves they can do it!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
Introduction and Objectives
2 Lectures 21:47
Step 1
3 Lectures 22:29


Moving Data

Entering Text

Step 1 Quiz
5 questions
Step 2
4 Lectures 27:03
Inserting Rows

Inserting Columns

Find & Replace

Solution to Exercise 1- Amending a Spreadsheet

Inserting Columns & Rows

Step 2 Quiz
5 questions
Step 3
2 Lectures 22:20
Auto Fill

Solution to Exercise 2 - Auto Fill

Auto Fill

Step 3 Quiz
5 questions
Step 4
5 Lectures 50:39
Cell Addressing

Displaying Formulas

Multiple Operators & BODMAS


Solution to Exercise 3 - Simple Calculations

Simple Calculations

Step 4 Quiz
5 questions
Step 5
4 Lectures 43:11
Working with Percentages

Formatting Text

Format Painter

Solution to Exercise 4 - Percentages & Formatting

Working with Percentages

Step 5 Quiz
5 questions
Step 6
3 Lectures 29:38
Relative Cell Addressing

Absolute Cell Addressing

Solution to Exercise 5 - Absolute Cell Addressing

Step 6 Quiz
5 questions
Step 7
2 Lectures 22:51
Flash Fill

Flash Fill Fun

Flash Fill

Step 7 Quiz
3 questions
Step 8
4 Lectures 44:40
Format as Table



Working with Tables

Format As a Table

Step 8 Quiz
5 questions
Step 9
5 Lectures 43:51

Chart Tools

Chart Elements

Quick Analysis Tool

Solution to Exercise 6 - Charts & Tables


Step 9 Quiz
5 questions
2 More Sections
About the Instructor
Gilly Dow
4.9 Average rating
17 Reviews
80 Students
3 Courses
IT Training Consultant, founder gdteach.co.uk

Gilly Dow is an MS Office Master, a Certified Microsoft Excel Expert and Training Consultant with 20 years experience working for the US Military, NHS and multiple private sector companies. Gilly have trained thousands of students from IT Security, MS Office, SAP and Clinical Healthcare applications. GD Teach has been founded especially for Udemy to reach out to a wider audience and deliver practical, step-by-step, quality training that makes a difference to you and your job satisfaction.