Excel Course- Learn Excel Skills And Advance Your Career
5.0 (20 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.
3,271 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Course- Learn Excel Skills And Advance Your Career to your Wishlist.

Add to Wishlist

Excel Course- Learn Excel Skills And Advance Your Career

Excel tutorial course. November 2016 last updated. Excel CV/Resume advice given.
5.0 (20 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.
3,271 students enrolled
Last updated 11/2016
English
Current price: $10 Original price: $150 Discount: 93% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 5 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Gain more confidence using Excel to help you at work and increase productivity!
  • Learn how to use several data analysis tools and decipher formulas/fix errors on sheets
  • Automate reports that use tables and text summaries
  • Clean up data using a combination of Excel functions
  • Structure text on reports neatly
  • Enhanced job skills
  • Write Excel skills on CV/Resume in a better way
  • Free one hour 1-2-1 consultation for your Excel CV/Resume examples on completion of at least 90% of the course
View Curriculum
Requirements
  • Windows users: Excel 2010+ is required
  • A passion for wanting to learn
Description

*Course updated November 2016- Excel careers section new material added*

What can learning Excel do for you? Here are some of the jobs which use Excel as a main tool along with the average salary (figures as of 6th March 2015):

• Sales and Marketing Manager: $47,514

• Office Manager: $31,979

• Financial Analyst: $49,933

• Management Consultant: $72,683

Great right? Want even better news?

This Excel course will help you get there. This Udemy Excel course will teach you Excel skills that will help you get these types of roles PLUS give you substantial advice on how to write Excel examples of work you have done, on your resume. A free one hour personal consultation over Google Hangouts is also given with me to help you do this and get that dream Excel job.

You will learn amazing Excel techniques to save time, be more productive and get noticed. All workbooks are provided and case studies are used to teach concepts. Regarding support, as with all our Udemy Excel courses made by us (Mach 42 Productions), full support is given on the material via the discussion forums.

Remember also, if you don't like this course for whatever reason within 30 days, you are entitled to a full refund. So take this course and I look forward to seeing you on the other side.

Who is the target audience?
  • This course is aimed at beginners to intermediate level. It assumes a working basic knowledge of Excel.
  • The course is also suitable for junior level data and business analysts.
  • This course is also suitable for both under graduate and post graduates who want to enhance their job skills in a competitive market.
  • This course is also useful for those learning VBA separately and want to know more about front end Excel functions. Note this course does not teach any actual VBA.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 25 Lectures Collapse All 25 Lectures 02:36:24
+
Welcome- Introductory Section!
4 Lectures 04:56

This Excel lecture covers what the course is about, its aims and how it will benefit you!

Preview 03:43


This lecture gives some tips and recommended strategy on how to get the most out of this course!

Please read this! Tips on how to get the best out of this Excel course
01:13

There are tons of Excel shortcuts but in reality you will only ever use a handful. Attached is my list which I use 99.9% of the time. These shortcuts can be used in practically any Excel scenario regardless of the workbook or skill level of the user.

Small list of Excel shortcuts
1 page
+
Report skills part 1- How to do bullet points and new lines in the same cell
1 Lecture 06:03

Have a report summary to write? Need to do a point by point text write up? This lecture shows you how to do bullet points in Excel and new lines (carriage space)...so you can write clean summary lines and neat paragraphs in one cell. This can make your reports look much more clean and well presented.

This video is also filmed with the keyboard in view so you can see the key presses and order I am doing them in to get the required effect. Features covered: Bullet points and new line/carriage space.

How to structure Excel reports!
06:03
+
Report skills part 2- How to capitalise/de-capitalise your text- quickly
2 Lectures 09:02

This lecture will cover a really cool way of quickly capitalising or de-capitalising words. This is super handy for converting text from one type to another. Some data systems also output text entries in capitals so having a way to quickly convert it to lowercase lettering will make reading the text much more readable. Functions covered: Upper() and lower().

To Capital or not Capital? That is the question:)
03:20

This lecture will show you a quick way of capitalising the first letter of each word. This is super handy for making quick header titles for presentations where time is often essential to complete the deadline. Functions covered: Proper().

Making teXt...Proper
05:42

Report basics part 2 quiz!
3 questions
+
Cleaning Excel data- How to substitute characters in text
1 Lecture 17:46

This lecture sets about showing you how to clean data by way of removing unwanted characters and replacing them. Using a simple case study we demonstrate the use of the function substitute() along with several other functions which will enable you to successfully do this. This is a great way of cleansing data before you go on to further manipulate it. Features covered: Substitute(), find(), iserror(), if statements and trim().

Substitute and more!
17:46

Cleaning data quiz!
6 questions
+
Automating reports- How to join formulas and text
1 Lecture 11:55

This lecture will look at a really great way to insert formulas directly into your text. The benefits of this will allow you to have standard sentences in your report which will update on their own when you refresh your data tables. This will save you lots of time if you have reports that need to be updated frequently for tasks like weekly or monthly summaries. This also makes a life a lot easier if you have the same tables being quoted in different sheets, since being formulas they will all update automatically. Features covered: The '&' symbol pronounced 'ampersand', sum(), index(), match() and max(). Note the last four are used in the example with a verbal explanation given.

One symbol to rule them all:) & !
11:55

Automating reports quiz!
2 questions
+
How to calculate working days
2 Lectures 12:47

This lecture asks and solves the question of working out the difference between two dates for just the working days. This lecture also covers how to take into account public holidays. This is very useful for working out days worked, annual leave planning, response times. Functions covered: Networkdays().

Preview 05:32

This lecture discusses how to add working days to a specified date. How to factor public holidays and have them excluded is also shown. This is very useful for working out project due dates and response times. Functions covered: Workday().

Adding workings days to a date!
07:15

Working days quiz!
3 questions
+
Data skills 1- How to figure out formulas and fix errors
1 Lecture 13:31

Ever been given a spreadsheet with formulas that you have no clue how they work? Or why they are there? Or if a particular cell is even used in the sheet (yes we have all been there!)? Well this lecture is for you!

In this video we cover tools which will enable you to trace the cells that a formula uses both from the point of view of either the formula itself or whether a selected cell is actually used by any other formula on the sheet. You will be able to 'see' this via the tools. Knowing how a sheet works will saves your hours of time trying to figure it out and will enable you to work faster and better!

Audit that formula!
13:31

Data basics 1 quiz!
3 questions
+
Data skills 2- How to sum a range of values based on one or more criteria
1 Lecture 09:36

This lecture will explore Excel functions which enable you to sum a range of values based on one or more criteria. This is great for when you have a data table and wish to sum up specific values that match what you are looking for. The case study will also show you different ways to use these functions. Functions covered: Sumif(), sumifs() and sum().

Sum this, sum that!
09:36

Data basics 2 quiz!
2 questions
+
Data skills 3- How to retrieve a value based on a lookup of another value
4 Lectures 18:13

This lecture teaches one of the most amazing tools ever in Excel- vlookup! Basically this enables you to look up a chosen value vertically (up/down) in a column of a table and return a value in a corresponding right hand side column. This formula is amazing in that you can quickly obtain values in scenarios such as retrieving a list of addresses in one column based on specific list of customer names for example. The uses for this function are almost limitless and it is a great way of cleaning data and obtaining a subset of it based only on the values you need for analysis.

This function also is great for alerting the user for when errors creep up in the data by enabling you to specify meaningful error messages if no matches are found for what you are looking for. Features covered: Vlookup(), iserror(), if statements, sumif().

One more thing folks. In terms of having the data table sorted in ascending order (by lookup value), this is essential for when you are using vlookup() to do approximate matches. For exact matches, it is not needed. However to give you the flexibility of doing both types of matches and instilling good Excel practice, we encourage you to sort the data in the table in ascending order by lookup value. As your Excel skills grow and you become more confident in knowing exactly what type of match you are going to perform, then you can adjust the data accordingly (for approximate matches) or leave it as it is (for exact matches).

Lookup this!
13:59

This lecture shows a simple diagram to help you understand a critical concept of vlookup() which you must grasp in order to use this effectively (its really easy though).

A vlookup() key concept that every Excel user must know
2 pages

A quick note about vlookup() and whether to sort columns or not.

Vlookup() and column sorting
00:48

Data basics 3 quiz!
2 questions

This Excel lecture basically shows the demand for learning vlookup() is well, pretty big! Published in February 2016, you can see how vlookup() is required for jobs and cuts across different careers. This is good news for students taking this course because, we have geared this course and the topics in it to exactly give you this 'edge' you need to succeed in today's world.

Preview 03:26
+
Data skills 4: Printing Excel documents properly
1 Lecture 07:47

This Excel lecture covers several printing options which you should use if printing out your spreadsheets.


By the end of this lecture you will be able to:

  • Print pages properly (with no left over or cut-off pages) to cleanly present to your end user/audience
  • Add page footers to clearly indicate which page the end user is reading
  • Print out Excel comments
  • Add gridlines, row numbers and column letteres to a printout
  • Decide how to display error messages on your spreadsheet when printing out

  • Formatting Excel spreadsheets for printing
    07:47

    Quiz on formatting MS Excel sheets for printing

    Quiz on formatting MS Excel sheets for printing
    2 questions
    3 More Sections
    About the Instructor
    Mach 42 Productions
    4.5 Average rating
    453 Reviews
    14,695 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.