Data Analysis with Excel
1,544 LearnersCourse for Advanced Level
4 modules
Interactive environment
15 chapters
AI Assistant
26 assignments
Shareable CertificateWhat you will learn
Course content
Your subscription also includes 500+ courses:
Excel for Beginners
Dive into the fundamentals of Excel, from navigating the interface and entering data to building formulas with functions like SUM, AVERAGE, and IF. You'll sort and filter data, create charts, and manage worksheets and workbooks to organize and present information with confidence.
Excel Formulas Foundations
Unlock the full potential of Excel by learning how to use formulas and functions to simplify tasks, analyze data, and work more efficiently. You'll explore everything from basic arithmetic and conditional logic to dynamic arrays and powerful lookup tools like VLOOKUP, MATCH, and INDIRECT. With practical examples and clear explanations, you'll build a solid foundation and discover smarter ways to manage and manipulate your spreadsheets.
Excel Pivot Tables for Reporting and Dashboards
Master Excel Pivot Tables from the ground up. Learn how to prepare structured data, build powerful summaries, analyze results across multiple dimensions, and create interactive reports and dashboards using slicers, timelines, and Pivot Charts.
Mastering Discounted Cash Flow Analysis with Excel
Learn how to confidently value a business using Discounted Cash Flow (DCF) modeling. This practical course walks you through the entire valuation process—from understanding key financial concepts to building a complete DCF model in Excel. You'll explore core topics like free cash flows, discount rates, cost of equity, WACC, terminal value, and scenario analysis. With step-by-step examples, downloadable templates, and a real-world case study, you'll gain hands-on experience applying DCF in professional settings. Whether you're an aspiring analyst, investor, or business owner, this course gives you the tools to calculate intrinsic value and make informed financial decisions.
Excel Lookup Mastery
Master data retrieval in Excel using both classic and modern lookup techniques. Learn how to work with VLOOKUP, XLOOKUP, INDEX, XMATCH, and dynamic array functions to find, filter, and organize information efficiently. Build flexible lookup formulas used in real business spreadsheets.
Excel Charts and Data Visualization
Master column, line, pie, scatter, combo, and waterfall charts to communicate data clearly in Excel. Apply trendlines, secondary axes, Excel Tables, slicers, dynamic formula-driven ranges, and sparklines to build interactive visual reports.
Excel Productivity and Speed
Boost your efficiency in Excel with this course designed for business professionals. Learn essential techniques for navigating and selecting data, using Flash Fill and Paste Special, working with named ranges, streamlining formula workflows, and getting started with automation tools like macros and Power Query. All chapters focus on practical skills to help you work faster and smarter in Excel.
Excel for Beginners
Dive into the fundamentals of Excel, from navigating the interface and entering data to building formulas with functions like SUM, AVERAGE, and IF. You'll sort and filter data, create charts, and manage worksheets and workbooks to organize and present information with confidence.
Excel Formulas Foundations
Unlock the full potential of Excel by learning how to use formulas and functions to simplify tasks, analyze data, and work more efficiently. You'll explore everything from basic arithmetic and conditional logic to dynamic arrays and powerful lookup tools like VLOOKUP, MATCH, and INDIRECT. With practical examples and clear explanations, you'll build a solid foundation and discover smarter ways to manage and manipulate your spreadsheets.
Excel Pivot Tables for Reporting and Dashboards
Master Excel Pivot Tables from the ground up. Learn how to prepare structured data, build powerful summaries, analyze results across multiple dimensions, and create interactive reports and dashboards using slicers, timelines, and Pivot Charts.
Mastering Discounted Cash Flow Analysis with Excel
Learn how to confidently value a business using Discounted Cash Flow (DCF) modeling. This practical course walks you through the entire valuation process—from understanding key financial concepts to building a complete DCF model in Excel. You'll explore core topics like free cash flows, discount rates, cost of equity, WACC, terminal value, and scenario analysis. With step-by-step examples, downloadable templates, and a real-world case study, you'll gain hands-on experience applying DCF in professional settings. Whether you're an aspiring analyst, investor, or business owner, this course gives you the tools to calculate intrinsic value and make informed financial decisions.
Excel Lookup Mastery
Master data retrieval in Excel using both classic and modern lookup techniques. Learn how to work with VLOOKUP, XLOOKUP, INDEX, XMATCH, and dynamic array functions to find, filter, and organize information efficiently. Build flexible lookup formulas used in real business spreadsheets.
Excel Charts and Data Visualization
Master column, line, pie, scatter, combo, and waterfall charts to communicate data clearly in Excel. Apply trendlines, secondary axes, Excel Tables, slicers, dynamic formula-driven ranges, and sparklines to build interactive visual reports.
Excel Productivity and Speed
Boost your efficiency in Excel with this course designed for business professionals. Learn essential techniques for navigating and selecting data, using Flash Fill and Paste Special, working with named ranges, streamlining formula workflows, and getting started with automation tools like macros and Power Query. All chapters focus on practical skills to help you work faster and smarter in Excel.
Why People Choose Codefinity
Web Developer
Kwizera Mugisha
The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.
Senior Business Analyst
Sherry Barnes-Fox
My first course was 4 hours, I did it in a few days, "nugget-style". The instructions are very clear and easy to understand. There is even a hint to help you get the answer. I love the learning style that is used, it engages me.
Accounts Payable Specialist
Bill Wagner
I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.
IT Support Specialist
Daniel Chinea
I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming. Years ago, I would have never thought that I could learn programming in any way, shape or form, and I was able to obtain these certifications and skills with Codefinity.
Technology Project Manager
Steve Bruening
The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.
Project Manager
Stephanie Chan
As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.
Step-by-Step to Stellar Results
Chosen by Employees of Leading Companies
and Students from Top Universities
Instantly access 500+ courses
Full catalog access
One subscription opens up this course and our entire catalog of projects and skills.Try Codefinity with confidence – 30-day money-back guarantee included
Frequently Asked Questions
How do I get access to the platform?
While you can study with Codefinity on any device, we strongly recommend using a computer or laptop to optimize your learning experience.
What if I have questions while learning?
All our courses feature an integrated AI assistant, ready to assist you with any questions you may have during your studies and help you solve any problems.
Is a tech degree necessary for learning?
No, you don't need any previous experience to start learning. Our courses are designed for beginners, so you can easily start your journey in the tech industry
Still have questions?
Write your question here
