Introduction of Interview Mastery Preview

Why do we take interviews?

Skills you need to crack an Interview

4 simple hack to crack interviews

Answering questions correctly

Creating your first impression

What to do what not to?

Answering, Tell me about yourself?

Answering, What is your greatest strength?

Using SAR technique while answering questions

Why do you want to leave your current role?

Talk about your most challenging project

Tell me about something you have accomplished

Talking about our employment Gaps

Top 3 frequently asked questions

Most important interview questions

How to talk about your failure and mistakes?

Answering, How you worked with a difficult person?

How to talk about your leadership style?

Any question for me?

Power Point Introduction Preview

Getting Started with Power Point

Getting Started with Power Point Part 2

Select a Presentation Type - Developing a Power Point Presentation

Edit Text - Developing a Power Point Presentation

Format Characters - Performing Advanced Text Editing Operations

Format Paragraphs - Performing Advanced Text Editing Operations

Format Text Boxes - Performing Advanced Text Editing Operations

Insert Shapes - Adding Graphical Elements to Your Presentation

Insert Images - Adding Graphical Elements to Your Presentation

Insert Video - Adding Graphical Elements to Your Presentation

Edit Objects - Modifying Objects in Your Presentation

Group Objects - Modifying Objects in Your Presentation

Animate Objects - Modifying Objects in Your Presentation

Create a Table - Adding Tables to Your Presentation

Format a Table - Adding Tables to Your Presentation

Insert a Table from Other Microsoft Office Applications - Adding Tables to Your Presentation

Create a Chart - Adding Charts to Your Presentation

From Microsoft Excel - Adding Charts to Your Presentation

Review Your Presentation - Preparing to Deliver Your Presentation

Apply Transitions - Preparing to Deliver Your Presentation

Print Your Presentation - Preparing to Deliver Your Presentation

Deliver Your Presentation - Preparing to Deliver Your Presentation

MS Word Introduction Preview

MS Word Basics Part 1

MS Word Basics Part 2

Formatting Text Part 1

Formatting Text Part 2

Formatting Text Part 3

Paragraph Formatting Part 1

Paragraph Formatting Part 2

Page Layout and Design Part 1

Page Layout and Design Part 2

Working with Tables Part 1

Working With Tables Part 2

Inserting And Formatting Graphics Part 1

Inserting And Formatting Graphics Part 2

Working with Styles and Themes Part 1

Working with Styles and Themes Part 2

Managing References and Citations Part1

Managing References and Citations Part2

Managing References and Citations Part3

Collaboration and Reviewing Part 1

Collaboration and Reviewing Part 2

Mail Merge and Automation Part 1

Mail Merge and Automation Part 2

Advanced Formatting Techniques Part1

Advanced Formatting Techniques Part2

Finalizing And Printing Documents Part1

Finalizing And Printing Documents Part2

Finalizing And Printing Documents Part3

Excel introduction Preview

Introduction & basics of MS Excel

Tabs & Groups

Editing Data

Formatting

Cell Referencing

Speak Cells

Text To Columns

Comments

Copying & Filling

Advanced Fill

Flash Fill

Viewing Worksheets

Custom Views

Adjusting a worksheet

Working with worksheets

Comparing two sheets side by side

Logical tests

IF and Nested IF

And Function

Not and If Error

Auditing & Evaluating Formulas

Text Functions

Date Function part 1

Date Function part 2

Basic Formulas

Count Functions

Name Range

Advanced IF Functions

Advanced Mathematical Functions

VLOOKUP

Vlookup Approx Match

HLookup

Index & Match

Data Sorting

Filtering Data

Tables - 1

Tables - 2

Subtotals

Conditional formatting - 1

Conditional formatting - 2

Data Validation

Dependent DV

Consolidation

Protection

Hyperlink

Insert & Create Objects

Pivot Table 1

Pivot Table 2

Pivot Table 3

Column Charts

Pie, Bar & Line Chart

Pivot Chart

Print Page setup

Header & Footer