ADVANCE MICROSOFT OFFICE COURSE WITH AI
Fees: Rs. 8,000 Time: 1.5 months
Curriculum Overview
01. MS Word Essential
- Home and Insert tab: formatting paragraphs
- Rest of the tabs: inserting images, adding text and formatting
- Templates: building a poster and a certificate
- Review, View & Mail Merge: table of contents, citations, table of figures and index
02. Excel Basics & Introduction
- Sum, Average & Charts: introduction to Excel
- Home, File & Insert tab in Excel
- SUMIF, SUM, PRODUCT, MIN, MAX functions
- SUM, Fill, Split, LEFT, RIGHT functions
- Multiply, combine cells with/without space, and equal-to formulas
03. Excel Formulas & IF Logic
- Practice: sum, minus, division, multiplication, average, min/max and IF formulas
- IF formulas, grading and pass/fail logic
- Project: Car Parking IF
- Project: poster on holidays homework, plus IF practice
- Project: Sim IFs, Metallica T-shirt sizing
- IF, grading and pass/fail with TRUE/FALSE
- Formatting, sorting and custom filters
04. Excel Conditional Statements
- IF, AND, OR & IF-error handling
- Sorting combined with conditional statements
- Building and practicing conditional statements
- Merging cells and alignment
- Project: Invoice Building
05. Excel Finance Functions & Practice
- Finance functions and finance formulas
- Project: Excel Finance Final
- Consolidated Excel practice sessions
06. PowerPoint Basics & Design
- PowerPoint introduction and touring the ribbon
- PowerPoint basics: slides, layouts and formatting
- Layouts, formatting and graphics
07. PowerPoint Effects, Animation & Infographics
- Effects, animation and transitions
- Shapes, formatting, effects, animation and transitions
- Project: Infographics 1
- Project: Infographics 2
08. AI for PowerPoint
- Building PPTs using AI
- Creating presentations using Gamma & Pi
09. AI for Excel & Word
- Creating Excel and Word files using ChatGPT & Claude
- Creating Word documents using AI
10. Final Assessment
- Test covering Word, PowerPoint & Excel
Contact Us
FAQ
What kind of skills will I be able to gain after learning Microsoft Office?
You will be able to handle different types of data, create your own documents and improve how you communicate in any workplace.
What is the Microsoft Office course inclusive of?
The course includes PowerPoint, Outlook, Word and Excel, which offer both practical and theoretical knowledge as well as real-life tasks.
Is the Microsoft Office course the foundational knowledge for computer lessons?
Yes, it is. It helps you attain the fundamental knowledge and skills, which makes it easier to attain advanced knowledge.
Will I be able to get a job with Microsoft Office skills?
It is possible to get a job, but most companies regard it as general knowledge and skills, unlike stand-alone skills.
Will I be able to learn automotive skills?
Yes, the course incorporates automation lessons which help you learn how to save time and reduce workload for your tasks.
Will I be able to learn how to integrate AI with Microsoft?
Yes, the course incorporates a module that teaches you how to incorporate AI in Microsoft.
Am I going to miss out on other practical courses if I choose online learning mode?
No, it doesn’t; you will be able to complete it on time and receive all the lessons with dedicated trainers.
