Beginner To Advanced Course - Ms Word And Excel Training

Learn the Core Tools of Microsoft Word & Excel to Create Documents, Analyze Data, and Boost Productivity

What you'll learn

Create and format professional documents in Microsoft Word with ease.

Use Word tools like headers, footers, page numbers, and styles for polished reports.

Design tables, insert images, and apply layouts for visually effective Word documents.

Work confidently with Microsoft Excel spreadsheets for data entry and organization.

Use basic Excel formulas and functions such as SUM, AVERAGE, COUNT, and IF.

Create and format charts in Excel to visually represent data.

Apply sorting, filtering, and data validation techniques in Excel for analysis.

Build time-saving skills with keyboard shortcuts and templates in both Word and Excel.

Requirements

No prior experience required

Microsoft Office installed

Basic ability to use a computer and navigate through files and folders.

An eagerness to learn and improve productivity with Word and Excel.

Stable internet connection

A notebook to jot down tips, shortcuts, and personal notes.

Description

Course Description: MS Word & Excel EssentialsIn today’s fast-paced digital world, Microsoft Word and Excel are among the most essential tools used across nearly every industry. Whether you’re a student, job seeker, office professional, or small business owner, mastering these applications can significantly improve your efficiency, confidence, and career opportunities.MS Word & Excel Essentials is a beginner-friendly course that provides a comprehensive introduction to Microsoft Word and Excel — two of the most powerful and widely used programs in the Microsoft Office suite. This course is specifically designed for those with little or no prior experience, offering step-by-step guidance and hands-on demonstrations to help you learn and apply skills immediately. What You’ll Learn in Microsoft Word:Creating and formatting professional documentsUsing fonts, styles, colors, and spacing effectivelyInserting and editing images, tables, and hyperlinksPage layout, headers, footers, and page numberingSaving and exporting documents (including PDF format)Tools for reviewing and proofreading (spellcheck, comments, etc.)Microsoft Word is not just a typing tool — it’s a platform for creating polished, organized, and professional content. By the end of this section, you’ll be able to confidently write reports, resumes, letters, and more. What You’ll Learn in Microsoft Excel:Navigating the Excel interface and creating spreadsheetsEntering and managing data using rows, columns, and cellsUsing basic formulas and functions (SUM, AVERAGE, COUNT)Formatting cells, data types, and number stylesCreating charts and graphs to visualize dataUsing tools like sorting, filtering, and conditional formattingIntroduction to basic data analysis and automationExcel is much more than just a data entry tool — it’s a powerful engine for organizing, calculating, and presenting information. By the end of the Excel section, you'll be equipped to build practical spreadsheets for budgeting, data tracking, inventory, and more.

Overview

Section 1: Beginner To Advanced Course - MS word and excel training

Lecture 1 Beginner To Advanced Course - MS word and excel training

Section 2: Assignment 1

Lecture 2 Assignment 1

Section 3: Project 1

Lecture 3 Project 1

Section 4: Project 2

Lecture 4 Project 2

Section 5: IT Process Word Assessment

Lecture 5 IT Process Word Assessment

Section 6: Advanced Excel Refresher

Lecture 6 Advanced Excel Refresher

Section 7: Advanced Excel Refresher 2

Lecture 7 Advanced Excel Refresher 2

Section 8: Presentation Skill

Lecture 8 Presentation Skill

Section 9: Excel Power Query Remove Duplicates

Lecture 9 Excel Power Query Remove Duplicates

Section 10: Excel Power Query Merge Queries

Lecture 10 Excel Power Query Merge Queries

Section 11: Excel Power Query Append Queries

Lecture 11 Excel Power Query Append Queries

Section 12: Excel Power Query Group Data

Lecture 12 Excel Power Query Group Data

Section 13: Excel Power Query Add Conditional Column

Lecture 13 Excel Power Query Add Conditional Column

Section 14: Excel Power Query Add Unpivot Columns

Lecture 14 Excel Power Query Add Unpivot Columns

student,job seeker,teacher,freelancer,working professional,Someone new to Microsoft Office and want to learn it from scratch,A college student needing document and data handling skills for assignments,A job applicant preparing for computer-based skill tests,An office worker or admin staff looking to improve productivity,A teacher, trainer, or educator needing to create professional materials,A small business owner who manages documents, data, and reports independently,Anyone looking to boost their resume with essential digital skills