Through this free course, equip yourself with the fundamental knowledge of MS Office and Advanced Excel. Spend just two hours every day for 75 days to learn how to use these vital tools. With the help of this online course, you may expand your knowledge while also opening up a variety of job options. Our thorough training guarantees that you are prepared to handle any professional task, from manipulating data to producing sophisticated spreadsheets. Take advantage of this chance to improve your employability and succeed in the digital age. Enroll right away to start a journey that will change the course of your career and put you on the road to success.
MS OFFICE – COMPUTER FUNDAMENTAL | MS WORD | |
| Computer Generation | Home Tab | |
| Types of Computer | Home Tab – Clipboard | |
| Micro Computer Block Diagram | Home Tab – Font | |
| Main Parts of Computer | Home Tab – Paragraph | |
| Input Devices – Keyboard | Home Tab – Style Group | |
| Input Devices – Mouse | Home Tab – The Editing Group | |
| Input Devices – Scanning Devices | Insert Tab | |
| Output Devices | Insert Tab – Pages | |
| Output Devices – Monitor | Insert Tab – Table | |
| Output Devices – Printer | Insert Tab – Adding Picture & Clip Art | |
| Types of Storage | Insert Tab – Shape | |
| How to Information Store in Memory | Reference Tab – Footnotes | |
| System Unit | Reference Tab – Citations & Bibliography | |
| Hardware & Software | Reference Tab – Captions | |
| Ports | Reference Tab – Index | |
| Windows – Operating System | Mailings Tab | |
| Starting Your Computer | Mailings Tab – Envelopes & Labels | |
| Restarting Your Computer | Mailings Tab – Mail Merge | |
| Shutting Down Your Computer | Review Tab | |
| Desktop – Taskbar | Review Tab – Proofing | |
| Start Menu | Review Tab – Translate | |
| Desktop Property Adjustments | Review Tab – Comments | |
| Taskbar Property Adjustments | Review Tab – Tracking | |
| Date & Time Adjustment | Review Tab – Compare | |
| Windows Explorer | View Tab | |
| Windows Explorer – Creating Folder | View Tab – Documents View | |
| Windows Explorer – Rename Folder | View Tab – Show / Hide | |
| Windows Explorer – Copy File & Folder | View Tab – Zoom | |
| Windows Explorer – Move File & Folder | View Tab – Window | |
| Windows Explorer – Delete File & Folder | View Tab – Macros | |
| Opening Programs | File Tab – Create New Blank Document | |
| Paint – Brush | File Tab – Recently Opened Documents | |
| Closing Programs | File Tab – Open Existing Document | |
| File Tab – Info | ||
| File Tab – Back Stage View | ||
MX EXCEL | File Tab – Printing Documents | |
| Introduction of excel | File Tab – Document Security | |
| Navigating in worksheet | ||
| Operator pointers | ADVANCE EXCEL | |
| Operator in Excel | Pivot Chart | |
| Student structure data | Pivot Slicer | |
| Home – font, alignment, merge, wrap | Insert – Sparkline | |
| Home – number | Basic formulas – Mark sheet | |
| Home – conditional formatting- High light rules | Basic formulas – Pay slip | |
| Home – conditional formatting- top/ Bottom rules | If – And – Or – Formulas | |
| Home – conditional formatting- Data bars | Statistical Function – Max , Min | |
| Home – conditional formatting- color scales | Statistical Function – Counta, Countif | |
| Home – conditional formatting- Icon sets | Financial function – DB | |
| Home – cell style | Financial function – SLN | |
| Home – Cell – Insert, Delete, Format | Financial function – SYD | |
| Home – Editing Auto sum | Financial function – PMT, PPMT | |
| Home – Editing Auto Average | Date Time Functions | |
| Home – Editing Auto Count | Lookup | |
| Home – Editing Auto Max | V lookup | |
| Home – Editing Auto Min | H lookup | |
| Home – Editing Fill, Clear | Scenario | |
| Home – Editing sort | Goal Seek | |
| Home – Editing Custom sort, Filter | Data Table | |
| Micro |