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:
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?
This lecture introduces the course, its aim and best ways to learn!
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.
This Excel lecture covers the basics of Excel worksheets. In ten minutes you will learn:
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.
This lecture will show you how to use the Format Painter option to quickly apply formatting to Excel cells- saving you lots of time!
Quiz on Format Painter
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!
This lecture continues the topic of Freeze Panes. In this lecture more uses of this option are covered!
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.
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.
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.
This Excel lecture quickly shows you how to replace words for only a specific or selected group of columns
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.
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.
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.
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.
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 17,200 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.