माइक्रोसफ्ट अफिस प्याकेज |MS Office Word,Excel,Powerpoint

After Learning Style and pages sections, we will be able to use predefined styles. We will be familiar with new styles creations. We can correct our mistakes in words and paragraphs using replace and we can jump from one page to another page using go-to features. We can easily add multiple pages as per requirements.

You will learn here: 

• What are predefined styles and how to use them? 

• How to create custom styles? 

• How to use replace, goto, and find? 

• How to use Select text with similar formatting? 

• How to create multiple pages? 

We can create amazing powerful documents after using the pictures. You can add multiple images to create amazing types of documents. You can learn various types of elements about pictures after watching this video.

You can learn here :

• Picture styles

• Picture Borders

• Picture positions

• Picture wrap text and many more

Shapes are really powerful elements. You can create multiple useful things with the help of shapes, charts, and smartarts. Identity cards, certificates, and many more things can be created after learning shapes.

You will learn here: 

• Shapes

• Concept and Usage of Shapes

• What are the functions of shape fill? 

• How to use shape effects? 

• How to use Arrange section creatively to create awesome documents? 

• Shapes combination

• Charts creations

• Smart arts creation

Add-in makes Microsoft word more powerful. You can think of those add-ins as an extra power of Microsoft word. You can use various types of add-ins to your MS word? 

You will learn here : 

• What is an Add-inns store? 

• How to use Online video on MS word documents?

• Method to use Hyperlinks?

• Importance of Bookmark

• What is cross-reference? 

Header and footer help us to create many types of books and many more things. We can create attractive headers and footers using header and section. Page number-creation will be very easy after understanding this level.

You will learn here.

• What are the header footer and page number? 

• How to use text box? 

• Wordart importance and many more things? 

• How to use object, date & time, and drop cap?

• How to crate attractive awesome equations? 

How to create an awesome equation for your mathematical projects. You can also create an awesome equation after watching this session. We will create a few equations in this session.

You will learn here: 

• Awesome equation creation

• equation creation using structure

• Importance of equation structure

• Usage of symbols in equation

We will learn about the design and layout menu here. Those two menus are very useful to create awesome documents. Design and layout help us to do page set as per our requirements. We can do many types of page settings after watching this video.

You will learn here:

• Usage of margins

• Orientation and page sizes

• Columns and page background

• Custom columns

• Functions of themes

• Usage of Hyphenation

We can create an amazing table of contents using references. without knowing the table of content creation on MS word it will be incomplete.

You will learn here: 

• Table of contents

• Usage of footnotes

• Functions of citations and bibliography

• How to use captions on documents?

• How to create an index?

• How to use the table of authorities?

Microsoft word has a feature to create multiple documents in one click with the help of Mail merge. You can also able to use these features after watching this video.  You can create multiple bio-data, Identity cards, certificates, invitations card, applications, and many more things using mail mere.

You will learn here.

• Recipient creation

• Usage of template documents

• Address block

• Greeting lines

You will learn here : 

• Spelling and grammar

• Thesauraus

• word count and many more

The view helps us to change the document view methods. You can also change many types of views using views. You will be able to create macros and many more.

You will learn here: 

• functions of views section

• Usage of show/hide section

• Usage of zoom section

• Usage of window section

We will learn to create Certificate on this session.

We will create Identity card. You can also try to make the same identity card on your PC.

We will learn to use SUM, If & AND formulas with this project. You will learn the concept of those functions on MS excel.

Our main goal of the session is to learn the VLOOKUP function with the help of a price catalog. We will learn to create a price catalog also here.

We will learn to use COUNTIF functions using the employee attendance project.  You should be familiar with the COUNTIF function after watching this session.

We are doing this project because it may help you in the future also. You can establish your own organization in that scenario this project might help you

We will discuss two major functions to calculate depreciation in this session. You will be also able to calculate depreciation after watching this session.  We learn here to use SLN and DV Methods.

We will learn to combine a few functions in this session. In the future, you will also learn to creatively combine your favorite formulas.  We can create another new powerful function using our default functions or formulas.

We are creating an automatic student identity card for this project. Hoping that it will help you to create an amazing automatic identity card using Microsoft excel.

We will use VLOOKUP at an advanced level. We learn here to create amazing powerful cash invoice projects for your business and department store. We will learn to use our logic to calculate discounts, taxes, and many more things here.

Cash invoices may help you in the future if you also start your own business. You can use this cash invoice after watching this session by creating yourself.

Microsoft Excel home menu helps us to customize our data as per our requirements. We can use manipulate and format many things as per our requirements. Wrap text, Number categories, and many more things going to be discussed here.

You will learn here: 

• How to use borders in MS excel

• Usage of wrap text

• How to use orientation

• Conditional formatting

• Modification of cells, rows, and columns

• few functions [ sum, average, count & more] , fill

Insert menu of MS excel 2016 brings a few new features like 3d map, bing map, vision data visualizer, people graph, and many more. Many more features related to Microsoft excel going to be discussed in this session.

You will learn here : 

• How to use Pivot Table

• How to create awesome and attractive Charts

• How to use Add-ins

• usage of 3d maps

• functions of Sparklines

• Usage of filters 

Using page layout you can do many types of page settings as per your requirement same like the Microsoft word. we will discuss a few new things related to page layout which are not mentioned in our Microsoft word page layout class.

We will learn here: 

• How to use print area

• Functions of print titles

• How to use a scale to fit? 

• usage of shit options.

The formula is a powerful menu that is available in Microsoft excel. Using formulas and functions we can calculate many things. we can create, filter, manipulate our data as per our requirements.

Combining two different functions we will make other new functions to do our new things on Microsoft excel. We can analyze and calculate our Microsoft excel data in different ways.

You will learn here : 

• Usage of insert function

• Concepts of functions library

• Concepts of financial functions

• Logical formulas and text formulas

• Date and times and more functions

  
  

We will discuss our remaining sections on this session which was incomplete in our previous class. We can learn many more things related to name manager and Formula editing.

We will learn here: 

• Define name

• Nama manager

• Usage of Trace dependent

• Usage of Trace Precedents

• Functions of calculation options

• functions of evaluate

We will discuss getting external data and many more things. The query feature was included in the upgraded version of Microsoft Excel 2016. Using the Query we can create, manipulate and analyze our data in many ways.

Especially we will discuss the query in this session. You will be also familiar with Microsoft Excel queries in an easy way. Using those query you will be also able to many things.

We will discuss data tools in this video. We will discuss the helpful excel tools which help us to do many more powerful things.  You should learn data validation, flash fill, and many more things here.

You will learn here: 

• How to use Text to columns? 

• What is the function of Flash fill? 

• How to use remove duplicates? 

• How to use data validation?

• What is the function of consolidating? 

The forecast is a new feature that is submitted in Microsoft excel 2016. We can predict our future data using the forecast feature of Microsoft excel 2016. We can learn easily Microsoft Excel forecast on this video.

You will learn here: 

• Forecast

• How to use forecast start

• How to use forecast end

• How to use timeline range

• How to use seasonality

• functions of the group and ungroup

• How to use subtotal?

Review and view menus are the same as the Microsoft word 2016. You can check our previous MS word 2016 class if you get any confusion related to Microsoft excel review and view menus.

We will learn here : 

• Protect sheet

• difference between protect sheet and protect workgroup

• Usage of workgroup views

• How to show and hide formulae bar

• and many more

What is Microsoft powerpoint and how to use it? we will discuss it in brief. We will learn to use animations here to create awesome and powerful presentations. Basic knowledge of animations will help us to create a few basic types of presentation only but here we are discussing in depth them.

You will learn here :

• 4 types of functions and usage techniques of them

• How to use Microsoft PowerPoint animation pane

• What are entrance and exit animations?

• How to use Emphasis? 

• How to use the directions of animations? 

• what is the difference between on click, with previous and after previous

• How to use delay? 

Photo album project going to help you create an amazing photo album in Your Microsoft PowerPoint project. Maybe you are working in various projects. Then you can create mesmerizing attractive photo albums using project-related photos.

You can create animation between two slides using slide transitions. If you are not familiar with slide transition then this session going to help you.

Logo Animation Help us to create amazing animations of our company logo. You can learn to animate your company logo after watching this class. this session will help you to increase your creativity.

You can learn the concepts of a business slideshow here. You can work in organizations in the future and maybe you might create your business slideshow there. This class will give you ideas to create a business slideshow.

Powerful templates may be found as per your requirements on Microsoft powerpoints. Just you have to give few time to find out about them. You can customize them after getting them. Those templates will help you to save time.

Infographics slides and presentation looks too professional. You can also create a professional PowerPoint slideshow. You can also create PowerPoint animated infographic slideshow after watching this class.

I am trying to discuss increase your creativity on this video. You can also use this template to create an amazing infographic slideshow. If you want to practice on this template then you can ask me here on comment then I will provide you here.

The concepts and functions of the Master page going to be clear here. You can also use MS PowerPoint master pages after watching this class.

How to animate charts and smartart ? If you want to animate your charts and smartarts then this class going to help you. We are going to discuss the process to animate your charts in depth.

We will discuss Microsoft Powerpoint menus here. We will discuss all the menus which are available in this session. We will discuss about action , slideshow and many more things here.