Get everything you need to start your data journey! This bundle includes 5 beginner-friendly courses: Excel with AI & ChatGPT, Power BI, VBA Macros, and Python & SQL
In demand. 54 people bought this in the last 24 hours.
This course covers basic to advanced topics, which are taught by different subject matter experts.
Elevate your chatbot’s performance with our 33-video Prompt Engineering Mastery Course
Access over 1500+ AI tools Master List to supercharge your projects
After this course, you’ll have complete clarity on chatgpt.
No matter what you know, this course teaches you from basic terms to advance levels.
With this course you learn each and every aspect of chatgpt.
Creating, saving, renaming, copying, grouping, moving, and viewing multiple sheets/workbooks
Entering text/numbers/dates, formatting cells, merging/wrapping, fonts, colors, alignment
Basic math, IF, SUMIF, COUNTIF, TEXT, DATEIF, BOOMAS, IFERROR, referencing (absolute/3D)
Displaying formulas, formula text, copying formulas, watch window, named ranges
Sorting, filtering, removing duplicates, find/replace, text to columns, data validation, flash fill
Creating charts, formatting chart elements, trendlines, sparklines, quick/recommended charts
Creating, using, referencing pivot tables, drilling down, managing pivot data
Creating tables, using fill handle, autofill lists, pick lists, custom styles
Rules, icon sets, color scales, top/bottom rules, custom formatting
Print areas, titles, margins, orientation, scaling, headers/footers, controlling print settings
Inserting static/dynamic dates, time calculations, duration over 24 hours
Worksheet protection, password-protecting workbooks, locking data entry areas
Shapes, SmartArt, screenshots, inserting images, formatting objects
Ctrl keys, ribbon shortcuts, drag/drop, customizing toolbar & ribbons
Comments, spell check, sharing files, SkyDrive, tracking changes
Using and creating templates, applying themes
Goal Seek, What-If scenarios, scenario manager, watch window
Displaying file/sheet names, using layout/page break views
Hyperlinks, SmartArt, fill handle, format painter, autofill, object grouping
Learn how to manage macro security, assign macros to ribbons, and set up a personal macro workbook.
Create and customize your own ribbon and buttons for quick macro access.
Understand how to create, record, and run your first macro, plus design triggers like buttons or keyboard shortcuts.
Use MSGBOX
, INPUTBOX
, and UserForms
for user input and interaction within your macros.
Master debugging techniques, error handling, and using the Visual Basic Editor to refine your code.
Learn to manipulate arrays, ranges, and data formatting, plus work with Excel’s data functions.
Use IF-ELSE
, SELECT CASE
, DO WHILE
, and FOR NEXT
loops to control the flow of your program.
Design UserForms with controls like buttons and text boxes to collect and validate user input.
Declare and manage variables, set their scope, and use constants for fixed values.
Trigger macros through keyboard shortcuts, ribbon icons, and workbook or worksheet events.
Create and call functions and sub procedures to improve code organization and reuse.
Automate actions with events like opening, saving, and activating sheets.
Manipulate cell data and formatting using Range methods like OFFSET
and FONT
.
Use Excel functions in VBA and learn how to apply operators for calculations and comparisons.
Optimize your code for speed and efficiency using tips like relative vs. absolute referencing.
Introduction to Data Analysis
Master Excel for Data Analysis
Managing and Analyzing Data
Sorting Data
Creating Automatic Subtotals in Sorted Lists
Filtering Data
Advanced Filtering
Eliminating Duplicate Data
Master SQL for Data Analysis
SQL Installation
SQL Overview
Fundamental Concepts
Relationships
Strings
Numbers
Dates & Time
Aggregates
Transactions
Indexes
Views & Subselects
CRUD Applications
Data Reporting and Analysis in SQL
Use SQL to Report ROI
Grouping Your SQL Results
Merge Data from Multiple Tables
More Advanced SQL
Introduction
Data Analysis with Python
Statistical Operations in Python
Hands-on Data Analysis Practice with Python
Introduction & Setup
Data Prep & Transformation
Modeling & DAX Basics
Advanced DAX & Time Intelligence
Report Creation & Navigation
Interface & Data Preparation
Enriching Data & DAX
Time Intelligence & Advanced DAX
Final Report & Insights
CALCULATE Function
Using Filters & Time Intelligence
Advanced DAX & Sales Analysis
Custom Visuals & Publishing
DAX & Interview Tips
Customer Insights & Sales Thresholds
Course Intro
Tableau Files
Tableau Basics
Data Connection
Workspace & Views
Multiple Data Sources
Exercises
Chart Types
Building Views
Histograms & Scatter Plots
Spatial Charts & Dashboards
Publishing & Sharing
Exercises
Expressions
Numeric & String Calculations
Conditional & Analytical Functions
Exercises
Advanced Techniques
Parameters
Level of Detail & Groups
Geospatial & Advanced Filters
Table Calculations
Actions & Animation
Advanced Charts
Geospatial & Marketing Dashboards
Sales Dashboard
Exercises – Practice advanced concepts
WhatsApp us