Curriculum
12 Sections
117 Lessons
14 Weeks
Expand all sections
Collapse all sections
Basic Of Computers
4
1.1
Typing Practice
1.2
Introduction to Windows 11
1.3
Computer shortcut keys
1.4
Folders & File creation
Ms Word 365
15
2.1
Getting Started with Word
2.2
Text Basics
2.3
Formatting Text
2.4
Saving
2.5
Modifying Page Layout
2.6
Checking Spelling and Grammar
2.7
Printing
2.8
Using Indents and Tabs
2.9
Line & Paragraph Spacing
2.10
Working with Lists
2.11
Adding Breaks
2.12
Working with Columns
2.13
Working with Hyperlinks
2.14
Working with Shapes
2.15
Text Boxes and WordArt
Ms Excel 365 / Spread Sheets
21
3.1
Getting Started with Excel
3.2
Cell Basics
3.3
Modifying Columns, Rows, and Cells
3.4
Formatting Cells
3.5
Saving
3.6
Creating Simple Formulas
3.7
Worksheet Basics
3.8
Printing
3.9
Creating Complex Formulas
3.10
Working with Basic Functions
3.11
Sorting Data
3.12
Outlining Data
3.13
Filtering Data
3.14
Formatting Tables
3.15
Reviewing and Sharing Workbooks
3.16
Using Templates
3.17
Working with Charts
3.18
Working with Sparklines
3.19
Using Conditional Formatting
3.20
Creating PivotTables
3.21
Using What-If Analysis
Ms Power Point 365 / Presentation
8
4.1
Managing the PowerPoint Environment
4.2
Creating a Slide Presentation
4.3
Working with Graphical and Multimedia Elements
4.4
Creating Charts and Tables
4.5
Applying Transitions and Animations
4.6
Collaborating on Presentations
4.7
Preparing Presentations for Delivery
4.8
Delivering Presentations
Using Internet & Chat GPT
6
5.1
Surfing on Internet
5.2
Searching on internet
5.3
Creating E-mail Accounts
5.4
Sending & Receiving Mails
5.5
Sending & Receiving Documents
5.6
ChatGPT & Gemini AI
Advanced Excel
38
6.1
Quick review on MS Excel Options, Ribbon, Sheets
6.2
Saving Excel File as PDF, CSV and Older versions
6.3
Using Excel Shortcuts with Full List of Shortcuts
6.4
Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
6.5
Using Paste Special Options
6.6
Formatting Cells, Rows, Columns and Sheets
6.7
Advanced Filtering in Excel
6.8
Grouping & Subtotal in Excel
6.9
Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
6.10
Page Layout and Printer Properties
6.11
Working with Formulas / function
6.12
Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
6.13
Database Functions
6.14
Date & Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY
6.15
Information Functions
6.16
Math & Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, EVEN, SUMIF
6.17
Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK,COUNTIF, MAX, MAXA,MIN, MINA, STDEVA
6.18
Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE.
6.19
Conditional Formatting
6.20
Using Conditional Formatting
6.21
Using Conditional Formatting with Multiple Cell Rules
6.22
Using Color Scales and Icon Sets in Conditional Formatting
6.23
Creating New Rules and Managing Existing Rules
6.24
Data Lock & Protection
6.25
Advance Charts in Excel
6.26
Area Charts and Surface Charts
6.27
Trend line Charts and Candle Stick
6.28
Charts and Pie Charts
6.29
XY (Scatter Charts)
6.30
Time Series Charts and Bubble Charts
6.31
Radar Charts and Doughnut Charts
6.32
Rotating 3D Excel Charts
6.33
Working with Fill Series & Go to Special
6.34
Consolidation in Excel
6.35
What if Analysis in Excel
6.36
Goal Seek
6.37
Scenario Manager
6.38
Data Table
AI Automation with Excel
4
7.1
Working with Histogram
7.2
Helps in summarize discrete or continuous data
7.3
Helps in identifying the most efficient pricing plans in sales & marketing, It will determine the issues with a certain process
7.4
Calculating peak time hours in restaurants & Hospitals
Regression Analysis in Excel
5
8.1
To Measure the Effectiveness of the Marketing Campaigns, Pricing, And Promotions On Sales Of A Product
8.2
Used To Analyse Categorical Data
8.3
Commonly Used In Understanding Customer Behaviour
8.4
To Understand the Relationship between a Company’s Stock Price & The Company’s Quarterly Earnings
8.5
Credit Risk Assessment
Creating Automation Tools With Excel Scripts
6
9.1
Creating Automation Tools With Excel Scripts
9.2
Create A Workbook Table Of Contents
9.3
Run A Script On All Excel Files In A Folder
9.4
Copy Multiple Excel Tables Into A Single Table
9.5
Generate An Automated Sales Summary Using Pivot Tables
9.6
Create, Sort, & Format A Table Automatically In Excel
Working With Forecasting
5
10.1
Sales Forecasting
10.2
Demand Forecasting
10.3
Forecasting For Decision Making
10.4
Being Able To Generate Scenarios – Optimistic, Pessimistic
10.4
Know How To Capture Information About Significant Market Events.
Solving Complex Data Using The Power Query In Excel
0
Professional Dashboards In Excel
5
12.1
Interactive Sales Dashboard In Excel
12.2
Bank & Marketing Dashboard
12.3
Interactive HR Dashboard In Excel
12.4
Project Management Dashboard In Excel
12.4
Call Centre Dashboard In Excel
Computer Basics & Advanced Excel with AI
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Your Website
Modal title
Main Content
