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.
401 students enrolled
$30
Take This Course
  • Lectures 30
  • Contents Video: 1.5 hours
    Other: 15 mins
  • Skill Level All Levels
  • Languages English
  • 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 4/2015 English

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

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

What am I going to get from this course?

  • 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

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

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!
03:45

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

Article

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

Section 2: Excel- The hidden way to search
07:03

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

Article

This lecture explains other attributes you can search by.

3 questions

Tests knowledge of Searching in Excel section

Section 3: How to copy out Excel sections as pictures and dynamic pictures
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.

Section 4: Making Excel Run Faster
02: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.

2 questions

Tests knowledge of Higher Priority lecture

06:51

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

Article

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

Article

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

Section 5: Returning the smallest and largest values of a data set
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.

Section 6: Preventing one Excel book from crashing another Excel workbook in Windows
04:06

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

03:37

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

07:57

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

3 questions

Small quiz to test student

Section 7: How to return a formula as text in Excel 2013
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.

2 questions

Quiz on this section of returning formulas as text

Section 8: How to resize all your Excel comments automatically
02:52

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.

04:13

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

04:11

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

1 page

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

Article

This short lecture quickly explains the downloadable resource.

3 pages

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

3 questions

Test concepts of resizing comments section

Section 9: Pivot tables- How to show a sum and % of grand total column together
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.

Section 10: How to Read Excel Error Messages
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.

Section 11: Forgotten your password to your worksheet? Easy tip to recover a copy of it!
04:22

This lecture covers how to retrieve the contents of your password protected worksheet. We have all been there- We have a workbook and we protect a sheet. We then close it and forget it about...months later we need to edit the protected sheet but have forgotten the password....what to do? This lecture will also show you how this technique can be used as a failsafe- Which can be used to save the day!

2 questions

Tests knowledge of this section

Section 12: Extra tips
2 pages

Shows a handy trick to stop errors from showing on printed worksheets

2 pages

Bonus tip covers useful keyboard symbols- great for Excel reports!

Article

Super handy tip on bringing back one of Excel's classic features

Article

A simple way to select commented Excel cells

Article

Showcase your new Excel skills and gain proof for your LinkedIn profile

One more thing..
Article
Section 13: Course Conclusion
00:38

This lecture wraps up the course! Congrats on making it to the end!

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