*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.
This Excel lecture covers what the course is about, its aims and how it will benefit you!
This lecture gives some tips and recommended strategy on how to get the most out of this course!
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.
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.
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().
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().
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().
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.
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().
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().
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!
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().
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).
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 quick note about vlookup() and whether to sort columns or not.
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.
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:
Quiz on formatting MS Excel sheets for printing
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 15,000 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.