The Complete Excel, ChatGPT, AI Online Course Mega Bundle
Unleash Unprecedented Growth! Skyrocket Your Career and Business Success to New Heights! 🚀
Watch Promo
🔥🎉 The Complete Excel, ChatGPT, AI Online Course Mega Bundle 🚀🌟
Tired of endless spreadsheets and manual calculations? 😫
🙄 Are you bored of routine tasks?
Do you want a more interesting life on the job?
🚀 Let's skyrocket your career with modern data analysis skills! 🎯 Let us transform your worklife.
![](https://ksr-ugc.imgix.net/assets/041/198/835/e5888d441aba6d56cc65db502faa8dfe_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686012467&gif-q=50&lossless=true&s=1793b1762a31dd2de4ff3ada4f7ed08e)
You're wasting time on the job with old skills and old habits 😡
Stop! It's time for a change.
You must learn modern technology to keep up with demand as an employee, boss or entrepreneur.
With just a few videos, you can learn modern tools to automate away all the boring tasks that computers today can do with ease. Put your focus on higher-level, higher-value and interesting tasks. Let AI do the rote work.
![](https://ksr-ugc.imgix.net/assets/041/269/656/75eb026eddda0cb9e3649bce07187b5c_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686591810&gif-q=50&lossless=true&s=9a3241bb53e1afe57d51697597ce2a7d)
Don't get caught up in comfort!
Protect your career from the economic recession by leveling up your skills.
Become a high-value employee by learning how to use AI. You'll speed past everyone else at your workplace. Sorry Bob but AI is coming for my job and I have money to make!
![](https://ksr-ugc.imgix.net/assets/041/220/964/41547358797b87826da2e71e73d42bb4_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686159487&gif-q=50&lossless=true&s=37054f568b7ff108086bb6aa15acb75b)
Don't get intimated by big tech words!
Anyone can learn AI.
These tools were designed to be easy to use. And our courses make it even easier to learn.
🏢💼 Master Microsoft Excel, ChatGPT, and AI and revolutionize your professional life!
![](https://ksr-ugc.imgix.net/assets/041/284/227/29b62a77b6310d4b41655aaf50641bb8_original.gif?ixlib=rb-4.0.2&w=680&fit=max&v=1686683442&gif-q=50&q=92&s=3a222e9b61c245c55252b7840f26a6b3)
This 150+ hour video course bundle is your ticket to a future-proof career! 🎥🎓
- Level 1 🚀👨💻 Excel for Beginners
- Level 2 🧙♂️🎩 Advanced Excel Functions
- Level 3 🤖🔮 Excel VBA & Macros
- Level 4 🗣️🤝 Excel and ChatGPT Integration
- Level 5 🎤💡 Pass the Excel & AI Coding Interview
![](https://ksr-ugc.imgix.net/assets/041/220/952/b0cf1fd91d68e88e979fb88247c8b204_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686159432&gif-q=50&lossless=true&s=9ee9704c5e465bda178c1f8dcd3d5c28)
Excel & ChatGPT - The Power Duo 💪🚀
Excel is the #1 data analysis tool, with over 750 million global users.
ChatGPT, the fastest-growing AI app, achieved 100 million users in just 2 months. 🔥💼 Combine these powerhouses for cutting-edge data analysis, forecasting, and reporting.
![](https://ksr-ugc.imgix.net/assets/041/220/968/e7c16dd21f740ac1838385e9e6ce6b0e_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686159545&gif-q=50&lossless=true&s=61bbabbfabef51e84fd22e315a9e30fc)
AI & Excel Market Success 💲🌍
Microsoft (Excel's creator) boasts a market cap over $2 trillion, and OpenAI (ChatGPT's parent) is valued at around $29 billion.
The AI market is set to reach $150+ billion in 2023, while the spreadsheet software market will grow at a 9% CAGR until 2023. 🎯🏁 Mastering these skills can catapult you to new professional heights!
![](https://ksr-ugc.imgix.net/assets/041/284/376/dc0bb3a9c8d52b6e4923ecec7bb4437b_original.gif?ixlib=rb-4.0.2&w=680&fit=max&v=1686684029&gif-q=50&q=92&s=ec58c553454c81a5bc97e2f1cabb4607)
Learn, or Get Left Behind! 🚀💫
This bundle is beginner-friendly and comes with complete source code!
It’s a step-by-step journey from newbie to Excel and AI wizard. 🎓💥 Unleash your potential today!
Bundle Breakdown 👇
![](https://ksr-ugc.imgix.net/assets/041/237/083/931c7f13c3c05be4c8f63f674cdb8621_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686274486&gif-q=50&lossless=true&s=894e01711996023094422ef10f2f6494)
Level 1 🚀👨💻 Excel for Beginners (5 Hours)
Master Excel, the #1 software for data analytics and business intelligence. 🧙♂️💫Become a data wizard!
- Create practical and beginner-friendly Excel projects (5 Hours)
![](https://ksr-ugc.imgix.net/assets/041/237/088/64b6386f61cd4542b8844913f9e9094b_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686274521&gif-q=50&lossless=true&s=b2894c4da2ce48473b9af3dc815dadf7)
Level 2 🧙♂️🎩 Advanced Excel Functions (40 Hours)
Get hands-on with Excel's advanced features. 🎯🏆 Master powerful data analysis tools like PivotTables, Power Query, and Power BI.
![](https://ksr-ugc.imgix.net/assets/041/244/506/10b115e0ed1a796a4df72ee0102a2484_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686331509&gif-q=50&lossless=true&s=e50e27d453c503ab74d529c0e08c39f5)
- Build PivotTables like a Pro in Excel 🔧 (5 Hours)
- Create Awesome Excel Charts for Visualizing Data 📊 (5 Hours)
- Perform Financial Analysis with Excel 💰 (5 Hours)
- Analyze Data Using Advanced Techniques in Excel 🔍 (5 Hours)
![](https://ksr-ugc.imgix.net/assets/041/244/444/51cf0d318e630355158af53fce0a7384_original.gif?ixlib=rb-4.0.2&w=680&fit=max&v=1686331156&gif-q=50&q=92&s=5840a31590962e2159275d0cc8328a16)
Power Query and M
- Beginners Excel Power Query and M Masterclass 💡 (5 Hours)
- Advanced Excel Power Query and M Masterclass 💡 (5 Hours)
- Power BI: Unleash the Power of Data Visualization 📊
![](https://ksr-ugc.imgix.net/assets/041/237/098/bb21803532442f2d404e6f07aa5017e9_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686274589&gif-q=50&lossless=true&s=4458bc009f1cb8b3a4aff31928acd58d)
Level 3 🤖🔮 Excel VBA & Macros (10 Hours)
Automate Excel tasks with VBA and Macros. 🚀💼 Make your work faster and more efficient.
- Excel VBA Programming and Macros 🖥️ (5 Hours)
- Advanced Excel VBA: Unlocking the Full Potential 🚀 (5 Hours)
![](https://ksr-ugc.imgix.net/assets/041/237/100/5bbafc8ae2dfeeb4d21501c2b3c4bf0a_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686274628&gif-q=50&lossless=true&s=c41d8265bd2db9595177938792b9ec51)
Level 4 - Excel and ChatGPT Integration (100 hours) 🗣️🤝
Integrate ChatGPT with Excel to automate data analysis and reporting tasks. 💫🔥Build AI-powered Excel functions and financial models.
Automate Tasks with ChatGPT (10 Hours)
- ChatGPT 4 AI Prompt Engineering for Entrepreneurs 💼
- Stock Analysis with ChatGPT 📈 (1 Hour)
- Build an Investment Plan with ChatGPT 💰
- Predict Stock Market with ChatGPT 📊
- Risk Analysis of Applicants with ChatGPT 🔒
- Fraud Detection with ChatGPT 🔍
![](https://ksr-ugc.imgix.net/assets/041/198/850/1f767a38fcc056131f7c7f789c1ec808_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686012560&gif-q=50&lossless=true&s=c7d3f5ee7677e6ae58990fdf7bf1fda3)
Build Advanced ChatGPT Projects (15 Hours)
- Generate Social Media with ChatGPT 4 Prompts
- ChatGPT SEO blog post writing
- Generate Emails and Ads with ChatGPT 4 Prompt Engineering
- YouTube Video Production with ChatGPT
- Build Marketing Funnels and Analyze Customers with ChatGPT 4
- Web Development, Branding and eCommerce with ChatGPT 4
- Advanced Business and Excel in ChatGPT
![](https://ksr-ugc.imgix.net/assets/041/244/465/fe64325a37259f57bcf4505cb6228c12_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686331230&gif-q=50&lossless=true&s=bbb9bf13815b1f5c8dca3307c2a68d2f)
Automate Excel with ChatGPT (35 Hours)
- Advanced Business and Excel in ChatGPT
- Advanced ChatGPT for Trainers
- Advanced ChatGPT for Coaching Automation
- Advanced ChatGPT for Social Media Automation
- ChatGPT for C-Level Management
- ChatGPT for Leadership
- ChatGPT for Sales
- PowerBI Automation with ChatGPT
- Sales Analytics and Modeling in Excel with ChatGPT
Data Science
- Data Science with Python and NumPy
- Learn to Graph Data with Python and Matplotlib
- Complete Beginners Data Analysis with Pandas and Python
- Automate Excel Data Manipulation with Python and ChatGPT
- Automate Data Distribution Visualization with ChatGPT and Python
![](https://ksr-ugc.imgix.net/assets/041/285/810/7a65efc694b18bd48038ad8f618a9f33_original.gif?ixlib=rb-4.0.2&w=680&fit=max&v=1686692116&gif-q=50&q=92&s=846d6aa6d4d10452f34692b3e345005c)
Automate Power BI with ChatGPT
- Automate Power BI DAX and M with ChatGPT
- Automate Python Data Visualization in Power BI with ChatGPT
- Automate Python Machine Learning with ChatGPT
![](https://ksr-ugc.imgix.net/assets/041/244/499/7200fdf0e168ccf98b98e666b0fa6871_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686331464&gif-q=50&lossless=true&s=96f2134317e6b17883d8144e668063a3)
ChatGPT for Programmers (25 Hours)
- Learn to program in Python from scratch (5 Hours)
- Build projects with OpenAI API
- Learn JavaScript programming
- ChatGPT 4 for Web Developers - Build an eCommerce Site with JavaScript
![](https://ksr-ugc.imgix.net/assets/041/285/514/69f7b90b8f04e820f24de7b3d48d41c2_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686690034&gif-q=50&lossless=true&s=132a9e464b91210373ffbe8a107666a6)
ChatGPT Prompts for Python Coders
- Build a custom UI ChatGPT clone
- Build a ChatGPT web browser extension
- Build an Audio Transcriber web app with OpenAI's Whisper API
![](https://ksr-ugc.imgix.net/assets/041/237/104/f74f6445bc800e7eccb6556a4c0eba4d_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686274673&gif-q=50&lossless=true&s=62a0cc3808f1ea30d9d58d121dc31891)
Level 5 - Pass the Excel & AI Coding Interview (40 hours) 🎤💡
Ace your dream job interview with practice questions and coding exercises. Become an Excel and AI expert today! 🚀🎯
![](https://ksr-ugc.imgix.net/assets/041/244/494/85a35aa614d0959edf28d9012b5973f8_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686331431&gif-q=50&lossless=true&s=4bc7fe537195b25035ad6ad95f5c5d75)
- Excel to Python Data Science Automation (2 Hours)
- Automate Excel files with Python OpenPyXL (5 Hours)
- Automate web tasks with Selenium Python (5 Hours)
- Build 7 applications in Amazon Honeycode (5 Hours)
- Python SQL Ethereum Data Science with Google BigQuery (5 Hours)
![](https://ksr-ugc.imgix.net/assets/041/284/456/fa9cec6d6ad930c7bd8e61b63567ef70_original.gif?ixlib=rb-4.0.2&w=680&fit=max&v=1686684387&gif-q=50&q=92&s=c4262add72509d7a23ce54114535811b)
Build Machine Learning Projects
- Beginner Data Science and Machine Learning Bootcamp
- Machine Learning Fundamentals (1 Hour)
- Data Engineering and Machine Learning Masterclass (1 Hour)
- Build Machine Learning Models
- Build beginner artificial intelligence projects (2 Hours)
- Data science with stocks, Excel and machine learning (5 Hours)
- Ace the Python Coding Interview (5 Hours)
- Machine Learning Interview Questions (5 Hours)
![](https://ksr-ugc.imgix.net/assets/041/244/514/b61d3bb09e142e3b9292006c802645b7_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686331537&gif-q=50&lossless=true&s=c18a3ce470d734eb89a3011090fb0725)
💪🚀 Supercharge your Excel: ChatGPT and AI Integration 🧩🔝
Ever imagined the extraordinary power of combining Excel, the world's most powerful data analysis tool, with the super-intelligent AI ChatGPT? 😮🔥
That's what we're offering in this comprehensive course bundle! When you unite Excel and ChatGPT, you can automate complex tasks, perform advanced data analysis, and create stunning visualizations, all in record time! 🚀🧩
![](https://ksr-ugc.imgix.net/assets/041/198/875/71b13056a7d4cac53071da26dc1ed4e6_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686012737&gif-q=50&lossless=true&s=97f538ef96c9d0d5b5e5b827bd18e2d1)
Imagine:
- making data-driven decisions effortlessly
- forecasting trends with unmatched accuracy
- generating insightful reports that make your clients and colleagues look at you with newfound respect. 😮💼
![](https://ksr-ugc.imgix.net/assets/041/285/517/b8fd93a33fd2e95f4db68f0e536e413e_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686690090&gif-q=50&lossless=true&s=60ddbfeae29b6cce7a8b62defec10215)
Integration of ChatGPT with Excel can turn mere spreadsheets into robust, AI-powered engines capable of not just crunching numbers but also providing:
- actionable insights
- predictive modelling
- text-based analysis. 📈🔍
![](https://ksr-ugc.imgix.net/assets/041/221/003/c1ab63afe8e6e260a777b6a5236e3b92_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686159746&gif-q=50&lossless=true&s=1d96050af28d249aa33c3e6d65d212dd)
🎁🎉 More Money, More Opportunities, More Freedom 🚀💰
By mastering these skills, you will not only improve your work efficiency but also open doors to new career opportunities.
Companies are always on the lookout for professionals who can handle data efficiently and generate valuable insights from it. By knowing how to integrate ChatGPT with Excel, you become an indispensable asset for any forward-thinking organization. 🏢🚀
![](https://ksr-ugc.imgix.net/assets/041/244/470/7d4d3a03cd3b6aaee9aace5aab89ab0a_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686331253&gif-q=50&lossless=true&s=95bf5e8de5aa15e573729d40cba90429)
Professionals skilled in AI and Excel can command higher salaries and enjoy greater job security.
According to Payscale, Excel experts earn an average of $100k per year, while AI specialists' salaries often exceed $150k. With both skills under your belt, you're looking at a prosperous and secure future. 💰🔝
And this is not just about money. It's about freedom. Freedom to choose exciting projects. Freedom to work in sectors that inspire you. Freedom to innovate. When you're in-demand, you have choices. 💪🎯
![](https://ksr-ugc.imgix.net/assets/041/285/525/efe2864d0874e6a05e1d0befb800ee14_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686690123&gif-q=50&lossless=true&s=7e0c4ed3555fec6dd34bc9c2032a9847)
This course is not just an investment in your skills.
It's an investment in your future. Take the leap and become a master of Excel, ChatGPT, and AI. Your journey to success starts here. 🚀💫
![](https://ksr-ugc.imgix.net/assets/041/221/009/cedf9ec8c36a72264d32d15423464cbc_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686159769&gif-q=50&lossless=true&s=8cb64f2de90f6903c15d4efdc63f7b6e)
💼📈 Revolutionize Your Business with Excel, ChatGPT, and AI 🚀🎯
In the era of data-driven decision-making, integrating Excel with ChatGPT and AI can revolutionize your business operations. Imagine the powerful insights you can derive, the efficiency you can achieve, and the profits you can drive. 📊🎯
Excel, when combined with the power of ChatGPT and AI, can provide unparalleled capabilities! 🧠🔥
![](https://ksr-ugc.imgix.net/assets/041/221/022/35065f02a5d1db6a36fb4bbfa5dbc094_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686159838&gif-q=50&lossless=true&s=8bd6c73552eada48deba5b869cf786fb)
🔹 Automate Tasks
Automate mundane and repetitive tasks like data entry and report generation, freeing up time for strategic decision-making. You can even use ChatGPT to draft emails, create meeting agendas, and more. ⏲️🔄
🔹 Data Analysis and Insights
Leverage AI to extract valuable insights from large datasets in Excel. Predict trends, understand customer behavior, and make data-backed decisions that drive growth. 📊🚀
![](https://ksr-ugc.imgix.net/assets/041/237/138/71b362b62b0b1d2c06f1a14c2ee8e594_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686275051&gif-q=50&lossless=true&s=46cdb8a86da82914900c1bd636ac2ed0)
🔹 Financial Modeling
Use AI to build sophisticated financial models and perform advanced risk analysis. Make smarter investment decisions and plan your financial future with confidence. 💰🔒
🔹 Marketing Strategy
Analyze customer data to understand trends and preferences, enabling targeted marketing and personalized customer experiences. Increase customer satisfaction and boost your brand's image. 🎯🌐
![](https://ksr-ugc.imgix.net/assets/041/221/062/03b0c24073313d6e0b7fa4d5b685964d_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686160099&gif-q=50&lossless=true&s=0dd4addd426d43327df68ce50b9a611f)
🔹 Supply Chain Management
Use AI and Excel to manage inventories, predict demand, and optimize logistics. Cut costs, reduce waste, and improve efficiency. 📦🔀
🔹 Human Resources
Streamline recruitment, performance tracking, and employee engagement using AI-powered data analysis in Excel. Attract the best talent and keep them motivated and productive. 👩💼🔝
And much more! With the power of Excel, ChatGPT, and AI, your business can thrive like never before. Stand out from the competition, deliver exceptional value to your clients, and drive success on your own terms.💪🏆
Join us in this game-changing journey! The future of business is here, and you're invited. 🎉🚀
![](https://ksr-ugc.imgix.net/assets/041/199/060/0660358609e6233bc0a7ceeca2af7cec_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686014294&gif-q=50&lossless=true&s=9cf00b732900acef68381fd1033e1703)
We'll walk you through, step-by-step how to get all the software installed and set up.
Ready to start your journey? 🚀🌍
Sign up today and in 99 days, learn to build 1 project per day. This is how you master Excel & AI. Let's start your journey towards becoming a data wizard! 💪🎓
![](https://ksr-ugc.imgix.net/assets/041/221/066/96d43595cfcae0fcadd2956fa2ad47e3_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686160139&gif-q=50&lossless=true&s=73bd01ca85e8c5cc711adc18eac63678)
All Pledge Tiers are STACKING
- Receive more and more courses and resources with each pledge tier
- Customize your learning experience by selecting the topics and modules that interest you most
- Benefit from exclusive bonuses, resources, and support for higher pledge tiers
Testimonials
![](https://ksr-ugc.imgix.net/assets/041/160/225/d24e2b329bc827a5f73a6f38e152ae3b_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1685663061&gif-q=50&lossless=true&s=f11a0c7f20a55cf38b13b80474c8397c)
Collection of reviews from various Mammoth Interactive courses.
📦 Sign up today, and look forward to:
- HD Video Lectures
- Easy to view on mobile
- Source files
- Fully Fledged Projects
- Resources and Downloads
![](https://ksr-ugc.imgix.net/assets/041/199/070/160d2f933680ef312e16839507417bf5_original.png?ixlib=rb-4.0.2&w=680&fit=max&v=1686014364&gif-q=50&lossless=true&s=756c008de55e47bebfc82724bc5d3e23)
Frequently Asked Questions
How do I obtain a certificate?
Each certificate in this bundle is only awarded after you complete every lecture of the course.
Many of our students post their Mammoth Interactive certifications on LinkedIn. Not only that, but you will have projects to show employers on top of the certification.
Is this an eBook or videos?
The majority of this bundle will be video tutorials (screencasts of practical projects step by step.) You will also get PROMPTS, PDFs and ALL SOURCE FILES!
Can't I just learn via YouTube?
YouTube tutorials prioritize clickbait, shock factor, and hacking the recommendation algorithm. This makes it hard to find quality content.
Our online courses are completely about education. You'll be taken from absolute beginner to advanced programmer. With no ads, clickbait or shock factor.
This bundle is much more streamlined and efficient than learning via Google or YouTube. We have curated a massive curriculum to take you from zero to starting a high-paying career.
How will I practice to ensure I'm learning?
With each section there will be a project, so if you can build the project along with us you are succeeding. There is also a challenge at the end of each section that you can take on to add more features to the project and advance the project in your own time.
Requirements
This is a massive bundle with different requirements for various courses. In each course, you will be informed of requirements.
You will need an Internet connection to watch lectures. You can download lectures for offline access via the Teachable mobile iOS app.
To follow along with the Excel sections of this Mega Bundle, you will need a free trial or purchase of the Microsoft Excel desktop application.
To build Pivot Tables in Microsoft Excel or use Power Query / Power BI, you will need Excel on a Windows computer or Windows Virtual Machine.
To follow along with the ChatGPT or OpenAI API sections of this Mega Bundle, you will need to sign up for a free ChatGPT account online at chat.openai.com.
To use the OpenAI API for calling GPT models programmatically, you will need to use free trial tokens or paid tokens.
To follow along with the Python sections of this Mega Bundle, you will need to sign up for a free Google Account to code online at Google Colab. Alternatively, you can select your preferred platform for executing Python code.
To follow along with the JavaScript sections of this
bundle: you can use a free online code editor like JSitor or download a
free offline code editor desktop application, such as Visual Studio
Code, VSCodium or Atom.
To follow along with the Browser Automation with Selenium sections of this Mega Bundle, you will need a free download of ChromeDriver installed on your computer.
To follow along with the Google BigQuery sections in this bundle, you will need a free trial or paid subscription to Google Cloud, which requires signing up for an account with your credit card information. You will also need free or paid credit to make API calls.
Requirements differ for students in restricted countries such as China. Email our support team with any inquiries.
This course bundle is for educational purposes. You are responsible for download or purchase of software required. This bundle does NOT entitle you to ownership of software.
Your Instructor
James Dabalus is a skilled Prompt Engineer with an extensive technical and creative background. James has built many courses with Mammoth Interactive on ChatGPT and Midjourney artificial intelligence tools, front-end web development, graphic design, and video editing.
Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more.
Over 12 years, Mammoth Interactive has built a global student community with 5 million courses sold. Mammoth Interactive has released over 300 courses and 3,000 hours of video content.
Founder and CEO John Bura has been programming since 1997 and teaching since 2002. John has created top-selling applications for iOS, Xbox and more. John also runs SaaS company Devonian Apps, building efficiency-minded software for technology workers like you.
Course Curriculum
-
StartSource Files
-
Start1.1 Introduction to the Course (8:47)
-
Start1.2 Introduction of the instructor (3:30)
-
Start1.3 Course requirements (4:04)
-
Start1.4 How to get Excel (9:33)
-
Start2.1 What will we learn in this section (1:33)
-
Start2.2 Create An If() Function (3:24)
-
Start2.3 Nest And() Andor Or() Functions Within Reference Functions (6:37)
-
Start2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions (6:19)
-
Start2.5 Create A Vlookup() Function (3:32)
-
Start2.6 Section Summary (9:37)
-
Start3.1 What will we learn in this section (2:23)
-
Start3.2 Aggregate Data Using Both The Sum And Subtotal Functions (5:15)
-
Start3.3 Calculate minimums, maximums and averages from data sets (3:39)
-
Start3.4 Use the Forecast function to forecast numbers along a trend (6:57)
-
Start3.5 Generate a net present value using a formula (6:13)
-
Start3.6 Section Summary (7:38)
-
Start4.1 What will we learn in this section (1:14)
-
Start4.2 Work with Excel’s date manipulation functions (10:10)
-
Start4.3 Build a holiday date calculator (6:09)
-
Start4.4 Section Summary (4:43)
-
Start5.1 What will we learn in this section (3:46)
-
Start5.2 Split textual data apart (4:00)
-
Start5.3 Manipulate textual data (5:47)
-
Start5.4 Replace portions of textual data (4:42)
-
Start5.5 Put textual data back together with formulae (6:18)
-
Start5.6 Work with key informational functions for evaluating and responding correctly to errors in routine Excel calculations (12:00)
-
Start5.7 Use the Hyperlink function to build navigational menus inside an Excel Worksheet (4:35)
-
Start5.8 Section Summary (6:26)
-
Start6.1 What will we learn in this section (4:08)
-
Start6.2 How to filter items in a list (8:24)
-
Start6.3 Sorting List without messing up the data (10:09)
-
Start6.4 How to freeze rows or columns (9:53)
-
Start6.5 Remove duplicates from a list (6:52)
-
Start6.6 Section Summary (6:32)
-
Start7.1 What will we learn in this section (2:09)
-
Start7.2 COUNT, COUNTA and COUNTIF Functions (11:57)
-
Start7.3 Create a drop down list (11:38)
-
Start7.4 Work with ISNUMBER and SEARCH functions within text functions (11:19)
-
Start7.5 Format row based on a cell value (10:54)
-
Start7.6 Create an invoice template in Excel (24:17)
-
Start7.7 Section Summary (4:46)
-
Start8.1 Course Summary and Next Steps (23:32)
-
StartSource Files
-
Start1.1 Introduction To The Course New (3:43)
-
Start1.2 Why Should You Learn Pivottables New (3:17)
-
Start1.3 Introduction Of The Instructor New (3:17)
-
Start1.4 Course Requirements (what Software, Experience) New (6:10)
-
Start2.1 What We Learn In This Section (1:21)
-
Start2.2 What Is A Pivot Table (2:01)
-
Start2.3 Pivottables Basics (2:52)
-
Start2.4 Pivottable Compliant Data Sources (2:12)
-
Start2.5 Build A Basic Pivottable (4:17)
-
Start2.6 Section Summary (2:13)
-
Start2.7 Challenge (1:23)
-
Start3.1 What Will We Learn In This Section (1:01)
-
Start3.2 Introduction To Formatting Pivottables (3:30)
-
Start3.3 Build An Expense Report (6:03)
-
Start3.4 Format The Expense Report Pivottable (4:18)
-
Start3.5 Finalize The Expense Report Pivottable (5:41)
-
Start3.6 Section Summary (2:12)
-
Start3.7 Challenge (1:04)
-
Start4.1 What Will We Learn In This Section (8:46)
-
Start4.2 What Are Excel Tables (7:23)
-
Start4.3 Sales Report Analysis With Pivottables (9:22)
-
Start4.4 Modify Source Data (3:58)
-
Start4.5 Format The Sales Report (8:38)
-
Start4.6 Complete The Sales Report Analysis (3:38)
-
Start4.7 Section Summary (3:03)
-
Start4.8 Challenge (1:47)
-
Start5.1 What Will We Learn In This Section (1:23)
-
Start5.2 What Is Slicing Data (3:41)
-
Start5.3 Slicing Data Project (5:40)
-
Start5.4 Data Slicer Tools (14:09)
-
Start5.5 Link Slicers To Multiple Pivottables (8:03)
-
Start5.6 Section Summary (2:32)
-
Start5.7 Challenge (2:04)
-
Start6.1 What Will We Learn In This Section (2:30)
-
Start6.2 Connect To Databases (2:06)
-
Start6.3 Import Data Sources (3:58)
-
Start6.4 Use Pivottables To Refine Data (4:41)
-
Start6.5 Consolidate Your Data Table (3:17)
-
Start6.6 Format Large Data Sets (4:51)
-
Start6.7 Slicer And Timeline In Large Data Sets (4:36)
-
Start6.8 Refresh And Drill Down From Databases (4:46)
-
Start6.9 Section Summary (4:01)
-
Start6.10 Challenge (2:02)