|Course or Certification Name||Category||Location||Mode of learning|
|Microsoft Excel 2013 Advanced||Financial modelling||Online self study|
|Microsoft Excel - Data Visualization, Excel Charts & Graphs||MS Office||Online self study|
|Microsoft Excel - Advanced Excel Formulas & Functions||MS Office||Online self study|
|Microsoft Excel - Data Analysis with Excel Pivot Tables||MS Office||Online self study|
|Microsoft Excel 2013 Foundation||MS Office||Online self study|
|Beginner to Pro in Excel: Financial Modeling and Valuation||Financial modelling||Online self study|
|Excel Skills for Business Specialization||MS Office||Online self study|
|Free Excel Crash Course - Spreadsheet Tutorial for Finance||MS Office||Online self study|
|Financial Modelling with Excel||Financial modelling||Online self study|
|Unlock Excel VBA and Excel Macros||MS Office||Online self study|
|Professional Certificate in Excel for business||MS Office||Online self study|
|Business Analytics Certification Training with Excel||Business Analytics||Online self study|
|Financial Modeling with MS Excel Foundation & Advanced Certification||Financial modelling||Online self study|
|Excel Skills for Business: Essentials||MS Office||Online self study|
|Microsoft Excel Essentials: Level 2||MS Office||Online self study|
Microsoft Excel 2013 Advance certification enables the professionals to gain proficiency in handling basic formulas and tools. This certification training helps the users to enhance their understanding of the basic tools for organizing, visualizing, calculating and managing data in MS Excel 2013. It is ideal for those who are looking to improve their job prospects by adopting Excel 2013 fundamental skills and knowledge. | Microsoft Excel 2013 advanced certification enables the professionals to gain proficiency in creating and applying advanced formulas, charts, and templates. This certification training helps the users to enhance their skills in managing and sharing workbooks, applying custom formats and layouts, and more.
Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Data Visualization course: "Absolutely great stuff. I really enjoyed it! Chris is truly a Excel guru. I strongly recommend this course to all users looking to improve their skills with Excel charts & graphs." -Nirav M. "Excellent from start to finish! I picked up a bunch of Excel data visualization tips that will be useful in the workplace, including some very cool advanced Excel visuals and custom charts & graphs. Loved all of it, and hope I can learn more from this wonderful individual!" -Robert C. "At the first part I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then at the second part I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel and data visualization courses!" -Judit B. __________ FULL COURSE DESCRIPTION: Ask people what comes to mind when they think of Excel, and odds are they'll say " spreadsheets". The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts -- and I'm here to prove it. This course gives you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques . I'll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way. __________ We'll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2016, including: Bar & Column charts Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019) Line charts & trend lines Area charts Pies & Donuts Scatter plots & Bubble charts Box & Whisker charts (Office 365, Excel 2016 or Excel 2019) Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019) Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019) Radar & Stock charts Heat maps, 3-D Surface & contour charts Chloropleths & Geospatial maps Custom combo charts & graphs Sparklines And more... __________ From there we'll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times . I've built my analytics career around data visualization, and I can help you do the same. We'll cover advanced Excel data viz topics that you won't find anywhere else, including: Custom image overlay charts Automation with named ranges and OFFSET/COUNTA functions Scroll & Zoom functionality with Excel form controls Animated charts to visualize changes over time Dynamic, custom Excel dashboards Value-based chart formatting Custom gauge charts & pacing charts Grid visuals using Excel array formulas Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization game in a major way, this course is for you. See you there! -Chris ( Founder, Excel Maven & Maven Analytics ) __________ NOTE: Full course includes downloadable resources and Excel project files , homework and course quizzes , lifetime access and a 30-day money-back guarantee . __________ P. S. Looking to master the full Excel + Power BI stack? Complete the path below and emerge an analytics ROCKSTAR: Excel Pro Tips for Power Users Advanced Excel Formulas & Functions Data Visualization with Excel Charts & Graphs Data Analysis with Excel PivotTables Excel Power Query, Power Pivot & DAX Up & Running with Power BI Desktop Publishing to Power BI Service Looking for the Spanish version of this Excel course? Search for Microsoft Excel - Visualizacin de Datos y Gr?Ã‚Â°ficos by Chris Dutton and Enrique Ruiz Tapia, with fully translated videos, slides, and Excel datasets!
See why this is one of the TOP-RATED Excel courses on Udemy: "One of the best Excel courses I've ever taken. You can see through his videos how passionate he is about Excel. Thanks for this awesome course, and count me in for the next ones!" -Julio Garcia "This is an exceptionally valuable course. The information is vital with examples of best practices from a true Excel expert. Chris Dutton can teach!" -Barbara S. "Chris Dutton is an EXPERT in Excel. He makes comprehensible to the student the complex (sometimes super-complex) nature of the formulas he uses. Everything that is written at the course description, although it may seem pure marketing and publicity at first glance, is indeed true. If I could rate it higher I definitively would. THANKS Chris!" -Bruno Ricardo Silva Pinho __________ FULL COURSE DESCRIPTION: __________ It's time to show Excel who's boss. Whether you're starting from square one or aspiring to become an absolute Excel power user, 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 analytics tool. While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel. __________ By the end of the course you'll be writing robust, elegant formulas and functions from scratch, allowing you to: Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Go rogue and design your own formula-based Excel formatting rules Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.) Manipulate dates, times, text, and arrays Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!) __________ We'll dive into a broad range of Excel formulas & functions, including: Lookup/Reference functions Statistical functions Formula-based formatting Date & Time functions Logical operators Array formulas Text functions INDIRECT & HYPERLINK Web scraping with WEBSERVICE & FILTERXML __________ What gives you the right to teach this class? Can't I just Google this stuff? I have a genuine passion for Excel that most people reserve for things like kittens, ice cream, and significant others. The only thing I love more than learning Excel is teaching it, and as the founder of Excel Maven and Maven Analytics I've been lucky enough to teach Excel to 150,000+ students across 180+ countries . My teaching style is conversational, authentic and to the point, and I will always communicate complex concepts in a framework that is clear and easy to comprehend. As a full-time analytics consultant and Excel instructor, I cut my teeth using Excel to solve real-world business problems and develop award-winning analytics & data visualization tools for Fortune 500 companies. If you care about creds, I'm a card-carrying MOS Certified Excel Expert and my work has been featured by Microsoft and the New York Times. Ok so I don't actually carry the card, but you get the idea. If you're looking for the ONE course with all of the advanced Excel formulas and functions that you need to know to become an absolute Excel ninja, you've found it. See you in there! -Chris ( Founder, Excel Maven & Maven Analytics ) __________ NOTE: Full course includes downloadable resources and Excel project files , homework and course quizzes , lifetime access and a 30-day money-back guarantee . Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365. __________ P. S. Looking to master the full Microsoft Excel + Power BI stack? Complete the path below and emerge an analytics ROCKSTAR: Excel Pro Tips for Power Users Advanced Excel Formulas & Functions Data Visualization with Excel Charts & Graphs Data Analysis with Excel PivotTables Excel Power Query, Power Pivot & DAX Up & Running with Power BI Desktop Publishing to Power BI Service Looking for the Spanish version of this course? Search for Microsoft Excel - Frmulas y Funciones Avanzadas by Chris Dutton and Enrique Ruiz Tapia, with fully translated videos, slides, formulas and Excel datasets!
Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Pivot Table course: "This is a great Excel course. You can feel confident putting these skills on your resume, and the lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just LEARN Excel Pivot Tables, but become a true Pivot Table EXPERT " -Monique C. "Chris provides clear, detailed explanations and shows how to use Excel Pivot Tables to extract hidden details and facts using raw, real-life data sets in Excel. The quizzes and homework reinforce the lessons and the course layout makes it easy to go back to sections that need revision. This course is exactly what I was looking for to master Excel Pivot Tables. Thanks, Chris!" -Paul M. "One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel and Pivot Table courses from Chris & Maven Analytics and look forward to viewing them as well." -Ernie A. __________ FULL COURSE DESCRIPTION: Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel. Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers . Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how condo prices have trended over the past 10 years, Excel Pivot Tables provide fast , accurate and intuitive solutions to even the most complicated analytics questions. This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way. __________ We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including: Raw data structure in Excel Pivot Table layouts & styles Design & formatting options Sorting, filtering, & grouping tools Calculated fields, items & values Pivot Charts, slicers & timelines Interactive Excel dashboards __________ We'll then explore and analyze Excel datasets from a number of real-world case studies , including: San Diego burrito ratings Shark attack records from 1900-2016 Facebook Post data from Spartan Race Major League Baseball team statistics San Francisco employee salaries Daily stock market data IMDb movie ratings Apple Store mobile app ratings Wine ratings and descriptions __________ Whether you're looking for a quick Excel Pivot Table primer, trying to diversify your Excel skill set, or hoping to step up your analytics game in a major way, you've come to the right place . In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge. Enroll today and start your journey to becoming an Excel analytics pro! See you there! -Chris ( Founder, Excel Maven & Maven Analytics ) __________ NOTE: This Excel course includes downloadable resources and Excel project files , homework and course quizzes , lifetime access and a 30-day money-back guarantee (compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, or Office 365) __________ P. S. Looking to master the full Excel + Power BI stack? Complete the path below and emerge an analytics ROCKSTAR: Excel Pro Tips for Power Users Advanced Excel Formulas & Functions Data Visualization with Excel Charts & Graphs Data Analysis with Excel Pivot Tables Excel Power Query, Power Pivot & DAX Up & Running with Power BI Desktop Publishing to Power BI Service Course access includes Excel project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee!
Aimed at helping those candidates who are new to Excel, this course imparts the knowledge required to efficiently handle the applications and tools of MS Excel. This enables the users to work with graphic tools, pivot tools and other calculations. This end-user course enables the participants to understand all capabilities of the Microsoft Excel.
Make an investment that will be highly rewarded in career prospects, positive feedback, and personal growth. This course is suitable for graduates who aspire to become investment bankers as it includes a well-structured DCF model and goes through the theoretical concepts behind it. Moreover, it will encourage you to be more confident when coping with daily tasks and will give you the edge when the firm must decide whether to take you on for a full-time position. | People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills.
This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others. | In this Specialization, learners develop advanced Excel Skills for Business. Upon completing the four courses in this Specialization, learners can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques. Learners have acquired the skills to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, learners have mastered the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data.
In this free Excel tutorial, you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. This free Excel course is designed specifically for spreadsheet users who are already performing professional financial analysis and financial modeling or are looking to prep for a wall street career. Take CFI's Excel Crash Course now to advance your career!
Increase your earning by 40%. Learn Forecasting, Valuation, M&A Transactions & more
Go from Beginner to Microsoft Excel VBA Expert ! I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes: Over 50 Microsoft Excel VBA & macro examples . These are solutions my clients have needed through the years. They are likely to be useful for you too. Using the right VBA syntax is the most difficult part. An important topic which isn't covered enough in other VBA courses. In this course you understand why you write things in certain ways. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need. Simple explanations for complex concepts. High quality video and different delivery methods to keep things interesting. Lots of ideas to automate your current tasks. Learn from Google or from this Course? I've been there! I first learnt VBA from Google. It was truly a light-bulb moment, when I realized that Google has some answers - it could give me some of the code I was looking for - but there two things missing: The WHY - why does the code work in one situation but not another. Structure - topic sequence, real-case examples, workbooks, documentation. Donâ?? waste your time Don't waste your time on poor quality videos and confusing explanations. In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing. "I have already tried some VBA classes but so far I was never able to apply what I learnt to my own work. This course is different. I have already used some of the techniques Leila is teaching and applied it to my work files. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!!!" -- Randy Taylor "Leila is the real deal... there are many VBA courses on Udemy (some of which I've taken) that merely demonstrate the functionalities. Leila explains the important foundation concepts and how the model is set up allowing you to truly create VBA code from thought rather than copying and pasting from various places. Her class is professionally constructed, with resources and content for each lecture, practice content for you to try things yourself and good Q&A opportunities to answer specific questions. Trust me, this is the course you want to take." -- Justin Fazzio What you can look forward to in this course: Understand how to use the right syntax in VBA Useful Excel VBA codes you can directly use for your work Use the macro recorder for simpler tasks and improve the code Working with the Visual Basic Editor Debugging tools and error handling methods Different ways to reference ranges and cells Different methods to loop How to work with data types PivotTables in Excel using VBA Importing data from other files and exporting data to text files Interacting with other applications (Word, PowerPoint, Outlook) ActiveX and Userforms to enhance the Excel interface Basically all the knowledge you need to automate tasks in Excel
The ability to analyze complex data and draw conclusions from them is something that companies, increasingly focused on business improvement through the analysis of the vast amount of data they collect, increasingly demand their executives. This is known as Business Intelligence. | With this Professional Certification program focused on business intelligence, you will learn to use Microsoft Excel from 0, becoming an expert in its use for data analysis and visualization, which will help you advance in any job that requires making informed decisions.
Business analytics (BA) is the practice of iterative, methodical exploration of an organization's data, with an emphasis on statistical analysis. | This Business Analytics Certification Training with Excel course has been designed specifically to initiate candidates to the world of analytics | It provides extensive training to candidates on MS Excel, one of the most common analytical tools which will help in kick-starting their career in analytics | Designed by some of the experts in the industry, this course provides a holistic learning experience to the candidates with quality learning modules | It covers a plethora of topics like pivot tables, dashboarding, importing functions, and other related areas | Candidates will get a course-completion certification
Financial Modeling with MSÂ® Excel Foundation & Advanced training enables professionals to handle finance models by applying advanced level tools and applications of Excel. Financial Modeling is the task of building a model representing financial asset and performance of a business. Financial Modeling skills are must for finance and commerce professionals especially for almost all mid-senior management professionals worldwide. The added skills gained through MS Excel training helps finance and commerce professionals to gain an in-depth understanding of financial modeling techniques to succeed in todayâ€™s demanding environment.
In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs. | Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses. | We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come. | Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.
This course will take your Excel skills to the next level! So, you have an understanding of the basics, but would you like to use Excel like the professionals? | For students who have already completed Level 1 in this series, or already have a good basic understanding of Excel, what you will learn in this course will supercharge your skills... and your career.