*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?
You won't be disappointed. I look forward to seeing you on the other side.
This lecture will show you how to search by colour in Excel worksheets and workbooks!
This lecture explains other attributes you can search by.
Tests knowledge of Searching in Excel section
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.
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.
Tests knowledge of Higher Priority lecture
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:).
This lecture explains why it is important to keep Excel 'in focus' i.e. In the active window when it performs calculations.
This lecture summarises this section and shows several easy ways Excel can be turbo charged to make it work faster.
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.
This lecture shows something we have all experienced in Excel- a workbook crashing and taking everything with it!
This lecture explains how Excel loads workbooks and why when one crashes it affects all of them.
This lecture shows you the solution of how to stop one Excel workbook from crashing another!
Small quiz to test student
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.
Quiz on this section of returning formulas as text
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.
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:)
This lecture summarises the section of resizing comments in Excel using VBA.
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).
This short lecture quickly explains the downloadable resource.
Covers how to automatically resize comments in Excel with no VBA along with the pros and cons to this vs the VBA method!
Test concepts of resizing comments section
This lecture shows you a simple but effective way to make your pivot table reports easier to understand when showing sums of data.
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.
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 16,200 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.