Excel 2016 Course - 11 tips for Excel Beginners

Excel 2016 tutorial on Excel topics to work better and quicker. Feb 2016 updated.
4.1 (116 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.
5,670 students enrolled
Free
Start Learning Now
  • Lectures 17
  • Length 1 hour
  • 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

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 10/2015 English

Course Description

*Updated 19th February 2016*

This Excel 2016 Essentials course is designed to help you in your Excel tasks- no matter what they are!

A lot of people use Excel. While some jobs require heavy use of Excel and its features, some professions just require you to know the 'basics' or 'essentials' as we call it!

This basic Excel 2016 course is suitable for beginners to intermediate users and teaches the following:

  • Excel basic worksheet operations
  • How to navigate around an Excel workbook
  • How to format cells quickly in an Excel workbook
  • How to sort, find and replace Excel data quickly
  • How to insert, edit and delete Excel comments and automatically resize them
  • How to resize Excel columns automatically and quickly
  • How to copy data tables from MS Excel into MS Word
  • How to wrap text in MS Excel
  • How to print pages properly in MS Excel
  • How to quickly make/format a table in MS Excel


This is not an advanced course so please bear that in mind before considering enrolling. What this course is though is a basic bite size course - In 1 hour you can pick up everything taught. How great is that? The lectures have been kept as simple as possible yet illustrate effectively how to use the taught concept.

As with all courses by Mach 42 Productions, full support is given via the course discussion forums. This course is filmed using the latest copy of Excel 2016 and is in HD quality. The great thing about this course is that you can apply what is taught to ANY of your daily work tasks in Excel regardless of the industry. How cool is that? Simple and short quizzes are also provided to test user knowledge after selected lectures.

Apart from users wanting to know just the essentials, this course is great for anyone using Excel who just wants a refresher on concepts used in it. 

Remember by picking up essential Excel skills, you can significantly increase your productivity, save time and money and furthermore be confident that you can use one of the most popular office business tools today. This Excel course aims to help you get there- and quickly too!

Go on..what are you waiting for?

What are the requirements?

  • A copy of Excel 2010+
  • A willingness to learn
  • A PC

What am I going to get from this course?

  • Students will be able to sort, find and replace data in Excel quickly
  • Students will be able to navigate a spreadsheet without losing the context of their data
  • Students will be able to quickly format cells
  • Students will be able to insert, edit and delete comments successfully

What is the target audience?

  • Students who just want the 'essentials' to use Excel to help them get through their daily work
  • Analysts wanting a refresher in basic techniques
  • Students studying at college/university who are required to use Excel in their coursework/assignments
  • Do not take this course if you are an advanced user of Excel

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 course!
02:19

This lecture introduces the course, its aim and best ways to learn!

Introduce yourself!
Article
1 page

Microsoft Excel has loads of keyboard shortcuts. This lecture lists a couple of handy Excel shortcuts which you will actually use in everyday Excel tasks.

Section 2: Excel worksheet operations- the basics
10:03

This Excel lecture covers the basics of Excel worksheets. In ten minutes you will learn:

  • How to add an Excel worksheet
  • How to delete an Excel worksheet
  • How to rename an Excel worksheet
  • How to move or copy an Excel worksheet
  • How to change the colour tab of an Excel worksheet
  • How to hide/unhide an Excel worksheet

  • Note for this Excel lecture, the accompanying workbook only has one tab which is the summary sheet used in the lecture. There are no 'before'/'after' tabs. Cheers.

    Section 3: Applying a format quickly to other cells
    06:16

    This lecture will show you how to use the Format Painter option to quickly apply formatting to Excel cells- saving you lots of time!

    2 questions

    Quiz on Format Painter

    Section 4: How to navigate a workbook
    01:58

    This lecture will show you how to use Freeze Panes in Microsoft Excel. This is a great way of making scrolling around a spreadsheet really easy!

    04:40

    This lecture continues the topic of Freeze Panes. In this lecture more uses of this option are covered!

    Section 5: How to insert a comment in Excel
    04:31

    Lecture hows you the basics of Excel comments- how to add, delete, automatic resize, cycle through and how to show all comments and hide them all. Excel comments are really good for leaving notes both for yourself and another user of the Excel worksheet.

    2 questions
    Quiz on Comments in Excel
    Section 6: Sorting and finding/replacing data in Excel
    07:59

    This lecture will show you how to quickly sort data in Excel. Sorting data is one of the most frequent tasks in Excel and is one of the core things you need to know! This lecture teaches you the most popular way to sort data.

    03:19

    This lecture uses the same table from the previous lecture to correct a mistake made in the data- and in the process show you how to find/replace data quickly in Excel.

    2 questions
    Quiz on sorting/finding and replacing data
    Section 7: Resizing columns quickly
    04:48

    Ever had an Excel table with columns that are overlapping with each other? Annoying right? Well this lecture shows you how to quickly resize all columns to the perfect size. This will make your data tables and reports much more easier to read.

    Section 8: How to copy a table from MS Excel into MS Word
    06:21

    This lecture covers how to copy a table from MS Excel to MS Word. This lecture also covers the most common ways tables are copied into MS Word.

    Section 9: Wrapping text in Excel
    06:10

    This Excel lecture will teach you the common task of wrapping text in Excel. This will make your spreadsheets look cleaner, neater and more readable.

    Section 10: How to print pages in Excel properly
    03:42

    This lecture will show you how to print pages correctly in MS Excel and avoid the 'dreaded cut off to the next page' syndrome that often happens.

    Section 11: How to quickly make/format a table in MS Excel
    07:06

    One of the most common tasks you can do in Excel is to make a table and format it. Well this lecture will show you how to do this quickly (in less than 10 minutes).

    Section 12: The end!
    00:33

    This quick lecture wraps up the Excel course

    Article

    Bonus lecture for our course

    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?
    Start Learning Now