Excel 2016 Training Course- Beginners Basics

Excel 2016 beginners tutorial - Learn Excel essentials to help you in everyday Excel work. Excel exercises included.
4.9 (7 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.
537 students enrolled
$19
$60
68% off
Take This Course
  • Lectures 50
  • Length 4.5 hours
  • Skill Level Beginner Level
  • 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 7/2015 English

Course Description

*Course updated - November 2016*

Microsoft Excel skills can boost your career. Excel is one of the power tools of the world. Every business uses it. 

In today’s economy, knowing basic digital skills like MS Excel can boost your career prospects, help you cope in an existing job and give you access to more types of jobs.

This MS Excel course is aimed at beginners and will teach you essential Excel concepts to help you in your everyday work tasks. Each section includes quizzes or activities/tasks or both to help you fully grasp concepts. As an Excel beginner here is what you will get from this Excel course:

• How to use the Excel Ribbon and Quick Access Toolbar- and customise them to suit you

• How to add, delete, rename, copy and move Excel worksheets

• How to cut/copy and paste data - including the many options Excel gives you

• How to use basic maths operators in Excel

• Gain a good understanding of how to write basic math formulas using these basic maths operators

• Understand the difference between absolute and fixed references

• Understand the significance of brackets in Excel formulas

• How to fully format text and understand the many options Excel provides

• How to make an Excel table in under 10 minutes and customise it

• How to make an Excel bar chart in under 10 minutes and customise it

• How to use conditional formatting to customise your Excel work

Remember this Excel course is backed by a 30 day money back guarantee so enroll today and I look forward to seeing you on the other side:)


What are the requirements?

  • Excel 2013 or Excel 2016
  • Have a working basic knowledge of Excel e.g. open, close workbook
  • Be able to enter data into Excel using the keyboard

What am I going to get from this course?

  • Be confident in using the basics of MS Excel to help you in your Excel work
  • Be able to understand the Excel ribbon/QAT and customise them
  • Be able to customise your text to your liking
  • Be able to generate tables, bar charts quickly
  • Be able to use conditional formatting in your reports
  • Be able to sort data in Excel using one or more rules

What is the target audience?

  • Those users who want to grasp the basics of Excel
  • Those who are prepared to be pro-active and watch the lectures, make notes and do the quizzes/tasks

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.

Curriculum

Section 1: Introduction to this course
03:42

This lecture overviews the course and the benefits you will get from this.

Udemy course completion certificate for LinkedIn
Preview
Article
Article

This lecture covers how to take screenshots of your Excel work. Note, when posting please ensure nothing sensitive or confidential is included- only the workbook area is needed.

Section 2: The Excel Menu/Ribbon
12:14

This Excel lecture introduces the Excel menu structure commonly known as the 'Excel Ribbon'. We overview the various commands of each tab.

13:22

This Excel lecture overviews the Quick Access Toolbar. We also cover how to customise this toolbar and also how to create your own Ribbon of personal frequent commands. This lecture will be useful once the course is completed since you will by then have a list of favourite Excel items you always want available.

01:01

This lecture overviews your Excel task for this section.

Section 3: Worksheet basics
00:53

This Excel lecture quickly overviews the menu we will be using for the rest of this section...

06:00

This Excel lecture introduces the section and shows you how to add and delete Excel worksheets.

02:21

This Excel lecture shows you how to rename an Excel worksheet and also the limitations in terms of the length and symbols you can include in your worksheet tab name.

06:14

This Excel lecture shows you how to move and copy Excel worksheets.

02:44

This lecture shows you how to change the colour tab of an Excel worksheet.

03:29

This lecture shows you how to hide and unhide Excel worksheets.

00:44

This lecture presents your Excel tasks for this section.

Section 4: Maths operations for beginners
02:00

This Excel lecture shows you how to use the multiply operator in Excel to perform calculations.

2 questions

Quiz on multiplicaton in Excel

05:29

This Excel lecture shows you how to add in Microsoft Excel using two ways, the + symbol and the sum() function.

2 questions

Tests knowledge on adding in Excel

02:07

This lecture shows you how to subtract in Excel.

2 questions

Quiz to test subtraction in Excel

02:03

This lecture shows you how to use the divide symbol in Excel

1 question

Excel division quiz

Section 5: Formula tips for beginners
04:55

Explains a key rule to success in Microsoft Excel

6 questions

Tests knowledge on brackets Excel lecture

10:03

This lecture explains cell references in Excel and how to use them.

01:48

Quick lecture on using a shortcut key to edit references. This one will supercharge your productivity!

4 questions

Tests references knowledge in Excel

02:39

This lecture shows you a quick way to increase your productivity when typing formulas:). One additional note- the use of the key called 'F-lock' - found on your keyboard is needed. Practically all keyboards have this key. This 'F-lock' key is also known as the 'Fn' key or 'Function' key. Depending on your computer brand, any one of these names is used- but they all do the same thing..which is enable the use of the 'F' keys on your keyboard.

Article

This lecture quickly shows you how the F-lock key looks like on a typical keyboard. Note- the F-lock key is also known as the 'Fn' key or 'Function' key.

Section 6: Text Formatting in Excel
16:56

In this lecture we cover: 

1. How to change Excel fonts

2. How to change Excel font sizes

3. How to add Excel borders

4. How to change the colour of text in MS Excel

5. How to change the background fill colour of a cell in an Excel spreadsheet

15:13

This Excel lecture covers how to align text, change the direction of text, how to wrap text and how to merge cells. This lecture is great for learning how to customise worksheets and make them clean and easy to read.

Section 7: Tables and Excel filtering- the basics
09:07

This lecture covers how to make an Excel table quickly. Here you will overview 2 ways a table can be made.

19:23

This lecture is long one but you will cover how to use Excel commands to filter data on tables, remove duplicate Excel data from tables and how to revert a table back to its standard Excel form. We also overview a common mistake made when removing duplicate Excel data- and how to avoid it!

01:23

This lecture overviews your Excel tasks for tables.

Section 8: Sorting data
08:20

This Excel lecture overviews sorting in Excel and starts off the section by showing you how to sort by text in Excel.

02:35

This lecture shows you how to sort by numbers in Excel.

02:38

This Excel lecture shows you how to sort by colour. This is really handy since most reports contain coloured cells (often highlighting rows of data). Knowing how to sort this data by colour will make you super productive and save you time when sorting data in your everyday Excel work.

01:43

This lecture takes a twist from the previous lecture and shows you how to sort by the colour of your Excel font.

08:29

This lecture introduces you to sorting by more than one Excel rule.

00:56

This Excel lecture concludes the learning aspects of this section.

00:45

This Excel lecture presents your sorting tasks for this section.

Section 9: Charts- the basics
06:43

This lecture overviews the anatomy of a chart and explains the various elements that go into making an Excel bar chart.

10:26

This lecture covers how to actually make an Excel bar chart.

09:54

This Excel lecture covers how to adjust the elements of a bar chart (basically the formatting options for one).

11:21

This Excel lecture shows you the different ways or styles you can present your Excel bar chart. 

03:40

This Excel lecture demonstrates how to get the style of one of the previous lecture's chart presentation examples.

00:26

This Excel lecture overviews your Excel tasks for charts.

Section 10: How to use copy, cut and paste features in Excel
02:59

This lecture overviews the section and introduces copying, cutting and pasting data. Some of these elements may have been indirectly touched on in other sections of the course but here officially introduce you to the concepts and the handy benefits of this. Since this is a critical concept we also provide some further worked examples since we really want you to grasp this!

12:14

This lecture covers all the popular uses of copying/cutting and pasting data in Excel. After this lecture, you will be able to appreciate the uses these tools provide.

11:11

This lecture provides more worked examples of using copy/cut and paste.

00:48

This lecture covers your Excel tasks for this section.

Section 11: Conditional Formatting
15:04

In this lecture, we use several examples to introduce the student to conditional formatting. This is a lengthy but deep lecture covering the basics of conditional formatting. The good news is by the end of the section you will begin to appreciate just how powerful conditional formatting is for use in your Excel reports. As always we use great examples to help you fully grasp these concepts.

16:03

This lecture resumes our use of worked examples to illustrate how Excel conditional formatting works. Here we cover areas such as colour scales, data bars and icon sets (don't worry if these seem vague or not known to you..by the end of the lecture you will be familiar with these terms!). Also please note, like the previous lecture, this is a fairly deep lecture so please make notes and rewatch if necessary. Of course we are always here to help too!

00:52

This Excel shows outlines your conditional formatting tasks. 

Section 12: Wrap up section
Excel keyboard shortcut list
Article
00:47

This lecture wraps up the course and summarises what has been learnt.

Bonus lecture- Discounts to our other Excel courses
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mach 42 Productions, Excel Tutoring/Consulting Services

Our Udemy Excel courses have been developed to cover a wide range of needs for the Excel user. There is a course to suit everyone from beginners level to advanced. We provide all workbooks and full support via the discussion forums. Simply put our Excel courses use real life examples and not just theory to help you learn and improve yourself and give you proper skills you can use in your workplace.

Our Excel IT Consultant/Instructor Navin has been in the IT industry for approximately ten years. Recently featured nationwide in Costco Magazine, Navin has over 6 years experience as an Analyst. Having self-taught himself Microsoft Excel and VBA, he achieved MCAS (now known as Microsoft Office Specialist) certification in Excel in 2010. His work in Excel has been varied having worked on automating and streamlining reports to building and deploying real time dashboards to monitor performance.

During his time as an Analyst, he often assisted colleagues who needed problems solved in Excel. By relating the functions to use, to the context of their problem, his colleagues were able to grasp the concepts of what functions to use and in what context.

This spurned Navin's need to develop these range of Excel courses which to date have over 8500 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.

Ready to start learning?
Take This Course