MicroSoft Excel 2016 Complete Training


Microsoft Excel 2016 Complete Basic to Advanced Training

Trainer

Taimur Pervez

Total Lesson

38

Time Duration

8 Hours

Language

Urdu/Hindi

Format

MP4 HD 1080

Contact No

+923215124534

Email Address

info@virtualacademy.pk

 

OVERVIEW:

After completing Microsoft Excel 2016 Basic to Advance via Online Video Training Course in Urdu and Hindi. You will be able to navigate, Personalize, working on different Microsoft Excel workplace and manage or control the user interface. Microsoft Excel is a Accounting Software that can be utilized for both business and personal use. While already feature rich and critical for productivity, Microsoft continues to improve and enhance MS Excel with each new release.

INTRODUCTION:

Microsoft Excel is a spreadsheet program that is designed to record and analyze numbers and data. Excel is very widely used for accounting and financial purposes. A spreadsheet is a highly interactive computer program that consists number of columns and rows. The intersection of each columns and rows is called cell, in which store data. Each cell its own identification, such as top left cell named as A1 and below of A1 is A2,right cell of A1 is B1 and so on.

PREREQUISITES:

Before starting this course, you should have a working knowledge of Following:

  • Basic computer
  • Introduction to computer
  • Microsoft Word

This training is compatible with windows XP, Window 7, Window 8, Window 8.1, Window 10. MAC operating system.

 

CERTIFICATION:

You are hereby advised to visit www.virtualacademy.pk and get yourself certified in Microsoft Excel 2016 Training, furthermore you'll have to meet the following criteria for earning this particular Registered Certification.

  • You will have to complete all 38 lessons through Virtual Academy Online Learning Management System at www.virtualacademy.pk.
  • Every lesson has 3 to 5 quizzes, which you must have to pass with 70% marks.
  • You need to submit your project/assignments on time.
  • After completion of Virtual Academy offered Microsoft Excel 2016 Training, Lessons via www.virtualacademy.pk Online Learning Management System there will be final exam which comprises of 50 to 100 questions.

After having assessment of your account with www.virtualacademy.pk whether you meet all the above terms and conditions, then we will dispatch your Certificate/Diploma at your given address.

For further queries please read FAQs or you can contact us

 

Complete Course Outline

Lesson 01

Lesson 02

Lesson 03

  1. Introduction to excel
  2. First user interface

 

  1. Order of evaluation/precedence
  2. PEDMES (Parenthesis Exponents Division Multiplication Addition Subtraction)
  3. Parentheses , exponents
  4. division , multiplication
  5. Addition, subtraction

 

  1. Make result sheet/report with the help of  different formula. Part 01

Lesson 04

Lesson 05

Lesson 06

  1. Make result sheet/report with the help of different formula. Part 02

 

  1. File menu
  2. Info, new, open, save and save as
  3. Workbook protection  
  1. Clipboard
  2. Cut, copy, paste and format painter

Lesson 07

Lesson 08

Lesson 09

  1. Font
  2. Font style, font colour, font size, highlight
  3. Bold, italic, underline. Boarder
  1. 1.       Attendance list with the help of different formula

 

  1. Alignment
  2. Text alignments, wrap text, merge and centre

 

Lesson 10

Lesson 11

Lesson 12

  1. Number and styles
  2. Conditional formatting
  3. Format as table
  4. Cell styles

 

  1. Insert cell row, column, sheet
  2. Delete cell row, column, sheet
  3. Cell, row, column and sheet formatting  
  1. Sum
  2. Average
  3. Count Number
  4. Maximum
  5. Minimum 

Lesson 13

Lesson 14

Lesson 15

  1. Fill option for up, down, left, right,
  2. Series fill
  3. Justify
  4. Flash fill

 

  1. Clear
  2. Sort and Filter
  3. Find and replace

 

  1. File menu
  2. Print, share, export, published, close,
  3. Account, feedback, option

Lesson 16

Lesson 17

Lesson 18

  1. Salary report with the help of different formula
  1. 1.       Salary report with the help of different formula

Part 02

 

  1. Pivot table
  2. Recommended pivot table
  3. table

 

Lesson 19

Lesson 20

Lesson 21

  1. Add Picture with different Options
  2. Working on picture format Option

 

  1. Insert Smart Art Graphic
  2. Insert shapes

 

  1. Add ins
  2. Insert Chart and chart formatting
  3. Sparkline

Lesson 22

Lesson 23

Lesson 24

  1. Slicer
  2. timelines
  1. Links
  2. Text Box
  3. Header and footer
  1. Signature line
  2. Object
  3. Equation and symbol

Lesson 25

Lesson 26

Lesson 27

  1. Create Utility Bill of Sui GAS
  1. Themes customization
  2. Excel page setup
  1. Scale to fit
  2. Sheet option
  3. Arrange

Lesson 28

Lesson 29

Lesson 30

  1. Formula Menu
  2. Function Library
  1. Defined Names
  2. Name manager
  3. Create from selection
  4. Use formula     

    1. Formula Auditing

Lesson 31

Lesson 32

Lesson 33

  1. Sort and filter
  2. Flash Fill
  3. Remove duplicate
  4. Data Validation
  5. Consolidate
  6. What if Analysis and Forecast sheet
  7. Outline   

  1.  Complete Review  Menu
  1. How to insert, delete, move, and rename sheet
  2. Sheet protection
  3. Hide and unhide sheet
  4. Tab colour

Lesson 34

Lesson 35

Lesson 36

  1. Complete View Menu
  1. Change case
  2. Date and time formula
  1. Sale Report Part 01

 

Lesson 37

Lesson 38

 

  1. Sale Report Part 02

 

  1. How to calculate your age with formula

 

 

  • Jan Sher

    Jan Sher
    AutoCAD Architecture 2017 Complete Training
    95%

  • Muhammad saleem

    Muhammad saleem
    Blogger Complete Advanced Training 2016
    95%

  • Jan Sher

    Jan Sher
    MicroSoft Word 2016 Complete Training
    95%

  • Rimsha Nazeer

    Rimsha Nazeer
    InPage Urdu Typing 2015 Complete Training
    95%

  • Ali Hasnain

    Ali Hasnain
    MicroSoft Excel 2016 Complete Training
    95%

  • Muhammad saleem

    Muhammad saleem
    WordPress 2016 Complete Training
    95%

  • Ali Hasnain

    Ali Hasnain
    MicroSoft Access 2016 Complete Training
    95%

  • Rimsha Nazeer

    Rimsha Nazeer
    MicroSoft PowerPoint 2016 Complete Training
    95%

  • Muhammad Tariq

    Muhammad Tariq
    MicroSoft Excel 2016 Complete Training
    95%

  • Muhammad Tariq

    Muhammad Tariq
    MicroSoft Word 2016 Complete Training
    95%

  • Muhammad Tariq

    Muhammad Tariq
    MicroSoft PowerPoint 2016 Complete Training
    95%

  • Muhammad Haseeb

    Muhammad Haseeb
    InPage Urdu Typing 2015 Complete Training
    95%

  • Majid khan

    Majid khan
    InPage Urdu Typing 2015 Complete Training
    95%

  • Muhammad Abbas

    Muhammad Abbas
    InPage Urdu Typing 2015 Complete Training
    95%

  • Zaintariq

    Zaintariq
    Blogger Complete Advanced Training 2016
    95%

  • Muhammad Abbas

    Muhammad Abbas
    MicroSoft PowerPoint 2016 Complete Training
    95%