There are four specific reasons for which this course you can’t miss –
- First of all, at a professional level whatever functions and formula you need to work with, you will learn everything here and it includes not only basic functions but advanced functions as well.
- All you need to do this course is a computer/laptop and an internet connection. You can do this course at your pace, as per your convenience and as and when you would like to do it.
- This course is designed in such a way that you would get maximum retention after learning.
- You will also get lifetime access to the course materials. And you will also get verifiable certificate of completion for each course.

Session 1: Getting Familiar

• 1.01 Introduction
• 1.02 Interface Overview
• 1.03 Common Buttons, Tabs and Ribbons

Session 2: Document Navigation Tips

• 2.01 Introduction
• 2.02 How Navigation Tips Help
• 2.03 Using The Slider
• 2.04 Keyboard Navigation Tips
• 2.05 Using Browse Objects Tools
• 2.06 Selecting Text Options

Session 3: Manipulating Text

• 3.01 Introduction
• 3.02 Page Layout
• 3.03 Cut, Copy, Paste, Move
• 3.04 Find and Replace

Session 4: Formatting Characters

• 4.01 Introduction
• 4.02 How Formatting Makes a Difference
• 4.03 Changing Fonts
• 4.04 Typical Text Format Options
• 4.05 Bullet and Numbered Lists
• 4.06 Other Formatting Tools

Session 5: Formatting Paragraphs

• 5.01 Introduction
• 5.02 Line Spacing
• 5.03 What Are Quick Styles
• 5.04 More Quick Styles
• 5.05 Creating A New Quick Style
• 5.06 Paragraph Marks

Session 6: Themes and Templates

• 6.01 Introduction
• 6.02 Applying Themes
• 6.03 Opening Existing Templates
• 6.04 Creating Templates
• 6.05 Working With Existing Content

Session 7: Quick Parts

• 7.01 Introduction
• 7.02 Quick Parts - Options
• 7.03 Creating Quick Parts
• 7.04 Quick Parts - Inserting Fields
• 7.05 Quick Parts - Inserting Images

Session 8: Preparing Documents for Printing

• 8.01 Introduction
• 8.02 Spelling and Grammar Check
• 8.03 Saving A Document
• 8.04 Printing And Preview Options

Session 9: Organizing Content

• 9.01 Introduction
• 9.02 Creating Lists
• 9.03 Creating and Formatting Tables
• 9.04 Converting Text To Tables
• 9.05 Table Borders and Shading

Session 10: Tabs, Columns, and Charts

• 10.01 Introduction
• 10.02 Creating Columns
• 10.03 Creating Tabular Lists
• 10.04 Creating Charts

Session 11: Links, Headers, and Footers

• 11.01 Introduction
• 11.02 Creating Web Links
• 11.03 Creating Document Location Links
• 11.04 Creating Email Links
• 11.05 Creating Headers and Footers

Session 12: References

• 12.01 Introduction
• 12.02 Bookmarks
• 12.03 Captions
• 12.04 Footnotes
• 12.05 Citations
• 12.06 Reference Styles for Research
• 12.07 Research Options
• 12.08 Creating Indexes
• 12.09 Bibliographies
• 12.10 Table of Figures
• 12.11 Table of Contents
• 12.12 Cross Reference Bookmarks
• 12.13 Cross Reference Page Numbers

Session 13: Mail Merge

• 13.01 Introduction
• 13.02 Mail Merge for Letters
• 13.03 Mail Merge for Envelopes
• 13.04 Mail Merge for Labels

Session 14: Visual Content

• 14.01 Introduction
• 14.02 Character Spacing
• 14.03 Inserting Shapes
• 14.04 Inserting Images
• 14.05 Using Word Art
• 14.06 Using Pull Quotes
• 14.07 Using Text Boxes
• 14.08 Sorting Text
• 14.09 Using Smart Art

Session 15: Reviewing Documents

• 15.01 Introduction
• 15.02 Document Views
• 15.03 Split Screen View
• 15.04 Tracking Changes
• 15.05 Collaboration Options
• 15.06 Combining and Approving Changes
• 15.07 Using Comments

Session 16: Protecting and Sharing Documents

• 16.01 Introduction
• 16.02 Compatibility Checker
• 16.03 Previous Word Versions Compatibility
• 16.04 Digital Signatures
• 16.05 Restricting Permissions

Session 1: Introduction

• 1.01 Introduction
• 1.02 Interface
• 1.03 Tabs and Ribbons
• 1.04 Document Windows
• 1.05 Navigation Tips
• 1.06 Office Button and Save

Session 2: Entering, Editing and Formatting Data

• 2.01 Introduction
• 2.02 Entering Data
• 2.03 Fonts, Fills, and Alignment
• 2.04 Cut, Copy, and Paste
• 2.05 Paste Special
• 2.06 Undo and Redo
• 2.07 Moving, Finding, and Replacing a Value
• 2.08 Cell Styles
• 2.09 Comments

Session 3: Formatting Numbers

• 3.01 Introduction
• 3.02 Currency Format
• 3.03 Format Painter
• 3.04 Formatting Dates
• 3.05 Custom and Special Formats

Session 4: Managing Worksheets

• 4.01 Introduction
• 4.02 Naming and Moving Worksheets
• 4.03 Copying Worksheets
• 4.04 Adding, Deleting and Hiding Worksheets
• 4.05 Grouping Worksheets
• 4.06 Moving, Copying, Deleting and Hiding Grouped Worksheets

Session 5: Modifying Rows and Columns

• 5.01 Introduction
• 5.02 Inserting and Deleting Columns and Rows
• 5.03 Inserting & Deleting Cells
• 5.04 Inserting Multiple Columns & Rows
• 5.05 Modifying Cell Width and Height
• 5.06 Hiding and Unhiding Rows and Columns

Session 6: Understanding Formulas

• 6.01 Introduction
• 6.02 Using Operations
• 6.03 Creating Formulas
• 6.04 AutoSum
• 6.05 Common Formulas
• 6.06 Searching for Formulas
• 6.07 Copying Formulas
• 6.08 Using Relative and Absolute References

Session 7: Changing Views

• 7.01 Introduction
• 7.02 Workbook Views
• 7.03 Show/Hide
• 7.04 Zoom Features
• 7.05 Freeze Panes
• 7.06 Split Windows
• 7.07 Viewing Multiple Windows
• 7.08 Minimize The Ribbon
• 7.09 Worksheet Backgrounds
• 7.10 Watermarks

Session 8: AutoFill and Custom Lists

• 8.01 Introduction
• 8.02 AutoFill a Series
• 8.03 AutoFill Non-Adjacent Cells
• 8.04 AutoFill on Multiple Sheets
• 8.05 Creating Custom Lists
• 8.06 Series Formatting

Session 9: Conditional Formatting

• 9.01 Introduction
• 9.02 Highlight Cells Rules
• 9.03 Top/Bottom Rules
• 9.04 Data Bars
• 9.05 Color Scales
• 9.06 Custom Formatting Rule

Session 10: Tables

• 10.01 Introduction
• 10.02 Insert a Table and Style Options
• 10.03 Add Rows and Columns
• 10.04 Perform a Function in a Table
• 10.05 Summarise With Pivot Table

Session 11: Data Tools

• 11.01 Introduction
• 11.02 Data Validation
• 11.03 Drop-Down Lists
• 11.04 Removing Duplicates
• 11.05 Text To Columns
• 11.06 Goal Seek
• 11.07 Scenario Manager

Session 12: Referencing Formulas

• 12.01 Introduction
• 12.02 Multiple Sheet References
• 12.03 Consolidating Data - With or Without Links
• 12.04 Trace the Precedents and Dependents
• 12.05 Using the Watch Window

Session 13: Ranges and Dates

• 13.01 Introduction
• 13.02 Cell Names
• 13.03 Named Ranges
• 13.04 Formulas with Cell Names
• 13.05 Date Formulas

Session 14: Lookups

• 14.01 Introduction
• 14.02 VLOOKUP
• 14.03 VLOOKUP Exact Match
• 14.04 HLOOKUP
• 14.05 HLOOKUP Exact Match

Session 15: Conditional Logic

• 15.01 Introduction
• 15.02 IF Statement
• 15.03 Nested IF
• 15.04 AND
• 15.05 OR
• 15.06 NOT
• 15.07 IFERROR
• 15.08 SUMIF
• 15.09 AVERAGEIF
• 15.10 COUNTIF & COUNTIFS
• 15.11 SUMIFS
• 15.12 AVERAGEIFS

Session 16: Text Formulas

• 16.01 Introduction
• 16.02 Case Formulas
• 16.03 Fix Number Fields
• 16.04 Trim Spaces
• 16.05 Substitute Text

Session 17: Introduction to Charts

• 17.01 Introduction
• 17.02 Chart Types
• 17.03 Instant Chart
• 17.04 Update Chart
• 17.05 Column Chart
• 17.06 Picture Fill
• 17.07 Adjust Chart Size
• 17.08 Line Chart
• 17.09 Scatter Chart

Session 18: Formatting Charts

• 18.01 Introduction
• 18.02 Chart Styles
• 18.03 Chart Layouts
• 18.04 Add Labels
• 18.05 Axis Options
• 18.06 Chart Title
• 18.07 Legends
• 18.08 Data Labels

Session 19: Adding Graphics to Spreadsheets

• 19.01 Introduction
• 19.02 Insert Pictures
• 19.03 Modifying Pictures
• 19.04 Insert Shapes
• 19.05 Insert SmartArt
• 19.06 Apply Themes
• 19.07 Arrange

Session 20: Outline, Sort, Filter, and Subtotal

• 20.01 Introduction
• 20.02 Group and Ungroup
• 20.03 Sort Data
• 20.04 Sort Multiple Levels
• 20.05 Filter Data
• 20.06 Advanced Filter
• 20.07 Conditional Sorting and Filtering
• 20.08 Sorting with Custom Lists
• 20.09 Subtotal

Session 21: PivotTables

• 21.01 Introduction
• 21.02 Creating PivotTables
• 21.03 Choosing Fields
• 21.04 PivotTable Layout
• 21.05 Filtering PivotTables
• 21.06 Modifying PivotTable Data
• 21.07 PivotCharts

Session 22: Protecting Data

• 22.01 Introduction
• 22.02 Workbook Passwords
• 22.03 Protecting Workbooks
• 22.04 Unlocking Cells

Session 23: Collaboration

• 23.01 Introduction
• 23.02 Document Properties
• 23.03 Inserting Hyperlinks
• 23.04 Sharing a Workbook
• 23.05 Track Changes
• 23.06 Accept/Reject Changes
• 23.07 Mark as Final

Session 24: Printing

• 24.01 Introduction
• 24.02 Page Orientation
• 24.03 Page Breaks
• 24.04 Print Area
• 24.05 Margins
• 24.06 Print Titles
• 24.07 Headers and Footers
• 24.08 Scaling
• 24.09 Sheet Options

Session 25: Saving a Workbook

• 25.01 Introduction
• 25.02 Save As Previous Version
• 25.03 AutoRecover Save Options
• 25.04 Templates
• 25.05 Save As PDF
• 25.06 Save As Web Page
• 25.07 Macro-Enabled Workbook

Session 26: Macros

• 26.01 Introduction and Macro Security
• 26.02 Recording a Macro
• 26.03 Assign a Macro to a Button or Shape
• 26.04 Run a Macro upon Opening a Workbook
• 26.05 How to Inspect and Modify a Macro

Session 1: Create a Presentation

• 1.01 Create a new presentation
• 1.02 Create a presentation based on a template
• 1.03 Import Word document outlines

Session 2: Insert and Format Slides

• 2.01 Insert specific slide layouts
• 2.02 Duplicate existing slides
• 2.03 Hide and unhide slides
• 2.04 Delete slides
• 2.05 Apply a different slide layout
• 2.06 Modify individual slide backgrounds
• 2.07 Inset slide headers, footers, and page numbers

Session 3: Modify Slides, Handouts, and Notes

• 3.01 Change the slide master theme or background
• 3.02 Modify slide master content
• 3.03 Create a slide layout
• 3.04 Modify a slide layout
• 3.05 Modify the handout master
• 3.06 Modify the notes master

Session 4: Order and Group Slides

• 4.01 Create sections
• 4.02 Modify slide order
• 4.03 Rename sections

Session 5: Change Presentation Options and Views

• 5.01 Change slide size
• 5.02 Change views of a presentation
• 5.03 Set file properties

Session 6: Configure a Presentation for Print

• 6.01 Print all or part of a presentation
• 6.02 Print notes pages
• 6.03 Print handouts
• 6.04 Print in color, grayscale, or black and white

Session 7: Configure and Present a Slide Show

• 7.01 Create custom slide shows
• 7.02 Configure slide show options
• 7.03 Rehearse slide show timing
• 7.04 Present a slide show by using Presenter View

Session 8: Insert and Format Text

• 8.01 Insert text on a slide
• 8.02 Apply formatting and styles to text
• 8.03 Apply WordArt styles to text
• 8.04 Format text in multiple columns
• 8.05 Create bulleted and numbered lists
• 8.06 Insert hyperlinks

Session 9: Insert and Format Shapes and Text Boxes

• 9.01 Insert or replace shapes
• 9.02 Insert text boxes
• 9.03 Resize shapes and text boxes
• 9.04 Format shapes and text boxes
• 9.05 Apply styles to shapes and text boxes

Session 10: Insert and Format Images

• 10.01 Insert images
• 10.02 Resize and crop images
• 10.03 Apply styles and effects

Session 11: Order and Group Objects

• 11.01 Order objects
• 11.02 Align objects
• 11.03 Group objects
• 11.04 Display alignment tools

Session 12: Insert and Format Tables

• 12.01 Create a table
• 12.02 Insert and delete table rows and columns
• 12.03 Apply table styles
• 12.04 Import a table

Session 13: Insert and Format Charts

• 13.01 Create a chart
• 13.02 Import a chart
• 13.03 Change the Chart Type
• 13.04 Add a legend to a chart
• 13.05 Change the chart style of a chart

Session 14: Insert and Format SmartArt graphics

• 14.01 Create SmartArt graphics
• 14.02 Convert lists to SmartArt graphics
• 14.03 Add shapes to SmartArt graphics
• 14.04 Reorder shapes in SmartArt graphics
• 14.05 Change the color of SmartArt graphics

Session 15: Insert and Manage Media

• 15.01 Insert audio and video clips
• 15.02 Configure media playback options
• 15.03 Adjust media window size
• 15.04 Set the video start and stop time
• 15.05 Set media timing options

Session 16: Apply Slide Transitions

• 16.01 Insert slide transitions
• 16.02 Set transition effect options

Session 17: Animate Slide Content

• 17.01 Apply animations to objects
• 17.02 Apply animations to text
• 17.03 Set animation effect options
• 17.04 Set animation paths

Session 18: Set Timing for Transitions and Animations

• 18.01 Set transition effect duration
• 18.02 Configure transition start and finish options
• 18.03 Reorder animations on a slide

Session 19: Merge Content from Multiple Presentations

• 19.01 Inset slides from another presentation
• 19.02 Compare two presentations
• 19.03 Insert comments
• 19.4 Review comments

Session 20: Finalize Presentations

• 20.01 Protect a presentation
• 20.02 Inspect a presentation
• 20.03 Proof a presentation
• 20.04 Preserve presentation content
• 20.05 Export presentations to other formats

Session 1: Create and Modify Databases

• 1.01 Create a blank desktop database
• 1.02 Create a database from a template
• 1.03 Create a database by using Import objects or
  
  data from other sources
• 1.04 Delete database objects

Session 2: Manage Relationships and Keys

• 2.01 Create and modify relationships
• 2.02 Set the primary key
• 2.03 Enforce referential integrity
• 2.04 Set foreign keys
• 2.05 View relationships

Session 3: Navigate through a Database

• 3.01 Navigate specific records
• 3.02 Create and modify a navigation form
• 3.03 Set a form as the startup option
• 3.04 Display objects in the Navigation Pane
• 3.05 Change views of objects

Session 4: Protect and Maintain Databases

• 4.01 Compact a database
• 4.02 Repair a database
• 4.03 Back up a database
• 4.04 Split a database
• 4.05 Encrypt a database with a password
• 4.06 Recover data from backup

Session 5: Print and Export Data

• 5.01 Print reports
• 5.02 Print records
• 5.03 Save a database as a template
• 5.04 Export objects to alternative formats

Session 6: Create Tables

• 6.01 Create a table
• 6.02 Import data into tables
• 6.03 Create linked tables from external sources
• 6.04 Import tables from other databases
• 6.05 Create a table from a template with application
  
  parts

Session 7: Manage Tables

• 7.01 Hide fields in tables
• 7.02 Add total rows
• 7.03 Add table descriptions
• 7.04 Rename tables

Session 8: Manage Records in Tables

• 8.01 Update records
• 8.02 Add records
• 8.03 Delete records
• 8.04 Append records from external data
• 8.05 Find and replace data
• 8.06 Sort records
• 8.07 Filter records

Session 9: Create and Modify Fields

• 9.01 Add fields to tables
• 9.02 Add validation rules to fields
• 9.03 Change field captions
• 9.04 Change field sizes
• 9.05 Change field data types
• 9.06 Configure fields to auto-increment
• 9.07 Set default values
• 9.08 Using input masks
• 9.09 Delete fields

Session 10: Create a Query

• 10.01 Run a query
• 10.02 Create a crosstab query
• 10.03 Create a parameter query
• 10.04 Create an action query
• 10.05 Create a multi-table query
• 10.06 Save a query

Session 11: Modify a Query

• 11.01 Rename a query
• 11.02 Add fields
• 11.03 Remove fields
• 11.04 Hide fields
• 11.05 Sort data within queries
• 11.06 Format fields within queries

Session 12: Create Calculated Fields and Grouping within Queries

• 12.01 Add calculated fields
• 12.02 Set filtering criteria
• 12.03 Group and summarize data
• 12.04 Group data by using comparison operators
• 12.05 Group data by using arithmetic and logical
  
  operators

Session 13: Create a Form

• 13.01 Create a form
• 13.02 Create a form from a template with application
  
  parts
• 13.03 Save a form

Session 14: Configure Form Controls

• 14.01 Move form controls
• 14.02 Add form controls
• 14.03 Modify data sources
• 14.04 Remove form controls
• 14.05 Set form control properties
• 14.06 Manage labels
• 14.07 Add sub-forms

Session 15: Format a Form

• 15.01 Modify tab order
• 15.02 Configure Print settings
• 15.03 Sort records by form field
• 15.04 Apply a theme
• 15.05 Control form positioning
• 15.06 Insert backgrounds
• 15.07 Insert headers and footers
• 15.08 Insert images

Session 16: Create a Report

• 16.01 Create a report based on the query or table
• 16.02 Create a report in Design view
• 16.03 Create a report by using a wizard

Session 17: Configure Report Controls

• 17.01 Group and sort fields
• 17.02 Modify data sources
• 17.03 Add report controls
• 17.04 Add and modify labels

Session 18: Format a Report

• 18.01 Format a report into multiple columns
• 18.02 Add calculated fields
• 18.03 Control report positioning
• 18.04 Format report elements
• 18.05 Change report orientation
• 18.06 Insert header and footer information
• 18.07 Insert images
• 18.08 Apply a theme