Excel Course- Better Excel in 2 Hours
4.8 (9 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.
404 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Course- Better Excel in 2 Hours to your Wishlist.

Add to Wishlist

Excel Course- Better Excel in 2 Hours

Microsoft Excel 2013 tips course. Work faster after taking this Excel course on Udemy.
4.8 (9 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.
404 students enrolled
Last updated 2/2016
English
English
Price: $30
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 9 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Ability to apply these tips to their Excel work regardless of the industry or topic it is in
Be able to prevent one Excel workbook from crashing another
Retrieve your protected sheets even if you have forgotten your own password
Resize Excel comments using VBA
Search in Excel by colour
Understand Excel error messages
View Curriculum
Requirements
  • Willingness to learn
  • A working knowledge of Excel is assumed
  • Excel 2013. Most topics covered are backwards compatible with earlier versions of Excel. Those topics specific for Excel 2013 are indicated in the section/lecture titles.
Description

*Updated February 2016*

Want to know how to stop one Excel workbook from crashing another Excel workbook?

Forgotten your Excel password to your worksheet? Want to know how to still access the Excel sheet and copy it out?

Want to know what those Excel error messages mean? And how to fix them?

Want to know a quick and easy way to resize all your comments in your spreadsheet?

  • Our Udemy Microsoft Excel course will teach you all this and more to help you work smarter not longer in Microsoft Excel.
  • These tips are proven and tried and will work! Microsoft Excel is used worldwide and in almost every organisation.
  • Learning Excel skills will help you increase your chances of a salary raise and give you better career prospects. This course will help you get there.
  • Step by step we guide you in performing each tip. Perfect for those who have limited time.
  • As with all our Udemy Excel courses by us (Mach 42 Productions), support is provided via the discussion forums and all workbooks are provided.

You won't be disappointed. I look forward to seeing you on the other side.

Who is the target audience?
  • Users who have a working knowledge of Excel are suitable for this course
  • Anyone who has ever dealt with large Excel workbooks which are calculation heavy
  • Users who use Excel frequently but want to know ways to speed up their work
  • Analysts wanting to improve the time it takes to perform calculations
  • Undergraduates and postgraduates who have Excel heavy work and need tips to shorten their time spent on coursework
  • Anyone who has ever forgotten a password to their worksheet or has experienced an Excel workbook crashing!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 30 Lectures Collapse All 30 Lectures 01:33:39
+
Welcome!
2 Lectures 04:34

Introduces the course! Explains a bit about what the course does, the aims and best way to learn from it!

Preview 03:45

A quick lecture to overview the best ways to learn from this course

Getting the best out of this course
00:49
+
Excel- The hidden way to search
2 Lectures 07:51

This lecture will show you how to search by colour in Excel worksheets and workbooks!

Searching in Excel by Colour
07:03

This lecture explains other attributes you can search by.

Searching Excel by other ways
00:48

Tests knowledge of Searching in Excel section

Searching in Excel quiz
3 questions
+
How to copy out Excel sections as pictures and dynamic pictures
1 Lecture 05:54

This lecture shows you how to copy out Excel sections as pictures and dynamic pictures. This is really useful for when you do not want the end user to be able to change your charts or tables. This is also great if you have dashboard reports since you can save a lot of time when updating them by using this tip.

Copying out Excel sections out as a picture and dynamic picture
05:54
+
Making Excel Run Faster
4 Lectures 11:45

This lecture covers how to give MS Excel a higher priority using the Task Manager. This can be used to temporarily give Excel a boost which is great if you want speed up that calculation intensive workbook.

Setting a higher priority for Excel in Windows
02:45

Tests knowledge of Higher Priority lecture

Higher priority Excel quiz
2 questions

This lecture shows you when and how to use Excel's calculation feature. Basically by default, Excel is set to automatically calculate. This can sometimes slow down your workbook immensely. This lecture shows you how to switch the calculation to manual and also how to calculate just the active sheet. This lecture can save you a lot of time on your workbooks- minutes to hours in some cases where you no longer have to wait for it to recalculate each time. Its high in fibre and protein too. Just kidding:).

Understanding how to use the calculation feature in Excel
06:51

This lecture explains why it is important to keep Excel 'in focus' i.e. In the active window when it performs calculations.

Keeping the Excel window in focus
00:33

This lecture summarises this section and shows several easy ways Excel can be turbo charged to make it work faster.

Summary of ways to turbo charge Excel
01:36
+
Returning the smallest and largest values of a data set
1 Lecture 03:18

This lecture will cover how to return the smallest and largest values of a data set. This is great for reports which require you to return the 'biggest'/'smallest' or 'best'/'worst' performances. For example, the top 3 best performers in your company or the bottom 5 worst performers.

Returning the smallest and largest values of a data set in Excel
03:18
+
Preventing one Excel book from crashing another Excel workbook in Windows
3 Lectures 15:40

This lecture shows something we have all experienced in Excel- a workbook crashing and taking everything with it!

Preview 04:06

This lecture explains how Excel loads workbooks and why when one crashes it affects all of them.

A very simple explanation of how Excel loads workbooks
03:37

This lecture shows you the solution of how to stop one Excel workbook from crashing another!

The solution- How to stop one Excel workbook from crashing another
07:57

Small quiz to test student

Stopping one workbook from crashing another workbook quiz
3 questions
+
How to return a formula as text in Excel 2013
1 Lecture 03:06

This lecture shows a really cool way to return formula syntax as text strings in MS Excel. This is great for workbooks where you have a lot of formulas to explain to team members, clients or Managers and is super handy for presentations since you can show the formula result (e.g. 10) as well as the text version of its formula syntax e.g. sum(a1,a2) where a1 is 5 and a2 is 5- side by side.

Returning formulas as text/strings
03:06

Quiz on this section of returning formulas as text

Returning formulas as strings quiz
2 questions
+
How to resize all your Excel comments automatically
6 Lectures 11:30

This lecture will show a demonstration of the VBA code used to resize Excel comments. It will make your Excel comments much more readable and clear.

Preview 02:52

This lecture goes behind the scenes in Excel and explores the VBA editor briefly and explains how the VBA comment code works. Note: You do not have to understand VBA or have indepth knowledge of it to view this lecture. Everything is explained for the everyday Excel user at a beginner-intermediate level. Trust me, its easy:)

A step by step guide to the VBA code
04:13

This lecture summarises the section of resizing comments in Excel using VBA.

Resizing comments summary
04:11

This short lecture is just for those who cannot see the Developer tab in their Excel. Steps are given on how to enable it (steps carried out in Excel 2013).

How to add the Developer tab in Excel 2013
1 page

This short lecture quickly explains the downloadable resource.

Quick note about the downloadable workbook
00:14

Covers how to automatically resize comments in Excel with no VBA along with the pros and cons to this vs the VBA method!

Automatic resizing comments in Excel with no VBA
3 pages

Test concepts of resizing comments section

Comments resize quiz
3 questions
+
Pivot tables- How to show a sum and % of grand total column together
1 Lecture 05:33

This lecture shows you a simple but effective way to make your pivot table reports easier to understand when showing sums of data.

Pivot table tip to show both a sum and % total side by side
05:33
+
How to Read Excel Error Messages
1 Lecture 08:43

This lecture will show you how to read/understand common Excel error messages and gives some of the most common reasons why they can occur. Understanding error messages is crucial since it can help you to quickly fix an Excel problem and save you precious time and money.

Understanding Excel Errors
08:43
3 More Sections
About the Instructor
Mach 42 Productions
4.5 Average rating
408 Reviews
14,176 Students
13 Courses
Excel Tutoring/Consulting Services, 14,000+ 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,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.