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
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • 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
Description

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
05:53:52
+
Introduction and Objectives
2 Lectures 21:47
+
Step 1
3 Lectures 22:29
AutoFit
07:14

AutoComplete
06:20

Moving Data
08:55

Entering Text


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

Inserting Columns
03:04

Find & Replace
09:20

Solution to Exercise 1- Amending a Spreadsheet
05:21

Inserting Columns & Rows

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

Solution to Exercise 2 - Auto Fill
06:16

Auto Fill

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

Displaying Formulas
12:07

Multiple Operators & BODMAS
12:23

AutoSum
11:26

Solution to Exercise 3 - Simple Calculations
06:28

Simple Calculations

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

Formatting Text
12:11

Format Painter
07:47

Solution to Exercise 4 - Percentages & Formatting
10:01

Working with Percentages


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

Absolute Cell Addressing
10:26

Solution to Exercise 5 - Absolute Cell Addressing
09:19

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

Flash Fill Fun
05:17

Flash Fill

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

Sorting
11:07

Filtering
10:25

Working with Tables
15:28

Format As a Table

Step 8 Quiz
5 questions
+
Step 9
5 Lectures 43:51
Charts
05:40

Chart Tools
08:07

Chart Elements
08:54

Quick Analysis Tool
13:30

Solution to Exercise 6 - Charts & Tables
07:40

Charts

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.