Course Description
This course covers covers four modules: MS Excel for data analysis and visualization, MS Word for document creation, MS PowerPoint for impactful presentations, and Data Management for organizing and storing information effectively. Whether you're a student, professional, or entrepreneur, this course equips you with the skills to work smarter and achieve your goals.
Lectures
Each lecture in the MS Office course covers key modules: MS Excel for data analysis and visualization, MS Word for professional document creation, MS PowerPoint for impactful presentations, and Data Management for organizing and storing information. Attend the demo lecture to get an idea and gain practical skills to work smarter and achieve your goals.
Resources Overview
Access free downloadable PDFs that include book summaries, recommendations, practical reports, and shortcut guides for both Windows and Mac. These resources are designed to enhance your learning experience and boost productivity across all modules.
Demo Lectures
1. Advance Excel
Topic 1. Introduction
Introduction-1
Topic 2. Mathematical Function Part1
Mathematical Function Part1-1
Topic 3. Mathematical Function Part2
Mathematical Function Part2-1
Topic 4. Conditional Formatting
Conditional Formatting-1
Topic 5. Absolute and Relative Reference
Absolute and Relative Reference-1
Topic 6. Other Functions
Other Functions-1
Format Copy Paste-1
7 seconds | 7 shortcuts-1
Shortcut to G-Apps-1
Sequence Shortcut-1
Alt Shortcut-1
2. MS Word
Topic 1. Track Changes
Track Changes-1
3. MS PowerPoint
Topic 1. Home Slide Approach
Home Slide Approach-1
Module Overview
Category Functions/Features Mathematical Sum, Sumproduct, Average, Averagea, Min, Mina, Max, Maxa, Small, Large, Abs, Count, Countblank, Counta, Aggregate, Mod, Rank, Absolute and Relative Referencing Paste Special Value, Format, Transpose, Link, Add, Subtract, Product and Many Useful Features Rounding Functions Round, Roundup, Rounddown (Also to nearest Tens, Hundreds and Thousands), Ceiling, Floor, and Mround Date Day, Date, Month, Year, Now, Today, Cleaning and Formatting Text Functions Trim, Concatenate, ‘&’, Lower, Proper, Upper, and Value Advance Text Left, Right, Mid, Replace, Substitute, Find, Len, Working With ‘*’ For Data Cleaning, Text To Column, and Other Advanced Data Cleaning Techniques Shortcuts Smart Editing Techniques, Learning Useful Shortcuts The Easy Way, and Formatting Lookup Functions Vlookup, Hlookup, and Automation Of The Same Logical Operators If, Nested If, And, Or, Isna, Iserror, Iserr, Isblank, Istext, Isformula, and XOR Conditional Formatting Basic Conditional Formatting (Formatting using Formulas covered in next Module) Array Functions Array formulas, Array constant, Create one dimensional and two dimensional constants, Dynamic Transpose
| Category | Functions/Features |
|---|---|
| Mathematical | Sum, Sumproduct, Average, Averagea, Min, Mina, Max, Maxa, Small, Large, Abs, Count, Countblank, Counta, Aggregate, Mod, Rank, Absolute and Relative Referencing |
| Paste Special | Value, Format, Transpose, Link, Add, Subtract, Product and Many Useful Features |
| Rounding Functions | Round, Roundup, Rounddown (Also to nearest Tens, Hundreds and Thousands), Ceiling, Floor, and Mround |
| Date | Day, Date, Month, Year, Now, Today, Cleaning and Formatting |
| Text Functions | Trim, Concatenate, ‘&’, Lower, Proper, Upper, and Value |
| Advance Text | Left, Right, Mid, Replace, Substitute, Find, Len, Working With ‘*’ For Data Cleaning, Text To Column, and Other Advanced Data Cleaning Techniques |
| Shortcuts | Smart Editing Techniques, Learning Useful Shortcuts The Easy Way, and Formatting |
| Lookup Functions | Vlookup, Hlookup, and Automation Of The Same |
| Logical Operators | If, Nested If, And, Or, Isna, Iserror, Iserr, Isblank, Istext, Isformula, and XOR |
| Conditional Formatting | Basic Conditional Formatting (Formatting using Formulas covered in next Module) |
| Array Functions | Array formulas, Array constant, Create one dimensional and two dimensional constants, Dynamic Transpose |
Category Functions/Features Introduction Basic formatting, navigation pane, quick access toolbar, ribbon, header and footer bullet points, symbols, bookmarks, hyperlinks. Page Layout Modification Paper margin, inserting columns, page colour, page border, watermark, page break, alignment, line spacing, use of indents, justification, numbering and bullets. Designing Tables, charts, wrapping, positioning, resizing, smart-art, customizing the document, style set colours, creating quick styles, themes and restrict the formatting, converting a text into table and rows, creating a form, comments, split windows, multiple windows. Review Grammar and spell check, use of word count, thesaurus and translation, how to set options for print, track changes. Mail Merge Automation of billing processes using Excel database and mail merge functions. MS Word Tricks Auto generation of table of contents, cool shortcuts, and quick formatting techniques, spike test, page layouts.
| Category | Functions/Features |
|---|---|
| Introduction | Basic formatting, navigation pane, quick access toolbar, ribbon, header and footer bullet points, symbols, bookmarks, hyperlinks. |
| Page Layout Modification | Paper margin, inserting columns, page colour, page border, watermark, page break, alignment, line spacing, use of indents, justification, numbering and bullets. |
| Designing | Tables, charts, wrapping, positioning, resizing, smart-art, customizing the document, style set colours, creating quick styles, themes and restrict the formatting, converting a text into table and rows, creating a form, comments, split windows, multiple windows. |
| Review | Grammar and spell check, use of word count, thesaurus and translation, how to set options for print, track changes. |
| Mail Merge | Automation of billing processes using Excel database and mail merge functions. |
| MS Word Tricks | Auto generation of table of contents, cool shortcuts, and quick formatting techniques, spike test, page layouts. |
Category Functions/Features Introduction The Ribbon, Quick access toolbar, customising the ribbon, different views of a presentation (Normal, Outline View, Slide sorter, Notes page, Reading View and Slide show). Create a Presentation Blank presentations, presentation using templates, searching for templates, importing word document outlines into presentations, adding slides, creating hyperlinks, changing layouts and exploring the outline. Quick Formatting Techniques Adding text, table, charts graphs, pictures (resizing, cropping, applying effects and styles), media, changing themes and colors, configure presentation to print or save, dos and don’ts of a presentation. Working with Slides Duplicating existing slides, hiding slides, deleting slides, modifying slide background, applying styles to slides, inserting transitions between slides, order and group slides. Shapes, Alignment & Distribution Tricks to insert, format, align, group, and distribute shapes in PowerPoint within seconds, format dipper, default shapes, merge shape, etc. SmartArt Insert, add text to, and format SmartArt graphics to quickly add diagrams to your presentation which will assist you to tell your story. Adding and Editing Charts Select the right chart for your data, add it to a slide, know the basics of editing charts and quickly format charts. Slide Master and Sections for Organization How to manipulate PowerPoint presentations with the slide master, creating customised slides, sections, viewing modes, header and footer. Insert and format Media Insert video from another file, adjusting media window size, trimming timings on media clips, screen recording and adding audio to the presentation. Animate slide Content Applying animations to shapes and text, adding paths to animations, modifying animation options, recording animations and using the animation pane. Using Excel and Word Data PowerPoint shortcuts and automation techniques, linking of Excel data with PPT. Creating Impact Emerging trends on visual effects such as magnifiers, highlighters, de-highlighters, cut-outs, layers, topic trackers. Speed Tricks Lightning fast shortcuts and custom tricks to perform recurring activities such as alignment, editing text, cloning shapes, working with SmartArt etc. Delivering the Presentation Using techniques like home slide approach, exploring slide show options, using presenter view, slide notes.
| Category | Functions/Features |
|---|---|
| Introduction | The Ribbon, Quick access toolbar, customising the ribbon, different views of a presentation (Normal, Outline View, Slide sorter, Notes page, Reading View and Slide show). |
| Create a Presentation | Blank presentations, presentation using templates, searching for templates, importing word document outlines into presentations, adding slides, creating hyperlinks, changing layouts and exploring the outline. |
| Quick Formatting Techniques | Adding text, table, charts graphs, pictures (resizing, cropping, applying effects and styles), media, changing themes and colors, configure presentation to print or save, dos and don’ts of a presentation. |
| Working with Slides | Duplicating existing slides, hiding slides, deleting slides, modifying slide background, applying styles to slides, inserting transitions between slides, order and group slides. |
| Shapes, Alignment & Distribution | Tricks to insert, format, align, group, and distribute shapes in PowerPoint within seconds, format dipper, default shapes, merge shape, etc. |
| SmartArt | Insert, add text to, and format SmartArt graphics to quickly add diagrams to your presentation which will assist you to tell your story. |
| Adding and Editing Charts | Select the right chart for your data, add it to a slide, know the basics of editing charts and quickly format charts. |
| Slide Master and Sections for Organization | How to manipulate PowerPoint presentations with the slide master, creating customised slides, sections, viewing modes, header and footer. |
| Insert and format Media | Insert video from another file, adjusting media window size, trimming timings on media clips, screen recording and adding audio to the presentation. |
| Animate slide Content | Applying animations to shapes and text, adding paths to animations, modifying animation options, recording animations and using the animation pane. |
| Using Excel and Word Data | PowerPoint shortcuts and automation techniques, linking of Excel data with PPT. |
| Creating Impact | Emerging trends on visual effects such as magnifiers, highlighters, de-highlighters, cut-outs, layers, topic trackers. |
| Speed Tricks | Lightning fast shortcuts and custom tricks to perform recurring activities such as alignment, editing text, cloning shapes, working with SmartArt etc. |
| Delivering the Presentation | Using techniques like home slide approach, exploring slide show options, using presenter view, slide notes. |
Category Functions/Features Advance Logical Countif, Sumif, Averageif, Sumifs, Countifs, Averageifs, Its application in dashboards. Advance Date Workday, Networkday, Workday.Intl, Networkday.Intl, EOMonth & Datedif. Database Dsum, Dmax & Daverage Table Table Format, Automatic updation of formulas, Slicer Cell Naming Name range, Dynamic Naming, Application Data Validation Data Validation, Lists, Rules, Input and Error Messages and Basic Form Controls, Designing Forms, Dynamic Drop-down Lookup & Reference Functions 3-D Vlookup, Fuzzy lookup, Index and Match, combining match with Vlookup, Choose, Indirect, Offset, Application Advance Filter Single and multiple-level subtotals, subtotal formula, group ungroup, unique values, custom filters & Advance Slicer. Remove Duplicates Various techniques to remove duplicates, extract unique values and to compare lists and compile data. Data Cleaning Goto Special, cleaning techniques for imported data to avoid error, Using Filters to Clean Data. Array Functions Array formulas, Array constant, Create one dimensional and two dimensional constants, Dynamic Transpose. Circular References Understanding model circularity & why some professionals use it and others don’t, Locating and managing circular reference and eliminating non-intentional circular references. Security & Sharing Unlocking cells & protecting worksheets, Sharing workbooks, Tracking changes Formula Auditing Techniques Check Formulas, Spot errors, Linking and cleaning Techniques, Tracing Precedents and Dependents. Advance Charts Thermometer, Speedometer, Sparklines, Target Charts, Gantt Charts, Form Controls Based Dynamic Charts Macros Run, record, use, save and work with them VBA Code Snippets To be able to use free VBA code snippets available online and use them to perform certain tasks like convert a number in word form Customizing Ribbon Have your own ribbon like File, View with your designed Functions to perform repetitive tasks, automation and extremely useful time saving technique. Scenario Manager Scenario analysis, Goal Seek, Data Table, use of macros to make it user friendly Sensitivity Analysis Running Sensitivity Analysis with Drop-down menus or Data Validation Tools Dashboard Preparation Dashboard for MIS, Analysis, different dashboards for different business segments, Auto report Generation–100s with a click, Calculated Fields, Using Slicers, Connect a slicer to pivot tables from different sources and easy formatting techniques (formulas like offset, advance formatting, macros, hyperlink, etc. in creating Dashboards)
| Category | Functions/Features |
|---|---|
| Advance Logical | Countif, Sumif, Averageif, Sumifs, Countifs, Averageifs, Its application in dashboards. |
| Advance Date | Workday, Networkday, Workday.Intl, Networkday.Intl, EOMonth & Datedif. |
| Database | Dsum, Dmax & Daverage |
| Table | Table Format, Automatic updation of formulas, Slicer |
| Cell Naming | Name range, Dynamic Naming, Application |
| Data Validation | Data Validation, Lists, Rules, Input and Error Messages and Basic Form Controls, Designing Forms, Dynamic Drop-down |
| Lookup & Reference Functions | 3-D Vlookup, Fuzzy lookup, Index and Match, combining match with Vlookup, Choose, Indirect, Offset, Application |
| Advance Filter | Single and multiple-level subtotals, subtotal formula, group ungroup, unique values, custom filters & Advance Slicer. |
| Remove Duplicates | Various techniques to remove duplicates, extract unique values and to compare lists and compile data. |
| Data Cleaning | Goto Special, cleaning techniques for imported data to avoid error, Using Filters to Clean Data. |
| Array Functions | Array formulas, Array constant, Create one dimensional and two dimensional constants, Dynamic Transpose. |
| Circular References | Understanding model circularity & why some professionals use it and others don’t, Locating and managing circular reference and eliminating non-intentional circular references. |
| Security & Sharing | Unlocking cells & protecting worksheets, Sharing workbooks, Tracking changes |
| Formula Auditing Techniques | Check Formulas, Spot errors, Linking and cleaning Techniques, Tracing Precedents and Dependents. |
| Advance Charts | Thermometer, Speedometer, Sparklines, Target Charts, Gantt Charts, Form Controls Based Dynamic Charts |
| Macros | Run, record, use, save and work with them |
| VBA Code Snippets | To be able to use free VBA code snippets available online and use them to perform certain tasks like convert a number in word form |
| Customizing Ribbon | Have your own ribbon like File, View with your designed Functions to perform repetitive tasks, automation and extremely useful time saving technique. |
| Scenario Manager | Scenario analysis, Goal Seek, Data Table, use of macros to make it user friendly |
| Sensitivity Analysis | Running Sensitivity Analysis with Drop-down menus or Data Validation Tools |
| Dashboard Preparation | Dashboard for MIS, Analysis, different dashboards for different business segments, Auto report Generation–100s with a click, Calculated Fields, Using Slicers, Connect a slicer to pivot tables from different sources and easy formatting techniques (formulas like offset, advance formatting, macros, hyperlink, etc. in creating Dashboards) |
Still have questions or need further clarification? Feel free to connect with us!
Know More
Courses
Subscribe to Our Website
Stay updated with announcements & mentor guidance!