Excel Competency Wheel | Reflect on what you know in Excel
Originally published: 02/08/2021 14:47
Publication number: ELQ-49775-1
View all versions & Certificate
certified

Excel Competency Wheel | Reflect on what you know in Excel

Excel Competency Wheel | Reflect on what you know in Excel

Description
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, and financial needs. In addition, it can display data as line graphs, histograms, and charts, and with a very limited three-dimensional graphical display. It allows the sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager). A PivotTable is a powerful tool that can save time when it comes to data analysis. It does this by simplifying large data sets via PivotTable fields that are also known as "the building blocks of PivotTables.


Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

This Best Practice includes
1 Excel file

Rahim Zulfiqar Ali offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


5.0 / 5 (3 votes)

please wait...