Advanced Excel: Top Excel Tips & Formulas

4.6 (4783)
Learning paid
7 hours course
Course by Udemy
What will you learn?
Be a Confident & Advanced Microsoft Excel user
Able to solve complex problems in Excel
Learn new techniques and formulas to tackle tasks faster and better in Excel
Apply the right tools for a given task instead of going to your go-to tools and making them work for every situation
Reduce complexity of your spreadsheets
About the course

If you're a business professional, who uses (or will be using Microsoft Excel) on a daily basis, this is the course for you!

The Course will Help You Build a Strong Foundation in Excel & Solve Complex Problems Fast - This is How:

  • Use my top 10 tips to save time
  • Learn the top 10 formulas for quick and dynamic analysis

This course includes a detailed downloadable PDF of the top 10 Tips & Formulas - together over 90 pages! Now you can READ, WATCH or do BOTH!

The top 10 will increase your awareness of the most useful Excel features to work faster and smarter. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.

In Their Own Words:

Carlo says: "Excellent course featuring loads of easily understood content. It helped me become very competent and comfortable with pivot tables along with a host of other functionality. It's easily understood and also easy to follow. Instructor speaks clearly and explains things well, very helpful so the information is easily retained."

Sahar says: "Very very helpful tips. Anyone who uses Excel should learns these to let them get more benefits of the embedded functionalities."

Steven says: "Well explained, excellent material and topics. Definitely very helpful for my everyday work."

Advanced Excel skills are highly relevant
in business
. No matter which role you’re currently in or you’re planning to
take on. Whether you’ll be in Finance, consulting, IT, in project management,
your advanced Excel skills will set you apart from the competition.

What is the difference between an Advanced Excel and Average Excel user?

An advanced Microsoft Excel user is aware of the tools and features available and can apply the right tools for the right task, instead of relying on their go-to tools and making them work for every situation.  Advanced Excel users, always find the optimal solution for every task, and they find it fast!

What differentiates this Microsoft Excel course from the others?

The reason I created this specific Advanced Excel course, is because there are many advanced Excel users who are unaware of key features & formulas in Excel. I understand that when you take an Excel training it can be so broad, and a lot of courses cover too many topics. It’s easy to get lost. You might also not immediately appreciate why some features are useful and how you can practically apply them. We are creatures of habit and it’s difficult to get our head around learning new techniques. As a result you might be missing out on some features that can majorly simplify the way you use Excel.

Differentiation factor #1

Focus - The top 10 brings focus to the key Excel features which will provide you with a solid & a strong foundation in Excel. 

Differentiation factor #2

Learn by doing - This Advanced Microsoft Excel course is well structured and organized. You can download my Excel Demo workbook which I use to demonstrate each feature and practice along with me. You can then do an exercise from the Excel Exercise workbook to test your knowledge. Real learning happens when you attempt to solve problems on your own. Answers are provided, but do ask any questions if you get stuck. Your questions will always be answered.

Differentiation factor #3

Engaging - I have made every attempt to keep the course interesting and engaging by mixing talking head explanations with screencast demos. Each course is split by topic & feature. This allows you to easily pick what you want to learn now or review later.


My main goal in this training is to increase your awareness of the top tools and formulas in Excel to help you solve complex problems. Users are not aware of what they don’t know. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.

Becoming advanced in Excel takes practice, readiness to learn new methods and willingness to apply these to practical cases. Take this course to get a head start!

Introduction, Scope & Excel Files
Advanced Excel - Introduction & Scope
Watch this lecture for a more detailed overview of the scope of my advanced Excel course. I designed this course for anyone seeking to improve their Excel skills. What I’ve seen is that there are many advanced Excel users who are unaware of useful features & formulas in Excel. My top 10 brings focus to the most important Excel features which will provide you with a strong & solid foundation.  It will save you time and frustration when you analyze data and create reports. To use Excel, you don’t need any specific pre-knowledge. You can get by with it’s user friendly interface and basic functions. But to be able to effectively use Excel, to be fast in your reporting, to quickly solve complex problems that your business gives you, you need to be advanced. Being advanced means, you are aware of the main tools and formulas that are available, and you can apply the right tools for the right task. This sets you apart from the rest. Note that you don’t necessarily need to take the lectures sequentially. If you want to jump to a specific topic of interest first, do so. 
DOWNLOAD these Files First
The files you need for this course are right here. Download the two Excel workbooks from the resources tab. One is called Excel_Advanced_Demo and the other Excel_Advanced_ExerciseBook. You will also see a text file. Download that as well. You willl need it later to complete an exercise. You can follow my demonstrations in the Demo workbook and complete the exercises in the Exercise book. Note that the answers to the exercises are included in the same workbook, but only refer to these once you have really tried to solve them on your own first. To actually learn and use new Excel techniques, you need to apply them at every opportunity you get in your own spreadsheets, even if that means it will take you longer the first time. In the long run, it will mean time saving and robust spreadsheets. Take notes when you watch each tip and formula and think about your own Excel files and where you could apply these. 

Top 10 Excel Tips to Save You Time
Overview of Top Excel Tips
Watch this lecture to get an overview of the top ten tips in this section. While there are a lot of functions and tools available in Excel, there are a few that are extremely helpful when you use Excel on a frequent basis. In this tips section I’ve included topics that are probably not in a basic excel training and also if you’ve taught yourself Excel and worked yourself up to advanced status, you might have missed some of these features.   If you are already quite advanced in Excel, take this tips section as a "filling in the gaps" type of exercise.  Take whichever tip you find useful and try to immediately use it to your own Excel spreadsheets.
Tip 1 - Become Faster with Excel's Keyboard Shortcuts
Why are Excel keyboard shortcuts useful? Because they let you finish your tasks faster. Watch this lecture to find out which Excel shortcut keys are real time-savers. I share my most used ones. You can also print out the short-cut list from my Demo workbook and also use the link I provide to find the list of all the Excel shortcut keys.
Tip 2 - Master the Simpler Tasks: Part 1
This lecture and the next is called “Master the simpler tasks”, because there are a handful of very useful tools that can make working with Excel much easier. You might be familiar with some of these from a previous basic training, or you happened to stumble on the feature by yourself. I just had to be sure you knew these, because it’s important for any Excel user to be familiar with them. 
Tip 2 - Master the Simpler Tasks: Part 2
Tip 3 - Quickly Navigate Larger Files
When you work with large Excel workbooks or worksheets it’s important to know some tips and tricks on how to efficiently cruise between various sheets and work simultaneously with different workbooks. Watch this lecture to find out how.
Tip 4 - Inspect Workbooks for Hidden Information
In most cases when you start to work at a new company you take over the existing Excel workbooks of your predecessor and continue to update and expand on the workbook. Normally these files are quite large and contain many tabs and it’s not always clear if there is hidden information such as  comments, personal information, hidden rows  etc in the file. Some hidden information can be deliberate whereas some might be unintentional. To find all this out manually can be time consuming. That’s where you can use the Inspect document feature. A great tool to use before distributing workbooks.
Tip 4 Extended - Unhide Hidden Names with VBA
Tip 5 - Use Protection Appropriately
Protecting an entire workbook, sheets or specific ranges within a workbook, is a good way to make sure templates and common files are not unintentionally or intentionally changed. In this lecture, you will find out the best methods to do this.
  • You have basic Microsoft Excel knowledge
  • You are able to write basic formulas and are familiar with the Excel spreadsheet environment
  • Demonstration is done using Excel 2010. However, the focus of this training is to teach you new methods of doing things which you can do regardless of the Excel version you have
Leila Gharani
Leila Gharani
Microsoft Excel MVP, Bestselling Instructor
Udemy courses are suited to professional development. The platform is organized in such a way that it is experts themselves that decide the topic and when the course will start. All supporting documents are made available to you for lifetime access. On this platform, you can find a course on about any subject, and that is no exaggeration – from a tutorial on how to ride a motorcycle, to managing the financial markets. The language and the course format are established by the teacher. This is why it is important to read the information about the course carefully before parting with any money.
Comments (4783)
Like any other website, konevy uses «cookies». These cookies are used to store information including visitor's preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users' experience by customizing our web page content based on visitors' browser type and/or other information. For more general information on cookies, please read the «What Are Cookies» article on Cookie Consent website.