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 analyse 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 column 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, Windows 7, Windows 8, Windows 8.1, Windows 10, and 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.

Course Contents

Getting Started with Microsoft Excel

• Introduction to Microsoft Excel
• First User Interface of Microsoft Excel
• Introduction to Excel Spread Sheet
• Row, Column and Cells
• Arrows
• Menu
• Save an excel file
• Open an excel file
• Quick Access Bar
• Tabs and Ribbons
• Wordbooks and Worksheets
• Formula Bar
• Status Bar
• Navigational Process
• Shortcut and Mini tool bar
• Creating New Work Book
• Questions and Answers

Entering and Editing Text

• Entering and Editing text
• Working on Numbers
• Sorting the Data
• Working in Cell, Column and Rows
• Formatting, Editing and Deleting Data
• Understanding the order of Operations
• Working with cell references
• Formula Procedures
• Order to evaluation
• Questions and Answers

File Menu

• Open New and Existing File
• Save and Save As
• Printing the Workbook/worksheet
• Share and export workbook / worksheet
• Info, Account and Options
• Questions and Answers

Office Clipboard

• Cut, Copy and Paste
• Paste special
• Format painter
• Clipboard
• Questions and Answers

Font Style, Formatting and Alignments

• Font style and Size
• Bold, italic and Underline
• Text color and Fill Color
• Border style and formatting
• Numbers
• Conditional Formatting
• Format as Table
• Cell Style
• Alignment
• Wrap text
• Merge and center
• Shrink to fit
• Merge cell
• Text orientation
• Boarder and Fill
• Questions and Answers

Cell, Row, Column and Sheet Formatting

• Insert Cell, Row, Column and Sheet
• Delete Cell, Row, Column and Sheet
• Change Row Height
• Change Column Width
• Default Settings
• Hind and Unhide Row, Column and Sheet
• Rename Sheet
• More or copy Sheet
• Change Tab Color of Sheet
• Sheet Protection
• Lock Cell
• Format cells
• Questions and Answers

Editing

• AutoSum
• Fill, Justify, Series and Flash fill
• Clear Formats, Contents Comment and Hyperlinks
• Sort and Filter
• Find and Replace
• Questions and Answers

Inserting Illustrations and Add-ins

• Insert Picture,
• Picture Alignments
• Picture Style and Settings
• Insert Shapes and Icon
• Shape Designing and formatting
• Icon Designing and formatting
• Insert 3D Models
• Insert WordArt
• WordArt Designing and formatting
• Insert SmartArt
• SmartArt Design and Formatting
• Screenshot
• Add-ins
• Questions and Answers

Inserting Links, Comments, Text, Symbols and Equation,

• Add a Hyperlinks
• Choose a text box
• Header and Footer
• WordArt
• Add Signature Line
• Insert Objects
• Insert Symbol and Equations
• Questions and Answers

Pivot Tables and Filters

• Understanding Pivot Tables
• Creating Pivot tables
• Pivot table Calculations
• Grouping Pivot Tables Data
• Creating Pivot Charts
• Filtering Pivot Tables Data
• Filtering Using the Slicer
• Timeline
• Questions and Answers

Chart and Sparklines

• Column and bar chart
• Line Chart
• Pie Chart
• Hierarchical Chart
• Histogram
• Bubble Chart
• Excel Recommended Chart
• Modify and Move Chart
• Chart filters
• Cell Value for Charts
• Conditional Formatting with Chart
• Using Sparklines and Quick data Insights
• Questions and Answers

Page Layout

• Themes, Color, Font and effects
• Page setup
• Margins, Orientation, Size, Print area, Break,
• Background and Print Titles
• Scale to Fit
• Sheet Option
• Arranging, Forward and Backward
• Selection pane and Align
• Group and Rotate
• Questions and Answers

Functions and Formula Auditing

• Insert functions
• AutoSum, Average, count, Max and Min and others
• Financial and Logical functions
• Text
• Date and Time Functions
• Lookup and reference
• Math and Trig
• More Functions
• Trace Precedents
• Trace dependents
• Remove Arrows
• Show Formula
• Error Checking
• Evaluate formula
• Questions and Answers

Define Names and Calculations

• Name Manger
• Define Name
• Use of formula
• Crete from Selection
• Calculations
• Questions and Answers

Data Management

• Get External data
• Sort and Filter data
• Advance Sort and Filter
• Text to Columns
• Remove Duplicate Value
• Data Validation
• Consolidate
• Relationship
• What if Analysis and Forecast Sheet
• Group, Ungroup and Subtotal
• Questions and Answers

Review and View

• Proofing
• Check Accessibility
• Smart lookup
• Translate
• Comments
• Sheet and Workbook Protection
• Workbook Views
• Show and Zoom
• Windows, split, hide, arranging, freezing and synchronous scrolling
• Record Macros
• Questions and Answers

Help and Community

• Help and Contact Support
• Feedback and Training
• Community, Excel Blog and Suggest a Feature
• Questions and Answers

Excel Projects & Formular

• Order by Evaluation
• Setting the Data cycle
• PEDMES
• Product List
• Product in and Out
• Else and Else if
• Range and Selection
• Create Result Sheet with Different Formulas
• Create Attendance Sheet Using Formulas
• Sum, Average, Count, If, Maximum and Minimum formular
• Create Salary Sheet with Different Formulas
• Create Sale reports With Different Formulas
• Create Utility Bills with Different Formulas
• Change Case and Date/Time Formula
• Calculation Age with the Help of Formulas
• Questions and Answers

Final Exam and Certification