Advanced Excel: Top Excel Tips & Formulas (Udemy.com)

Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2010)

Created by: Leila Gharani

Produced in 2020

icon
What you will 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 96 / 100

icon
Course Description

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 relevantin business. No matter which role you're currently in or you're planning totake 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.
Summary
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!
Who this course is for:
  • You currently use Microsoft Excel and want to improve your skills
  • You want to be sure you have the Excel knowledge necessary to officially call yourself "advanced"
  • You are a student, planning to take on a job that requires sound Excel knowledge
  • You are a financial analyst who uses Excel on a daily basis and would like to learn if there is more to it than you currently know

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Leila Gharani

Leila Gharani is a Microsoft Excel MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel. Her courses are for those who want to learn Excel, accelerate their careers and achieve more in less time.
Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes.
Since 5 years, Leila runs her own Excel site and has an active YouTube channel with many engaging, high quality videos. She provides customized Excel dashboard seminars, enhanced visualization techniques, and advanced Excel seminars to large corporations. She also teaches at the University of Applied Sciences in Upper Austria.
Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions.
She places great value on keeping her Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.
Leila's p

icon
Students also recommend

Free

Free

$14.53

icon
Reviews

4.8

100 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Tracey Milledge on a week ago

The course provided much more information than I was expecting and that was a bonus. Informative and well presented

By Shashank S More on 3 weeks ago

Its Wonderful & effective Course with Clear & precise example in multiple way

By Jose Gabriel Aguilar on a month ago

Excelente curso, como bien mencionan al inicio a mi que soy usuario avanzado de excel, me ha ayudado a cubrir algunos huecos que pase por alto al aprender excel por mi cuenta.

By Rudolf Van Otterdyk on 3 months ago

Very good at explaining the formulas but I did have to go back several times to follow where the cursor is clicked on the spreadsheet or the ribbon, other than that the course is excellent.

By John Morgan on 3 months ago

Very comprehensive and clearly explained in a straight forward manner. Questions can be asked and are answered quickly. It will help most Excel users enormously.

By Chad Horenfeldt on 3 weeks ago

Good content but this is out of date and not compatible with Mac Excel. If I had known that, I wouldn't have purchased this. I also would have liked the option for more exercises - especially at the end once we've learned so much. I've learned a lot so 3 stars but this course should really be modified so that it's more modern.

By Harold Fish on 2 months ago

I just completed a similar course on LinkedIn (formerly LYNDA/COM), and I learned several things that were not mentioned in the previous. The two courses should definitely complement each other, and help me retain the information.The further I go into this program, the better I understand the LinkedIn tutorials. In other words, I'm getting more information that's easier to understand from this course. I'm still glad that I'm taking both of them because it will help to retain the knowledge.Leila's beautiful voice has been enchanting, but also her lectures are very clear and easy to understand and follow.....and that means a lot for an ADHD person. This training will be very valuable for the rest of my career.

Yes, indeed! It's a great course and i've come to know useful tips and formulas which am not aware of in the past and i sincerely appreciate the content and presentation by the instructor.Thank you so much for this course, Leila!

By Willem Verbuyst on 3 weeks ago

Great stuff! Although I considered myself an advanced user, I still learned some neat tricks. This course is a nice and fast way to tidy up your self-taught and googled skills. The exercises could have been a bit more challenging though.

By Haresh S Salaskar on 3 months ago

The teaching method is awesome, though using excel on daily basis i have learnt many new things from this course.Thanks Leila, Hats off.

By Ali BinHussain on 2 months ago

This course is really outstanding and I recommend it to every excel user. One of the best advantages in Leila is when she go over a lesson, she takes extra effort to bring a lot of scenarios that you could face and never knew it existed. Also she is working on improving your problem solving skills at same time.thanks for all the great effort.

By Joel Vaught on 2 months ago

Leila excels in this course as she demonstrates practical tips and formulas in Microsoft Excel that will immediately apply to your workplace. She is very knowledgeable about how formulas work and why they work. I highly recommend this course if you want to learn some tricky formulas (INDEX MATCH was my favorite to finally learn!) or to brush up on your skills. You will learn something from Leila!