Excel 2016 Course - Beginners Excel Tips Part 1
4.6 (348 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.
8,304 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Course - Beginners Excel Tips Part 1 to your Wishlist.

Add to Wishlist

Excel 2016 Course - Beginners Excel Tips Part 1

Excel 2016 tutorial on Excel topics to work better and quicker. Feb 2016 updated.
4.6 (348 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.
8,304 students enrolled
Last updated 4/2017
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 2 Articles
  • 15 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • A copy of Excel 2010+
  • A willingness to learn
  • A PC
Description

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
  • How to increment dates automatically in MS Excel
  • How to increment numbers automatically when typed in as part of text 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.5 hours 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?

Who is the target audience?
  • Workers who just want the 'essentials' to use Excel to help them get through their daily work
  • New staff starting at a company and needing a refresher in Excel
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 20 Lectures Collapse All 20 Lectures 01:26:29
+
Introduction to course!
3 Lectures 03:34

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

Introduction to Excel course!
02:19

Introduce yourself!
01:15

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.

Handy List of Excel Shortcuts
1 page
+
Excel worksheet operations- the basics
1 Lecture 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.

    Excel worksheet operations- the basics
    10:03
    +
    Applying a format quickly to other cells
    1 Lecture 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!

    Applying a format quickly to other cells
    06:16

    Quiz on Format Painter

    Quiz on Format Painter
    2 questions
    +
    How to navigate a workbook
    2 Lectures 06:38

    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!

    Using Freeze Panes part 1
    01:58

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

    Using Freeze Panes part 2
    04:40
    +
    How to insert a comment in Excel
    1 Lecture 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.

    Adding comments to Excel worksheets
    04:31

    Quiz on Comments in Excel
    Quiz on Comments in Excel
    2 questions
    +
    Sorting and finding/replacing data in Excel
    3 Lectures 13:24

    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.

    How to sort data in Excel
    07:59

    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.

    Finding and replacing data in Excel
    03:19

    Quiz on sorting/finding and replacing data
    Quiz on sorting/finding and replacing data
    2 questions

    This Excel lecture quickly shows you how to replace words for only a specific or selected group of columns

    Finding and replacing data for selected columns
    02:06
    +
    Resizing columns quickly
    1 Lecture 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.

    Resizing Excel columns
    04:48
    +
    How to copy a table from MS Excel into MS Word
    1 Lecture 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.

    How to copy a table from MS Excel to MS Word
    06:21
    +
    Wrapping text in Excel
    1 Lecture 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.

    How to wrap text in MS Excel
    06:10
    +
    How to print pages in Excel properly
    1 Lecture 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.

    Printing pages in Excel properly
    03:42
    4 More Sections
    About the Instructor
    Mach 42 Productions
    4.5 Average rating
    452 Reviews
    14,654 Students
    13 Courses
    Excel Consulting- 14,600+ Students

    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 14,600 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.