Site icon DW Faisalabad

Microsoft Excel 2016

Zahid Farid

We offer a tutorial (Introduction, Basics, Functions, Data Analysis and VBA) on how to use Excel. Below you can find an overview of all chapters. Want to learn much more about Excel? You can find related examples and features (300 Examples) on the right side of each chapter. We keep it easy!

Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial.

Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations.

Excel 2016 Basics

This section explains the basics of Excel

  1. Getting Started with Excel
  2. Introduction to Workbook
  3. Introduction to Worksheet
  4. The Range
  5. Sharing and Outsourcing
  6. Pasting Link
  7. Format Cell
  8. Find and Replace
  9. Protection
  10. Data Validation
  11. Printing
  12. Templates
  13. Keyboard Shortcut
Understanding Formula and Function

This section is for users with the knowledge about managing the formula in Excel.

  1. Formula and functions
Function

Discover how functions in Excel help you save time. If you are new to functions in Excel, we recommend you to read our introduction to Formulas and Functions first.

  1. Count and Sum
  2. Logical Functions
  3. Cell References
  4. Date & Time
  5. Text Function
  6. Lookup & Reference
  7. Financial Function
  8. Statistical Functions
  9. Round Functions
  10. Formula Errors
  11. Array Formulas
Data Analysis

This section illustrates the powerful features Excel has to offer to analyze data.

  1. Sorting Data
  2. Filtering Data
  3. Conditional Formatting
  4. Charts
  5. Pivot Tables
  6. Tables
  7. What-If Analysis
  8. Solver
  9. Analysis ToolPak
VBA – Visual Basic Array
  1. Create a Macro
  2. MsgBox
  3. Workbook and Worksheet Object
  4. Range Object
  5. Variables
  6. If Then Statement
  7. Loop
  8. Macro Errors
  9. String Manipulation
  10. Date and Time
  11. Events
  12. Array
  13. Function and Sub
  14. Application Object
  15. ActiveX Controls
  16. Userform
Exit mobile version