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
- Getting Started with Excel
- Introduction to Workbook
- Introduction to Worksheet
- The Range
- Sharing and Outsourcing
- Pasting Link
- Format Cell
- Find and Replace
- Protection
- Data Validation
- Printing
- Templates
- Keyboard Shortcut
Understanding Formula and Function
This section is for users with the knowledge about managing the formula in Excel.
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.
- Count and Sum
- Logical Functions
- Cell References
- Date & Time
- Text Function
- Lookup & Reference
- Financial Function
- Statistical Functions
- Round Functions
- Formula Errors
- Array Formulas
Data Analysis
This section illustrates the powerful features Excel has to offer to analyze data.
- Sorting Data
- Filtering Data
- Conditional Formatting
- Charts
- Pivot Tables
- Tables
- What-If Analysis
- Solver
- Analysis ToolPak
VBA – Visual Basic Array
- Create a Macro
- MsgBox
- Workbook and Worksheet Object
- Range Object
- Variables
- If Then Statement
- Loop
- Macro Errors
- String Manipulation
- Date and Time
- Events
- Array
- Function and Sub
- Application Object
- ActiveX Controls
- Userform
