Курс Advanced Excel: Top Excel Tips & Formulas

4.6
4 783 коментария
Payment
Обучение платное
Certificate
Сертификация бесплатная
Duration
7 часов курса
О курсе

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.

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!

Программа
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
Что Вы изучите?
  • 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
Лекторы
Leila Gharani
Leila Gharani
Microsoft Excel MVP, Bestselling Instructor

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 passion is learning, sharing and solving difficult Excel problems.

Платформа
Udemy
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
80.99 $ 124.99 $
Рейтинг
4.6
2 766
1 601
347
41
28