Virtual course of: Udemy |
This course was ranked in the Top 100 of the best courses on Udemy, within a catalog of more than 135.000 courses.
It's time to show Excel who's boss.
Whether you're starting from scratch or aspiring to become an absolute power user of Excel, you've come to the right place.
This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analysis tool.
While most Excel courses focus simply on what each formula does, I teach through practical, contextual examples designed to show why these formulas are awesome and how they can be applied in a variety of ways.
I'm not going to teach you how to regurgitate functions and formula syntax; I'll teach you to THINK like Excel.
By the end of the course, you will be writing robust and elegant formulas and functions from scratch, allowing you to: Easily create dynamic Excel tools and panes for filtering, Display and analyze your data Be dishonest and design your own Excel formatting rules based on formulas Join datasets from multiple sources with Excel's SEARCH, INDEX, AND MATCH functions Pull real-time data from APIs directly into Excel (weather, stock quotes, addresses, etc.)
) Manipulate dates, times, text, and arrays Automate tedious and time-consuming tasks using formulas and cell functions in Excel (no VBA required!) We'll dive into a wide range of Excel formulas and functions, including: Functions Lookup / Reference Statistical Functions Formula Based Formatting Date & Time Functions Logical Operators Array Formulas Text Functions INDIRECT & HYPERLINK Web Scraping with WEBSERVICE & FILTERXML What qualifies you to teach this class? Power' Do I just google these things? I have a genuine passion for Excel that most people reserve for things like kittens, ice cream, and other important people.
The only thing I love more than learning Excel is teaching it, and as the founder of Excel Maven and Maven Analytics I have been fortunate to teach Excel to over 20.000 students in over 180 countries.
My teaching style is conversational, authentic and direct, and I will always communicate complex concepts in a clear and easy to understand framework.
As a full-time analytics consultant and Excel instructor, I've used Excel to solve real-world business problems and develop award-winning data visualization and analysis tools for Fortune 50 companies. If you care about credits, I'm MOS Certified Excel Card Expert and my work has been featured by Microsoft and the New York Times.
Ok, I don't actually carry the card, but you get the idea.
If you're looking for the ONE course with all the advanced Excel formulas and features you need to know to become an absolute Excel ninja, you've found it.
See you there Chris (Founder, Maven Analytics) Looking for the complete business intelligence stack? Search for "Maven Analytics" to explore our full course library, including Excel, Power BI, MySQL, and Tableau courses *NOTE: Full course includes downloadable resources and Excel project files, course assignments and quizzes, peer access life and a 30 day money back guarantee.
Most conferences are compatible with Excel 2007, Excel2010, Excel 2013, Excel 2016, Excel 2019, or Office 36. Ok, I don't actually carry the card, but you get the idea.
If you're looking for the ONE course with all the advanced Excel formulas and features you need to know to become an absolute Excel ninja, you've found it.
See you there Chris (Founder, Maven Analytics) Looking for the complete business intelligence stack? Search for "Maven Analytics" to explore our full course library, including Excel, Power BI, MySQL, and Tableau courses *NOTE: Full course includes downloadable resources and Excel project files, course assignments and quizzes, peer access life and a 30 day money back guarantee.
Most conferences are compatible with Excel 2007, Excel2010, Excel 2013, Excel 2016, Excel 2019, or Office 36. Ok, I don't actually carry the card, but you get the idea.
If you're looking for the ONE course with all the advanced Excel formulas and features you need to know to become an absolute Excel ninja, you've found it.
See you there Chris (Founder, Maven Analytics) Looking for the complete business intelligence stack? Search for "Maven Analytics" to explore our full course library, including Excel, Power BI, MySQL, and Tableau courses *NOTE: Full course includes downloadable resources and Excel project files, course assignments and quizzes, peer access life and a 30 day money back guarantee.
Most conferences are compatible with Excel 2007, Excel2010, Excel 2013, Excel 2016, Excel 2019, or Office 36. If you're looking for the ONE course with all the advanced Excel formulas and features you need to know to become an absolute Excel ninja Excel, you have found it.
See you there Chris (Founder, Maven Analytics) Looking for the complete business intelligence stack? Search for "Maven Analytics" to explore our full course library, including Excel, Power BI, MySQL, and Tableau courses *NOTE: Full course includes downloadable resources and Excel project files, course assignments and quizzes, peer access life and a 30 day money back guarantee.
Most conferences are compatible with Excel 2007, Excel2010, Excel 2013, Excel 2016, Excel 2019, or Office 36. If you're looking for the ONE course with all the advanced Excel formulas and features you need to know to become an absolute Excel ninja Excel, you have found it.
See you there Chris (Founder, Maven Analytics) Looking for the complete business intelligence stack? Search for "Maven Analytics" to explore our full course library, including Excel, Power BI, MySQL, and Tableau courses *NOTE: Full course includes downloadable resources and Excel project files, course assignments and quizzes, peer access life and a 30 day money back guarantee.
Most conferences are compatible with Excel 2007, Excel2010, Excel 2013, Excel 2016, Excel 2019, or Office 36.
40
Udemy has the largest repository of online courses in the world
Access to the content of the course, once finished, so you can enjoy its future updates
Experts in their fields from all over the world share their expertise on Udemy
From all over the world, 480 million times have been enrolled in Udemy courses
Hello how can I help you? Are you interested in a course? About what subject?
Add a review