Course Overview
**This course includes practice exercises and LIFETIME access**
Learn Computer Basics , MS Word, Excel, PowerPoint and System Maintenance with this tremendous value 4-course bundle from Office expert Ravi.
Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential.
We’re here to make sure you aren’t one of those people.
In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Computer Basics) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals.
Do you or someone you know understand little to nothing about how to use a computer? Ever wonder what computer terms like virus, mouse, keyboard and antivirus mean? What about all of this downloading and the internet? If you are not sure about those terms or think you may want to know more, this is for you!
You hear people talking about all of these weird terms like the Windows Desktop, the start menu and the dreaded virus! You will learn what all of that means in simple, easy to understand terms and actual demonstrations.
We will learn the basics of using a computer bit by bit. Each section will be a different computer topic and there will be several lessons in each section. We will learn about using your computer, computer parts such as the mouse, monitor, keyboard, USB and Ethernet as well as topics such as computer security, the internet, problems and troubleshooting as well as a few more advanced topics
FAQ
FAQ area empty
Course curriculum
-
1. What is Computer, Definition, Main Parts
490 Xem trước -
2. Computer Input and OutPut Devices
109 Xem trước -
3. Windows-10 Icons Settings - Enabling and Disabling Icons on Desktops
345 Xem trước -
4. Windows-11 Icons Settings - Enabling and Disabling Icons on Desktops
179 -
5. Windows-10 Taskbar Management
136 Xem trước -
6. Windows-10 Notification Area Settings
207 Xem trước -
7. Windows-11 Taskbar Management
364 Xem trước -
8. Windows-10 How to Change Desktop Background, Set Picture, Solid Color and Sli
454 -
9. Windows-11 How to Change Desktop Background
364 -
10. Themes vs Contrast Themes
134 Xem trước -
11. Windows-11 Languages I Windows Language and Keyboard Language
232 -
12. How to Create Files and Folders
168 -
13. Delete Functions - Temporary and Permanent Delete
213 -
14. How to Check System Configuration, CPU, Ram, HDD, Background Application and
325 -
15. Device Manager - Learn How to Enable and Disable Devices of a Computer
140 -
16. Account Login Settings - Enable and Disable Security
267 -
17. System Cleanup - Temp, Recent, Recycle bin cleaning
361 -
18. How to Calculator - Different type of calculations
173 -
19. How to Launch Paint and Painting Tools
138 -
20. How to Make Partitions in Disk Drives
278 -
21. How to Create Multiple Folders and Sub Folders W10-W11
228 -
22. How to Hide Folders, Change Folder Icons
155 -
23. How to Hide - Unhide Files using run command
121 -
24. Scheduel ShutDown - AutoShutDown - TimerShutDown
251 -
25. Set Default Program to launch documents
183 -
26. Customize Mouse
213 -
27. F1 to F12 Shortcut Keys
125 -
28. Windows Shortcut Keys
140 -
29. ADD PREFIX TO MULTIPLE FILES
110 -
Download Course Material Here
-
Computer Basics Quiz
-
1. Microsoft Word - Launching
283 -
2. MS Word - User Interface.mp4
404 -
3. MS Word English - Save and Save As.mp4
221 -
4 Home Tab -English Font Group Commands NEW
753 -
5 MS Word-Bullets and Numbering
227 -
6. Microsoft Word - MultiList Level
376 -
7. Microsoft Word Text Alignments - Line and Paragraph Spacing.mp4
199 -
8. Microsoft Word - SORT Command Functionality
121 -
9. Microsoft Word - Color Shading and Text Borders
164 -
10. MS Word - Text Styles and Table of Contents I known as Index
667 -
11. MS Word - Find and Replace
204 -
12. MS Word - Copy Paste Functions.mp4
325 -
13. MS Word - Insert Tabe - Pages Group - Page Cover and Blank Page and Page Br
283 -
14. MS Word - Table - All Table Tools Explained.mp4
1358 -
15. MS Word - Insert Pictures and Edit Pictures
501 -
16. MS Word - Shapes, Icons, 3D Models Explained
324 -
17. MS Word - Smart Art, Charts and Screenshot utilities
373 -
18. MS Word - Links to WebPages
228 -
19. MS Word - Links to Existing Files
275 -
20. MS Word-Book Marks and HyperLinks
280 -
21. MS Word-Comments
293 -
22. MS Word-Headers Footers and Page Numbers
368 -
23. MS Word-How to Insert Obejects
332 -
24. MS Word-Symbols
180 -
25. MS Word-Insert Text from File
98 -
26. MS Word-WaterMarks
240 -
27. MS Word-LayoutTab-Page Margins, Orientation, Size, Columns, Hyphanesation an
360 -
28. MS Word-Layout-Paragraph Indent, Spacing-Backward-Forward
190 -
29. MS Word-Page Borders, Page Colors
347 -
30. MS Word- Mail Merge - Complete Process with Real Time Mails and Documents
557 -
31. MS Word-Review-Spelling and Grammar-Set Proofing Language
296 -
32. MS Word-Review-Thesaurus and Word Count
195 -
33. MS Word-Review-Auto Correct and Short Forms
203 -
34. MS Word-Review-Check Accessibility
175 -
35. MS Word-Review-Translate
132 -
36. MS Word-Review- Disable Auto-Hyper Links
87 -
37. MS Word-Review-Track Changes
289 -
38. MS Word-View Tab Commands
392 -
39. MS Word-Protection-Document Protection and Data Protection
233 -
MS Word Quiz
-
40 How to Add ChatGPT to Microsoft Word Install & Use ChatGPT in MS Word – Step
161 -
41 How to Generate Content Using ChatGPT AI Content Writing for Beginners – Com
188 -
42 How to Edit and Modify Existing Documents Using ChatGPT AI Document Editing
184 -
43 How to Install QuillBot Add-in in Microsoft Word Use QuillBot for Grammar &
143
-
Download Practice Excel Files Here
-
E1.1 How to Launch MS Excel
186 -
E1.2 Start Screen - Back Stage Screen - Navigating MS Excel
269 -
E1.3 User Interface - Navigating MS Excel Workbook Screen
484 -
E1.4 Home Tab - Basic Editing Tools
685 -
E1.5 Copy and Paste I using Multiple Tools in MS Excel
706 -
E1.MS Excel - Start-up
-
E2.1 Customize Ribbon Bar – Tabs, Groups, Commands I Tools
296 -
E2.2 Text to Column – Multiple methods
446 -
E2.3 Speak Cells – Data Reading Tool
240 -
E2.4 Comments - Add, Edit, Delete, Copy Paste, Background change
503 -
E2.5 Filters in MS Excel
264 -
E2.6 Freeze Panes and Split Window
281 -
E2.– Basic Tools to Know
-
E3.1 Fill Series - Basics
208 -
E3.2 Fill Series - Advanced
457 -
E3.3 Fill Series - Flash Fill
326 -
E3.4 Conditional Formatting
249 -
E3.5 Hyperlinks to Sheets, Web pages, Files
541 -
E3.6 Header and Footer Settings
506 -
E3.7 Printing and Paper Settings
350 -
E3.8 Import Data from Web
347 -
E3.9 Import Data from Text File with Auto Refresh
189 -
E3.10 Import Objects into Excel
484 -
E3.3- Fill Series and Data, Sheet Control
-
E4.1 Characteristics of a cell
106 -
E4.2 Cell References – Relative Ref, Absolute Ref, Mixed Ref
839 -
E4.3 Custom View
242 -
E4.4 Sheet protection
338 -
E4.5 Cell Protection
289 -
E4.6 Compare sheets side by side I View Sheets side by side
315 -
E4.7 Compare sheets from Multiple Files
158 -
E4.8 Working with cells, rows, columns, Specific Size, Auto Fit
568 -
E4.9 Working with sheets rename, colour, copy, move, grouping
428 -
E4.Working with Sheets in MS Excel
-
E5.1 Things to remember before starting formulas
582 -
E5.2 SUM
532 -
E5.3 SUMIF
352 -
E5.4 SUMIFS
524 -
E5.5 SUBTOTAL
284 -
E5.6 AGGREGATE
188 -
E5.7 SUMPRODUCT
234 -
E5.8 SUMSQ
205 -
E5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry
486 -
E5.10 DSUM - DATA BASE SUM
247 -
E5.11 IMSUM vs IMSUB – Complex Data Calculations
211 -
E5.Sum Related Formulas"
-
E6.1 AVERAGE
84 -
E6.2 AVERAGEA
163 -
E6.3 AVERAGEIF vs AVERAGEIFS
329 -
E6.4 Weighted Average with VBA Code
260 -
E6.Average vs AverageIFS"
-
E7.1 COUNT, COUNTA, COUNTBLANK
185 -
E7.2 COUNTIF vs COUNTIFS
299 -
E7.Count Related Formulas
-
E8.1 LOGICAL TEST with Comparative Operators
220 -
E8.2 IF
363 -
E8.3 IF AND vs IF OR
304 -
E8.4 IFS vs NESTEDIF
438 -
E8.5 IFERROR
217 -
E8.6 SWITCH
327 -
E8.Logical IF-Related Formulas in MS Excel
-
E9.1 LEFT, RIGHT, MID and LEN
286 -
E9.2 FIND vs SEARCH
134 -
E9.3 REPLACE vs SUBSTITUTE
324 -
E9.Text Extraction and Manipulation
-
E10.1 CONCAT vs CONCATENATE
134 -
E10.2 TEXT
547 -
E10.3 UPPER, LOWER, PROPER
69 -
E10.4 TRIM
64 -
E10.5 SPELLNUMBER with VBA code
251 -
E10.6 TEXT-TO-NUMBER with VBA code
135 -
E10.Text Formatting and Conversion
-
E11.1 Using TODAY, NOW
199 -
E11.2 DATE, DATEVALUE, TIME, TIME VALUE
502 -
E11.3 DATEDIF AND EXTRACT YEARS, MONTHS, DAYS, HOURS, MIN, SECONDS
453 -
E11.4 Calculating Future and Past Dates -EDATA, EOMONTH, WORKINGDAYS, NET WORKIN
505 -
E11.5 Calculate Days using – DAY, DAYS, NETWORKING DAYS
144 -
E11.6 Calculate Hours and Hourly Charges
287 -
E11.Date and Time Related Formulas - MCQs
-
E12.1 PMT – EMI Calculator
300 -
E12.2 PPMT, IPMT – Loan Statement Preparation
1108 -
E12.3 FV – Investment Calculator
240 -
E12.Finance Related Formulas
-
E13.1 VLOOKUP – Basics - Rules - Exact Match - Approx Match
663 -
E13.2 HLOOKUP – Basics
137 -
E13.3 XLOOKUP Function - with VBA Code
229 -
E13.4 MATCH Function vs INDEX Function
315 -
E13.5 VLOOKUP-Advanced-1-Applying across multiple cells at a time
156 -
E13.6 VLOOKUP-Advanced-2-Applying across multiple sheets
181 -
E13.7 VLOOKUP-Advanced-3-Applying on large data
584 -
E13.8 VLOOKUP-Advanced-4-Applying across multiple workbooks
579 -
E13.DATA SEARCH - Lookup related formulas
-
E14.1 Pivot Table Basics
343 -
E14.2 Pivot Table Basics - common mistakes
364 -
E14.3 Pivot Tables - Advanced Tips
508 -
E14.4 How to Combine Multiple Sheet Data into One
422 -
E14.5 Pivot Table on Multiple Sheets, Workbooks
214 -
E14.Pivot Table & Lookup Formulas in Excel
-
E15.1 MS Excel Charts - Basics - Insert, Data Control, Improve Chart, Change Ser
742 -
E15.2 Pie Charts
223 -
E15.3 Charts - Doughnut Charts
271 -
E15.4 Bar Charts
347 -
E15.5 Bubble Charts
388 -
E15.6 3D Containers or Cylinders or Stacked column
585 -
E15.7 2D Map Charts-Basics
351 -
E15.8 2D Map Charts-Advanced
95 -
E15.9 3D Map Charts - Basics
409 -
E15.10 3D Map Charts - Sales with Time lapse, scenes creation
489 -
E15.11 3D Maps Charts -Population with Time lapse, scenes creation
338 -
E15.Charts, 2D Maps, and 3D Maps
-
E16.1 How to Enable Developer Tap
82 -
E16.2 Macros and VBA Basics
418 -
E16.3 Macros Example-1
132 -
E16.4 Macros Example-2
150 -
E16.5 VBA Example-1
167 -
E16.6 VBA Example-2
300 -
E16.7 1-10-VBA CODES
202 -
E16.8 11-20 VBA Codes with Shortcut key explanation
193 -
E16.9 21-40 VBA Codes
-
E16.10 VBA Case Study-1
10 -
E16.11 VBA Case Study-2
10 -
E16.12 Common VBA Commands
-
E16.13 Examples of Common VBA Commands
-
E16.14 VBA Text Book - VBA Guide Basics to Advanced
-
E16.Macro and VBA
-
E17.1 MS Excel - Student Mark Sheet Calculation - Total-Avg-Grade-Rank-Status
1263 -
E17.2 Spark Lines
38 -
E17.3 Lines for User Forms
75 -
E17.4 Data re-arrangement with Text to columns
67 -
E17.5 Insert Check Boxes
67 -
E17.6 Insert Data Forms
72 -
E17.7 AUTO BORDER
98 -
E17.8 WRAPROWS WITH VBA
116 -
E17.9 Compare Data Easily
42 -
E17.10 Slicer in Excel
97 -
E17.11 ADJUST IMAGE IN EXCEL
78 -
E17.12 DYNAMIC SEARCH BAR CREATION
493 -
E17.13 BAR CODE CREATION IN EXCEL
310 -
E17.14 Data Consolidation
98 -
E17.15 Copy Paste excluding Hidden Data
52 -
E17.16 Delete blank Cells
43 -
E17.17 ADVANCED SELECTION, MIN, MAX
66 -
E17.18 ROUND ROUNDUP MROUND
190 -
E17.19 SWAP COLUMSN DATA
93 -
E17.20 Sheet Controls
85 -
E17.Fire Your Boss
-
E18.1 MS Excel with Chat GPT - Manual Script
310 -
E18.2 MS Excel with Chat GPT - upload image
143 -
E18.3 MS Excel with Chat GPT - upload and download with formulas
133 -
E18.4 MS Excel with AI Tools - Ai-Aided formula Editor
172 -
E18.5 MS Excel - Add IN - Wiki Pedia - to collect info
136 -
E18.6 MS Excel - Add IN - FRED - ECONOMIC DATA
137 -
E18.7 MS Excel -Add IN - Mini Calendar
100 -
E18.8 MS Excel -Add IN - Symbols and Characters
109 -
E18.9 MS Excel - Chat GPT AI ASK
151 -
E18.10 MS Excel - Chap GPT AI FILL
81 -
E18.11 MS Excel - Chat GPT AI Translate
88 -
E18.12 MS Excel - Chat GPT AI Extract
105 -
E18.13 MS Excel - Chat GPT AI Table
111 -
E18.ChatGPT, AI Tools, and Add-ins
-
E19.1 Data Validation - Basics
416 -
E19.2 Drop Down List - Dependent Drop Down List
860 -
E19.3 Data Validation - on Student Registration
897 -
E19.Data Validation
-
E20.1 Automation - Student Admission Management
1290 -
E20.2 Complete Billing Automation - Invoice Design, Tax Calculation, Logo n more
4384 -
E20.3 Comparison Table Perpetual Dashboards vs Interactive-Dynamic Dashboards
128 -
E20.4 Perpetual-Static Dashboards I Part-1 I Creating KPI Key Performing Indicat
932 -
E20.5 Perpetual-Static Dashboards I Part-2 I KPIs to Visualization
1568 -
E20.6 Interactive-Dynamic Dashboards I Creating Connected KPI I Connect Dashboar
1635 -
E20.7 Financial Reporting Dashboards Sales, Profit, Country wise, Product Wise
1209 -
E20.EXCEL Projects, Dashboards, Infographics, and Data Visualization
-
E21 1 How to Add Claude AI to Microsoft Excel Claude AI Integration & Setup – S
210 -
E21 2 How to Use Claude AI in Excel Clean Data, Fix Formulas & Generate AI-Powe
525 -
E21 3 Generate 1,000 Employee Salary Slips Using Claude AI & Excel Bulk Payroll
275 -
E21 4 How to Generate Personalized Client Emails Using Claude AI & Excel AI Ema
269 -
E21 5 Create Interactive Excel Dashboards Using Claude AI Analyze 10,000+ Rows
486 -
E21 6 Flipkart Sales Data Analysis in Microsoft Excel Data Cleaning, Reporting
440 -
E21.1 Excel Basics - 100 Interview Questions and Answers PDF
-
E21.2 Excel Advanced - 100 Interview Questions and Answers
-
E21.3 Excel with ChatGPT Interview Questions and Answers
-
E21.4 TOP Companies Interview Questions and Answers for Different roles
-
E21.5 JOB ROLES, EXPECTED SALARY
-
E21.6 Apply for Jobs Here
-
E21.7 Key Points and Samples Resumes
-
1. How to Launch Mirosoft PowerPoint
305 -
2. An introduction to User Interface
411 -
3. MS Power Point - Design Slide Background-NEW
278 -
4. MS PPT - Transition Basics
278 -
5. MS PPT - Animations
444 -
6. Text Gradient Effects
262 -
7. Hyper Link - Links to Product Pages, Web Pages
1038 -
8. Project -1 - Department of Tourism
1165 -
9. Project-2 - learn to create 10 options Infographic Presentation
811 -
10. Project-3 8 Option Page Style InfoGraphic Presentation
860 -
11 How to Add ChatGPT & Claude AI to Microsoft PowerPoint AI Integration & Setu
174 -
12 Create PowerPoint Presentations Automatically Using ChatGPT-Generated VBA Cod
425 -
13 How to Create a Global Warming PowerPoint Presentation Using ChatGPT AI PPT
268 -
14 Create a Professional Course Demo Presentation Using ChatGPT AI PowerPoint D
339 -
15 How to Create a Data Analysis PowerPoint Presentation Using ChatGPT AI Repor
305 -
16 Automate PowerPoint Presentations Using Claude AI-Generated VBA Code Complet
338 -
17 Create a Global Warming PowerPoint Presentation Using Claude AI Step-by-Step
307 -
18 How to Generate a Professional Course Demo PowerPoint Using Claude AI AI Pre
337 -
19 Create Data Analysis PowerPoint Presentations Using Claude AI AI-Powered Cha
411 -
Power Point Quiz
Requirment
-
ba able to listen
-
be able to watch
-
Curiocity to learn new skills
Outcomes
-
Computer Basics and Fundamentals
-
Internet and Mailings
-
MS WORD
-
MS EXCEL
-
MS POWER POINT
0 Student
1 Course
0 review