About Course
A Compulsion Course for Financial, MIS, Data Analysis, Tax Professional, Auditors & Business Management sectors, Medical Coding, Data Entry, Hospital Management and everyone in every field
What Will You Learn?
- Computer Basics
- MS Word
- MS Excel
- MS PowerPoint
- Internet Browsing
- Mailings
- *You will earn a Certificate of Completion with QR Code, Sharable Link, Downloads in PDF, JPEG
Course Content
S2. Course Tips, Download Materials and Practice Notes
-
1. Download Course Materials Here
00:00
S3. Computer Basics Windows10/11
-
CB-1 What is computer ,Definition, Main parts
08:09 -
CB-2 Computer Input And Output Devices
01:48 -
CB-3. Windows-10 Icons Settings – Enabling and Disabling Icons on Desktops
05:44 -
CB-4. Windows-11 Icons Settings – Enabling and Disabling Icons on Desktops
02:58 -
CB-5. Windows-10 Taskbar Management
02:16 -
CB-6 Windows 10 Notification Area
03:27 -
CB-7. Windows-11 Taskbar Management
06:04 -
CB-8. Windows-10 How to Change Desktop Background, Set Picture, Solid Colour and Slideshow
07:33 -
CB-9. Windows-11 How to Change Desktop Background
06:03 -
CB-10. Themes vs Contrast Themes
02:13 -
CB-11. Windows-11 Languages I Windows Language and Keyboard Language
-
CB-12. How to Create Files and Folders
02:47 -
CB-13. Delete Functions – Temporary and Permanent Delete
03:33 -
CB-14. How to Check System Configuration, CPU, Ram, HDD, Background Application and More
05:25 -
CB-15. Device Manager – Learn How to Enable and Disable Devices of a Computer
-
CB-16. Account Login Settings – Enable and Disable Security
04:27 -
CB-17. System Clean up – Temp, Recent, Recycle bin cleaning
06:01 -
CB-18. How to Calculator – Different type of calculations
02:53 -
CB-19. How to Launch Paint and Painting Tools
02:18 -
CB-20. How to Make Partitions in Disk Drives
04:37 -
CB-21. How to Create Multiple Folders and Sub Folders W10-W11
03:47 -
CB-22. How to Hide Folders, Change Folder Icons
02:34 -
CB-23. How to Hide – Unhide Files using run command
02:00 -
CB-24. Schedule ShutDown – AutoShutDown – TimerShutDown
04:11 -
CB-25. Set Default Program to launch documents
03:02 -
CB-26. Customize Mouse
03:32 -
CB-27. F1 to F12 Shortcut Keys
02:05 -
CB-28. Windows Shortcut Keys
02:20 -
CB-29 ADD PREFIX TO MULTIPLE FILES
01:49
S4. Microsoft Word
-
1. Microsoft Word – Launching
04:43 -
2. Microsoft Word – User Interface
06:45 -
3. Microsoft Word – Save and Save As
03:42 -
4. Microsoft Word – Home Tab – Font Group – All Commands
12:33 -
5. MS Word-Bullets and Numbering
03:48 -
6. Microsoft Word – Multi Level List
06:16 -
7. Microsoft Word Text Alignments – Line and Paragraph Spacing
03:19 -
8. Microsoft Word – SORT Command Functionality
02:02 -
9. Microsoft Word – Color Shading and Text Borders
02:44 -
10. MS Word – Text Styles and Table of Contents
11:08 -
11. MS Word – Find and Replace English
03:25 -
12. MS Word – Copy Paste Functions
05:25 -
13. MS Word – Insert Tab – Pages Group – Page Cover and Blank Page and Page Break
04:44 -
14. MS Word – Table – All Table Tools Explained
22:39 -
15. MS Word – Insert Pictures and Edit Pictures
08:21 -
16. MS Word – Shapes, Icons, 3D Models Explained
05:24 -
17. MS Word – Smart Art, Charts and Screenshot utilities
06:14 -
18. MS Word – Links to WebPages
03:49 -
19. MS Word – Links to Existing Files
04:36 -
20. MS Word-Book Marks and HyperLinks
04:40 -
21. MS Word-Comments
04:53 -
22. MS Word-Headers Footers and Page Numbers
06:08 -
23. MS Word-How to Insert Objects
05:32 -
24. MS Word-Symbols
03:00 -
25. MS Word-Insert Text from File
01:38 -
26. MS Word-WaterMarks
04:01 -
27. MS Word-LayoutTab-Page Margins, Orientation, Size, Columns, Hyphanesation and more
06:00 -
28. MS Word-Layout-Paragraph Indent, Spacing-Backward-Forward
03:11 -
29. MS Word-Page Borders, Page Colors
05:47 -
30. MS Word- Mail Merge – Complete Process with Real Time Mails and Documents
09:18 -
31. MS Word-Review-Spelling and Grammar-Set Proofing Language
04:56 -
32. MS Word-Review-Thesaurus and Word Count
03:16 -
33. MS Word-Review-Auto Correct and Short Forms
03:24 -
34. MS Word-Review-Check Accessibility
02:56 -
35. MS Word-Review-Translate
02:13 -
36. MS Word-Review- Disable Auto-Hyper Links
01:28 -
37. MS Word-Review-Track Changes
04:49 -
38. MS Word-View Tab Commands
06:32 -
39. MS Word-Protection-Document Protection and Data Protection
03:53
S5. MS Excel
-
E1.1 How to Open MS Excel
03:06 -
E1.2 Start Screen – Navigating MS Excel
04:28 -
E1.3 User Interface – Navigating MS Excel
08:04 -
E1.4 Home Tab Basic Editing Tools
11:25 -
E1.5 Copy and Paste I using to Multiple Tools in MS Excel
11:46 -
E2.1 Customize Ribbon Bar – Tabs, Groups, Commands I Tools
04:45 -
E2.2 Text to Column – Multiple methods
07:25 -
E2.3 Speak Cells – Data Reading Tool
04:00 -
E2.4 Comments – Add, Edit, Delete and Customize
08:24 -
E2.5 Filters in MS Excel
04:24 -
E2.6 Freeze Panes and Split Screen
04:41 -
E3.1 Fill Series – Basics
03:27 -
E3.2 Fill Series – Advanced
07:36 -
E3.3 Fill Series – Flash Fill
05:26 -
E3.4 Conditional Formatting
04:09 -
E3.5 Hyperlinks to Sheets, Webpages, Files
09:00 -
E3.6 Header and Footer Settings
08:26 -
E3.7 Printing and Paper Settings
05:49 -
E3.8 Import data from web
05:47 -
E3.9 Import data from text document with auto refresh
03:08 -
E3.10 Import-text word ppt jpeg video- pdf & more objects
08:03 -
E4.1 Characteristics of a cell
01:45 -
E4.2 Cell References – Relative Ref, Absolute Ref, Mixed Ref
13:58 -
E4.3 Custom View
04:02 -
E4.4 Sheet protection
05:37 -
E4.5 Cell Protection
04:49 -
E4.6 Compare sheets side by side I View Sheets side by side
05:15 -
E4.7 Compare sheets from Multiple Files
02:38 -
E4.8 Working with cells, rows, columns, Specific Size, Auto Fit
09:27 -
E4.9 Working with sheets rename, colour, copy, move, grouping
07:08 -
E5.1 Things to remember before starting formulas
09:41 -
E5.2 SUM
08:51 -
E5.3 SUMIF
05:51 -
E5.4 SUMIFS
08:43 -
E5.5 SUBTOTAL
04:43 -
E5.6 AGGREGATE
03:07 -
E5.7 SUMPRODUCT
03:53 -
E5.8 SUMSQ
03:25 -
E5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry
08:06 -
E5.10 DSUM – DATABSE SUM
04:06 -
E5.11 IMSUM vs IMSUB – Complex Data Calculations
03:31 -
E6.1 AVERAGE
01:23 -
E6.2 AVERAGEA
02:43 -
E6.3 AVERAGEIF vs AVERAGEIFS
05:28 -
E6.4 Weighted Average with VBA Code
04:20 -
E7.1 COUNT, COUNTA, COUNTBLANK
03:05 -
E7.2 COUNTIF vs COUNTIFS
04:59 -
E8.1 LOGICAL TEST with Comparative Operators
03:39 -
E8.2 IF
06:03 -
E8.3 IF AND vs IF OR
05:04 -
E8.4 IFS vs NESTEDIF
07:17 -
E8.5 IFERROR
03:37 -
E8.6 SWITCH
05:26 -
E9.1 LEFT, RIGHT, MID and LEN
04:45 -
E9.2 FIND vs SEARCH
02:13 -
E9.3 REPLACE vs SUBSTITUTE
05:23 -
E10.1 CONCAT vs CONCATENATE
02:13 -
E10.2 TEXT
09:06 -
E10.3 UPPER, LOWER, PROPER
01:09 -
E10.4 TRIM
01:04 -
E10.5 SPELLNUMBER with VBA code
04:11 -
E10.6 TEXT-TO-NUMBER with VBA code
02:14 -
E11.1 Using TODAY, NOW
03:19 -
E11.2 DATE, DATEVALUE, TIME, TIME VALUE
08:21 -
E11.3 DATEDIF AND EXTRACT YEARS, MONTHS, DAYS, HOURS, MIN, SECONDS
07:33 -
E11.4 Calculating Future and Past Dates -EDATA, EOMONTH, WORKINGDAYS, NET WORKINGDAYS
08:24 -
E11.5 Calculate Days using – DAY, DAYS, NETWORKING DAYS
02:23 -
E11.6 Calculate Hours and Hourly Charges
04:46 -
E12.1 PMT – EMI Calculator
05:00 -
E12.2 PPMT, IPMT – Loan Statement Preparation
18:28 -
E12.3 FV – Investment Calculator
03:59 -
E13.1 VLOOKUP – Basics – Rules – Exact Match – Approx Match
11:03 -
E13.2 HLOOKUP – Basics
02:17 -
E13.3 XLOOKUP Function – with VBA Code
03:48 -
E13.4 MATCH Function vs INDEX Function
05:14 -
E13.5 VLOOKUP-Advanced-1-Applying across multiple cells at a time
02:36 -
E13.6 VLOOKUP-Advanced-2-Applying across multiple sheets
03:01 -
E13.7 VLOOKUP-Advanced-3-Applying on large data
09:44 -
E13.8 VLOOKUP-Advanced-4-Applying across multiple workbooks
09:39 -
E14.1 Pivot Table Basics
05:43 -
E14.2 Pivot Table Basics – common mistakes
06:04 -
E14.3 Pivot Tables – Advanced Tips
08:28 -
E14.4 How to Combine Multiple Sheet Data into One
07:02 -
E14.5 Pivot Table on Multiple Sheets, Workbooks
03:33 -
15.1 MS Excel Charts – Basics – Insert, Data Control, Improve Chart, Change Series
12:21 -
E15.2 Pie Charts
03:43 -
E15.3 Charts – Doughnut Charts
04:31 -
E15.4 Bar Charts
05:47 -
E15.5 Bubble Charts
06:27 -
E15.6 3D Containers or Cylinders or Stacked column
09:45 -
E15.7 2D Map Charts-Basics
05:50 -
E15.8 2D Map Charts-Advanced
01:34 -
E15.9 3D Map Charts – Basics
06:48 -
E15.10 3D Map Charts – Sales with Time lapse, scenes creation
08:08 -
E15.11 3D Maps Charts -Population with Time lapse, scenes creation
05:37 -
E16.1 How to Enable Developer Tap
01:22 -
E16.2 Macros and VBA Basics
06:58 -
E16.3 Macros Example-1
02:11 -
E16.4 Macros Example-2
02:30 -
E16.5 VBA Example-1
02:46 -
E16.6 VBA Example-2
05:00 -
E16.7 1-10-VBA CODES
03:22 -
E16.8 11-20 VBA Codes with Shortcut key explanation
03:13 -
E17.1 Student Mark Sheet Calculation
21:02 -
E17.2 Spark Lines
00:38 -
E17.3 Lines For User Forms
01:14 -
E17.4 Data Re-arrangement with Text To Columns
01:07 -
E17.5 Insert Check Boxes
01:06 -
E17.6 Inserts Data Forms
01:12 -
E17.7 Auto Borders
01:38 -
E17.8 Wrap Rows With VBA
01:56 -
E17.9 Compare Data Easily
00:42 -
E17.10 Slicer In Excel
01:36 -
E17.11 Adjust Image In Excel
01:17 -
E17.12 Dynamic Search Bar creation
08:12 -
E17.13 Bar Code Creation In Excel
05:09 -
E17.14 Data Consolidation
01:38 -
E17.15 Copy Paste Excluding hidden data
00:52 -
E17.16 Delete Blank Cells
00:42 -
E17.17 Advance Selection ,Min, max
01:05 -
E17.18 Round Roundup Mround
03:10 -
E17.19 Swap Columns Data
01:32 -
E17.20 Sheet Controls
01:24 -
E18.1 MS Excel with ChatGPT – Manual Script
05:09 -
E18.2 MS Excel with ChatGPT – upload image
-
E18.3 MS Excel with ChatGPT – upload and download with formulas
02:12 -
E18.4 MS Excel with AI Tools – Ai-Aided formula Editor
02:51 -
E18.5 MS Excel – Add IN – WikiPedia – to collect info
02:16 -
E18.6 MS Excel – Add IN – FRED – ECONOMIC DATA
02:16 -
E18.7 MS Excel -Add IN – Mini Calendar
01:40 -
E18.8 MS Excel -Add IN – Symbols and Characters
01:48 -
E18.9 MS Excel – Chat GPT AI ASK
02:31 -
E18.10 MS Excel – Chat GPT AI FILL
01:21 -
E18.11 MS Excel – Chat GPT AI Translate
01:27 -
E18.12 MS Excel – ChatGPT AI Extract
01:44 -
E18.13 MS Excel – ChatGPT AI Table
01:50 -
E19.1 Data Validation -Basics
06:55 -
E19.2 Drop Down List – Dependent Drop Down List
14:20 -
E19.3 Data Validation -on Student Registration
21:29 -
E20.1 Automation -Student admission Management
21:30 -
E20.2 Complete Billing Automation -Invoice Designs, Tax calculation ,Logo n More
01:13:04 -
E20.3 Comparison Table :perpetual dashboards Vs Interactive -Dynamic Dashboards
02:08 -
E20.4 Perpetual-Static Dashboards I Part-1 I Creating KPI Key Performing Indicators
15:32 -
E20.5 Perpetual-Static Dashboards I Part-2 I KPIs to Visualization
26:07 -
E20.6 Interactive-Dynamic Dashboards I Creating Connected KPI I Connect Dashboards
27:15 -
E20.7 Financial Reporting Dashboards Sales, Profit, Country wise, Product Wise
20:09
S6. MS PowerPoint
-
1. How to Launch Mirosoft PowerPoint
05:06 -
2. An introduction to user Interface
06:51 -
3. MS Power Point – Design Slide Background-NEW
04:38 -
4. MS PPT – Transition Basics
04:39 -
5. MS PPT – Animations
07:25 -
6. Text Gradient Effects
04:22 -
7. HyperLink – Links to Product Pages, Web Pages
17:18 -
8. PROJECT -1 – Department of Tourism
19:25 -
10. Project – 10 Options InfoGraphic Presentation
13:31 -
11. Project-3 8 Option Page Style InfoGraphic Presentation
17:08
S7. Internet & Mailings
-
1. Learn How to Create G-Mail Account
04:32 -
2. How send messages to To, CC, BCC
08:08 -
3. Mail – Text Format, Editing, Signature Tools
10:07 -
4. How to Delete G-Mail account and take backup of the data
02:09
Student Ratings & Reviews
5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
100% would recommend to a friend