Computer Basics With MS Office + AI
A guide for new computer users or those who want to know more to get started with the basics to become Master!
A guide for new computer users or those who want to know more to get started with the basics to become Master!
**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 area empty
1. What is Computer, Definition, Main Parts
490 Xem trước2. Computer Input and OutPut Devices
109 Xem trước3. Windows-10 Icons Settings - Enabling and Disabling Icons on Desktops
345 Xem trước4. Windows-11 Icons Settings - Enabling and Disabling Icons on Desktops
1795. Windows-10 Taskbar Management
136 Xem trước6. Windows-10 Notification Area Settings
207 Xem trước7. Windows-11 Taskbar Management
364 Xem trước8. Windows-10 How to Change Desktop Background, Set Picture, Solid Color and Sli
4549. Windows-11 How to Change Desktop Background
36410. Themes vs Contrast Themes
134 Xem trước11. Windows-11 Languages I Windows Language and Keyboard Language
23212. How to Create Files and Folders
16813. Delete Functions - Temporary and Permanent Delete
21314. How to Check System Configuration, CPU, Ram, HDD, Background Application and
32515. Device Manager - Learn How to Enable and Disable Devices of a Computer
14016. Account Login Settings - Enable and Disable Security
26717. System Cleanup - Temp, Recent, Recycle bin cleaning
36118. How to Calculator - Different type of calculations
17319. How to Launch Paint and Painting Tools
13820. How to Make Partitions in Disk Drives
27821. How to Create Multiple Folders and Sub Folders W10-W11
22822. How to Hide Folders, Change Folder Icons
15523. How to Hide - Unhide Files using run command
12124. Scheduel ShutDown - AutoShutDown - TimerShutDown
25125. Set Default Program to launch documents
18326. Customize Mouse
21327. F1 to F12 Shortcut Keys
12528. Windows Shortcut Keys
14029. ADD PREFIX TO MULTIPLE FILES
110Download Course Material Here
Computer Basics Quiz
1. Microsoft Word - Launching
2832. MS Word - User Interface.mp4
4043. MS Word English - Save and Save As.mp4
2214 Home Tab -English Font Group Commands NEW
7535 MS Word-Bullets and Numbering
2276. Microsoft Word - MultiList Level
3767. Microsoft Word Text Alignments - Line and Paragraph Spacing.mp4
1998. Microsoft Word - SORT Command Functionality
1219. Microsoft Word - Color Shading and Text Borders
16410. MS Word - Text Styles and Table of Contents I known as Index
66711. MS Word - Find and Replace
20412. MS Word - Copy Paste Functions.mp4
32513. MS Word - Insert Tabe - Pages Group - Page Cover and Blank Page and Page Br
28314. MS Word - Table - All Table Tools Explained.mp4
135815. MS Word - Insert Pictures and Edit Pictures
50116. MS Word - Shapes, Icons, 3D Models Explained
32417. MS Word - Smart Art, Charts and Screenshot utilities
37318. MS Word - Links to WebPages
22819. MS Word - Links to Existing Files
27520. MS Word-Book Marks and HyperLinks
28021. MS Word-Comments
29322. MS Word-Headers Footers and Page Numbers
36823. MS Word-How to Insert Obejects
33224. MS Word-Symbols
18025. MS Word-Insert Text from File
9826. MS Word-WaterMarks
24027. MS Word-LayoutTab-Page Margins, Orientation, Size, Columns, Hyphanesation an
36028. MS Word-Layout-Paragraph Indent, Spacing-Backward-Forward
19029. MS Word-Page Borders, Page Colors
34730. MS Word- Mail Merge - Complete Process with Real Time Mails and Documents
55731. MS Word-Review-Spelling and Grammar-Set Proofing Language
29632. MS Word-Review-Thesaurus and Word Count
19533. MS Word-Review-Auto Correct and Short Forms
20334. MS Word-Review-Check Accessibility
17535. MS Word-Review-Translate
13236. MS Word-Review- Disable Auto-Hyper Links
8737. MS Word-Review-Track Changes
28938. MS Word-View Tab Commands
39239. MS Word-Protection-Document Protection and Data Protection
233MS Word Quiz
40 How to Add ChatGPT to Microsoft Word Install & Use ChatGPT in MS Word – Step
16141 How to Generate Content Using ChatGPT AI Content Writing for Beginners – Com
18842 How to Edit and Modify Existing Documents Using ChatGPT AI Document Editing
18443 How to Install QuillBot Add-in in Microsoft Word Use QuillBot for Grammar &
143Download Practice Excel Files Here
E1.1 How to Launch MS Excel
186E1.2 Start Screen - Back Stage Screen - Navigating MS Excel
269E1.3 User Interface - Navigating MS Excel Workbook Screen
484E1.4 Home Tab - Basic Editing Tools
685E1.5 Copy and Paste I using Multiple Tools in MS Excel
706E1.MS Excel - Start-up
E2.1 Customize Ribbon Bar – Tabs, Groups, Commands I Tools
296E2.2 Text to Column – Multiple methods
446E2.3 Speak Cells – Data Reading Tool
240E2.4 Comments - Add, Edit, Delete, Copy Paste, Background change
503E2.5 Filters in MS Excel
264E2.6 Freeze Panes and Split Window
281E2.– Basic Tools to Know
E3.1 Fill Series - Basics
208E3.2 Fill Series - Advanced
457E3.3 Fill Series - Flash Fill
326E3.4 Conditional Formatting
249E3.5 Hyperlinks to Sheets, Web pages, Files
541E3.6 Header and Footer Settings
506E3.7 Printing and Paper Settings
350E3.8 Import Data from Web
347E3.9 Import Data from Text File with Auto Refresh
189E3.10 Import Objects into Excel
484E3.3- Fill Series and Data, Sheet Control
E4.1 Characteristics of a cell
106E4.2 Cell References – Relative Ref, Absolute Ref, Mixed Ref
839E4.3 Custom View
242E4.4 Sheet protection
338E4.5 Cell Protection
289E4.6 Compare sheets side by side I View Sheets side by side
315E4.7 Compare sheets from Multiple Files
158E4.8 Working with cells, rows, columns, Specific Size, Auto Fit
568E4.9 Working with sheets rename, colour, copy, move, grouping
428E4.Working with Sheets in MS Excel
E5.1 Things to remember before starting formulas
582E5.2 SUM
532E5.3 SUMIF
352E5.4 SUMIFS
524E5.5 SUBTOTAL
284E5.6 AGGREGATE
188E5.7 SUMPRODUCT
234E5.8 SUMSQ
205E5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry
486E5.10 DSUM - DATA BASE SUM
247E5.11 IMSUM vs IMSUB – Complex Data Calculations
211E5.Sum Related Formulas"
E6.1 AVERAGE
84E6.2 AVERAGEA
163E6.3 AVERAGEIF vs AVERAGEIFS
329E6.4 Weighted Average with VBA Code
260E6.Average vs AverageIFS"
E7.1 COUNT, COUNTA, COUNTBLANK
185E7.2 COUNTIF vs COUNTIFS
299E7.Count Related Formulas
E8.1 LOGICAL TEST with Comparative Operators
220E8.2 IF
363E8.3 IF AND vs IF OR
304E8.4 IFS vs NESTEDIF
438E8.5 IFERROR
217E8.6 SWITCH
327E8.Logical IF-Related Formulas in MS Excel
E9.1 LEFT, RIGHT, MID and LEN
286E9.2 FIND vs SEARCH
134E9.3 REPLACE vs SUBSTITUTE
324E9.Text Extraction and Manipulation
E10.1 CONCAT vs CONCATENATE
134E10.2 TEXT
547E10.3 UPPER, LOWER, PROPER
69E10.4 TRIM
64E10.5 SPELLNUMBER with VBA code
251E10.6 TEXT-TO-NUMBER with VBA code
135E10.Text Formatting and Conversion
E11.1 Using TODAY, NOW
199E11.2 DATE, DATEVALUE, TIME, TIME VALUE
502E11.3 DATEDIF AND EXTRACT YEARS, MONTHS, DAYS, HOURS, MIN, SECONDS
453E11.4 Calculating Future and Past Dates -EDATA, EOMONTH, WORKINGDAYS, NET WORKIN
505E11.5 Calculate Days using – DAY, DAYS, NETWORKING DAYS
144E11.6 Calculate Hours and Hourly Charges
287E11.Date and Time Related Formulas - MCQs
E12.1 PMT – EMI Calculator
300E12.2 PPMT, IPMT – Loan Statement Preparation
1108E12.3 FV – Investment Calculator
240E12.Finance Related Formulas
E13.1 VLOOKUP – Basics - Rules - Exact Match - Approx Match
663E13.2 HLOOKUP – Basics
137E13.3 XLOOKUP Function - with VBA Code
229E13.4 MATCH Function vs INDEX Function
315E13.5 VLOOKUP-Advanced-1-Applying across multiple cells at a time
156E13.6 VLOOKUP-Advanced-2-Applying across multiple sheets
181E13.7 VLOOKUP-Advanced-3-Applying on large data
584E13.8 VLOOKUP-Advanced-4-Applying across multiple workbooks
579E13.DATA SEARCH - Lookup related formulas
E14.1 Pivot Table Basics
343E14.2 Pivot Table Basics - common mistakes
364E14.3 Pivot Tables - Advanced Tips
508E14.4 How to Combine Multiple Sheet Data into One
422E14.5 Pivot Table on Multiple Sheets, Workbooks
214E14.Pivot Table & Lookup Formulas in Excel
E15.1 MS Excel Charts - Basics - Insert, Data Control, Improve Chart, Change Ser
742E15.2 Pie Charts
223E15.3 Charts - Doughnut Charts
271E15.4 Bar Charts
347E15.5 Bubble Charts
388E15.6 3D Containers or Cylinders or Stacked column
585E15.7 2D Map Charts-Basics
351E15.8 2D Map Charts-Advanced
95E15.9 3D Map Charts - Basics
409E15.10 3D Map Charts - Sales with Time lapse, scenes creation
489E15.11 3D Maps Charts -Population with Time lapse, scenes creation
338E15.Charts, 2D Maps, and 3D Maps
E16.1 How to Enable Developer Tap
82E16.2 Macros and VBA Basics
418E16.3 Macros Example-1
132E16.4 Macros Example-2
150E16.5 VBA Example-1
167E16.6 VBA Example-2
300E16.7 1-10-VBA CODES
202E16.8 11-20 VBA Codes with Shortcut key explanation
193E16.9 21-40 VBA Codes
E16.10 VBA Case Study-1
10E16.11 VBA Case Study-2
10E16.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
1263E17.2 Spark Lines
38E17.3 Lines for User Forms
75E17.4 Data re-arrangement with Text to columns
67E17.5 Insert Check Boxes
67E17.6 Insert Data Forms
72E17.7 AUTO BORDER
98E17.8 WRAPROWS WITH VBA
116E17.9 Compare Data Easily
42E17.10 Slicer in Excel
97E17.11 ADJUST IMAGE IN EXCEL
78E17.12 DYNAMIC SEARCH BAR CREATION
493E17.13 BAR CODE CREATION IN EXCEL
310E17.14 Data Consolidation
98E17.15 Copy Paste excluding Hidden Data
52E17.16 Delete blank Cells
43E17.17 ADVANCED SELECTION, MIN, MAX
66E17.18 ROUND ROUNDUP MROUND
190E17.19 SWAP COLUMSN DATA
93E17.20 Sheet Controls
85E17.Fire Your Boss
E18.1 MS Excel with Chat GPT - Manual Script
310E18.2 MS Excel with Chat GPT - upload image
143E18.3 MS Excel with Chat GPT - upload and download with formulas
133E18.4 MS Excel with AI Tools - Ai-Aided formula Editor
172E18.5 MS Excel - Add IN - Wiki Pedia - to collect info
136E18.6 MS Excel - Add IN - FRED - ECONOMIC DATA
137E18.7 MS Excel -Add IN - Mini Calendar
100E18.8 MS Excel -Add IN - Symbols and Characters
109E18.9 MS Excel - Chat GPT AI ASK
151E18.10 MS Excel - Chap GPT AI FILL
81E18.11 MS Excel - Chat GPT AI Translate
88E18.12 MS Excel - Chat GPT AI Extract
105E18.13 MS Excel - Chat GPT AI Table
111E18.ChatGPT, AI Tools, and Add-ins
E19.1 Data Validation - Basics
416E19.2 Drop Down List - Dependent Drop Down List
860E19.3 Data Validation - on Student Registration
897E19.Data Validation
E20.1 Automation - Student Admission Management
1290E20.2 Complete Billing Automation - Invoice Design, Tax Calculation, Logo n more
4384E20.3 Comparison Table Perpetual Dashboards vs Interactive-Dynamic Dashboards
128E20.4 Perpetual-Static Dashboards I Part-1 I Creating KPI Key Performing Indicat
932E20.5 Perpetual-Static Dashboards I Part-2 I KPIs to Visualization
1568E20.6 Interactive-Dynamic Dashboards I Creating Connected KPI I Connect Dashboar
1635E20.7 Financial Reporting Dashboards Sales, Profit, Country wise, Product Wise
1209E20.EXCEL Projects, Dashboards, Infographics, and Data Visualization
E21 1 How to Add Claude AI to Microsoft Excel Claude AI Integration & Setup – S
210E21 2 How to Use Claude AI in Excel Clean Data, Fix Formulas & Generate AI-Powe
525E21 3 Generate 1,000 Employee Salary Slips Using Claude AI & Excel Bulk Payroll
275E21 4 How to Generate Personalized Client Emails Using Claude AI & Excel AI Ema
269E21 5 Create Interactive Excel Dashboards Using Claude AI Analyze 10,000+ Rows
486E21 6 Flipkart Sales Data Analysis in Microsoft Excel Data Cleaning, Reporting
440E21.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
3052. An introduction to User Interface
4113. MS Power Point - Design Slide Background-NEW
2784. MS PPT - Transition Basics
2785. MS PPT - Animations
4446. Text Gradient Effects
2627. Hyper Link - Links to Product Pages, Web Pages
10388. Project -1 - Department of Tourism
11659. Project-2 - learn to create 10 options Infographic Presentation
81110. Project-3 8 Option Page Style InfoGraphic Presentation
86011 How to Add ChatGPT & Claude AI to Microsoft PowerPoint AI Integration & Setu
17412 Create PowerPoint Presentations Automatically Using ChatGPT-Generated VBA Cod
42513 How to Create a Global Warming PowerPoint Presentation Using ChatGPT AI PPT
26814 Create a Professional Course Demo Presentation Using ChatGPT AI PowerPoint D
33915 How to Create a Data Analysis PowerPoint Presentation Using ChatGPT AI Repor
30516 Automate PowerPoint Presentations Using Claude AI-Generated VBA Code Complet
33817 Create a Global Warming PowerPoint Presentation Using Claude AI Step-by-Step
30718 How to Generate a Professional Course Demo PowerPoint Using Claude AI AI Pre
33719 Create Data Analysis PowerPoint Presentations Using Claude AI AI-Powered Cha
411Power Point Quiz
ba able to listen
be able to watch
Curiocity to learn new skills
Computer Basics and Fundamentals
Internet and Mailings
MS WORD
MS EXCEL
MS POWER POINT