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 sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager). 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, and then reporting the results back to the spreadsheet.


Expected Skills

* EXCEL INTRODUCTION
* CUSTOMIZING EXCEL
* USING BASIC FUNCTIONS
* FORMATTING AND PROOFING
* MATHEMATICAL FUNCTIONS
* PROTECTING EXCEL
* TEXT FUNCTIONS
* DATE AND TIME FUNCTIONS
* ADVANCED PASTE SPECIAL TECHNIQUES
* NEW IN EXCEL 2013 / 2016 AND 365
* SORTING AND FILTERING
* PRINTING WORKBOOKS
* WHAT IF ANALYSIS
* LOGICAL FUNCTIONS
* DATA VALIDATION
* LOOKUP FUNCTIONS
* PIVOT TABLES
* ARRAYS FUNCTIONS
* CHARTS AND SLICERS
* EXCEL DASHBOARD
* VBA MACRO
* VARIABLES IN VBA
* MESSAGEBOX AND INPUTBOX FUNCTIONS
* IF AND SELECT STATEMENTS
* LOOPING IN VBA