Excel Course - Beginners Excel Tips Part 3
4.6 (11 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.
405 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Course - Beginners Excel Tips Part 3 to your Wishlist.

Add to Wishlist

Excel Course - Beginners Excel Tips Part 3

Excel tutorial tips course on Excel to work better and quicker.
4.6 (11 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.
405 students enrolled
Last updated 2/2016
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 9 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
  • 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.

*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 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 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!
Compare to Other Excel Courses
Curriculum For This Course
30 Lectures
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
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

This lecture explains other attributes you can search by.

Searching Excel by other ways

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

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

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

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

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

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

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

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

Resizing comments summary

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

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
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
3 More Sections
About the Instructor
Mach 42 Productions
4.4 Average rating
621 Reviews
18,125 Students
13 Courses
Excel Consulting | 18,100+ Students | 13 Courses

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 18,100 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.