Excel Course- Learn Excel Skills And Advance Your Career

Excel tutorial course. May 2016 last updated. Excel CV/Resume advice given.
5.0 (19 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,250 students enrolled
$150
Take This Course
  • Lectures 25
  • Contents Video: 2.5 hours
    Other: 19 mins
  • Skill Level All Levels
  • Languages English, captions
  • 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/2014 English Closed captions available

Course Description

*Course updated May 2016*

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.

What are the requirements?

  • Windows users: Excel 2010+ is required
  • A passion for wanting to learn

What am I going to get from this course?

  • 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

What 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.

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: Welcome- Introductory Section!
03:43

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

Excel Jobs Proof and the Salaries You Can Potentially Earn
Preview
1 page
Article

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

1 page

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.

Section 2: Report skills part 1- How to do bullet points and new lines in the same cell
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.

Section 3: Report skills part 2- How to capitalise/de-capitalise your text- quickly
03:20

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().

05:42

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().

Report basics part 2 quiz!
3 questions
Section 4: Cleaning Excel data- How to substitute characters in text
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().

Cleaning data quiz!
6 questions
Section 5: Automating reports- How to join formulas and text
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.

Automating reports quiz!
2 questions
Section 6: How to calculate working days
05:32

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().

07:15

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().

Working days quiz!
3 questions
Section 7: Data skills 1- How to figure out formulas and fix errors
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!

Data basics 1 quiz!
3 questions
Section 8: Data skills 2- How to sum a range of values based on one or more criteria
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().

Data basics 2 quiz!
2 questions
Section 9: Data skills 3- How to retrieve a value based on a lookup of another value
13:59

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).

2 pages

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).

Article

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

Data basics 3 quiz!
2 questions
03:26

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.

Section 10: Data skills 4: Printing Excel documents properly
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

  • 2 questions

    Quiz on formatting MS Excel sheets for printing

    Section 11: Writing MS Excel skills on your CV/Resume
    11 pages

    A lecture on how to utilise your new Excel skills from this course and existing ones and structure them on your CV/Resume to get noticed by employers!

    11:16

    This lecture overviews several job roles for which Excel is used. We go over the types of Excel skills required and provide further indepth advice on what to write on your CV/Resume. This is a fairly extensive lecture but the good news is you will get a lot out of it.

    Article

    This lecture gives your a list of power words you can use for writing Excel examples on your CV/Resume. Quite handy!

    12:26

    12 handy tips on how to optimise your Excel CV/Resume for online job filtering systems used by recruiters.


    Section 12: MS Excel skills on Linkedin
    Article

    Great way to increase your job profile after you have completed this Udemy Excel course

    Section 13: Wrap up and bonus Excel tips
    03:30

    Congratulations on completing this course! This lecture will wrap up the course and also give some bonus tips on how to tackle any worksheet!

    Bonus lecture: Discounts for 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