Microsoft Excel

Introduction

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 Pivot Table is a tool for data Analysis. It does this by simplifying large data sets via PivotTable fields. It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics

Career Prospects / Job Roles

Charts
PivotTables
Conditional Formatting
Data Analysis
Data Validation
Excel Dashboard
Macros