EXCEL: FROM ZERO TO HERO
Updated A.Y. 2020-2021
Microsoft Excel is a spreadsheets program that, due to its extreme versatility and power, has become one of the most-used software programs in the business world since its launch in 1985.
This course introduces the student to all the important fundamental and advanced features of Microsoft Excel and it is structured to give maximum “hands-on” experience to the students. In order to attain this, participants are asked to bring their own personal computer to work on. Microsoft Excel has to be installed on the computer.
This course requires no prerequisite knowledge in Excel but a Knowledge of Windows/MAC OsX and experience with a computer is essential.
What is a spreadsheet and what you can do with it
Create your first table
Working on workbooks
Formulas and Functions
Advanced formatting of data and spreadsheets
Data management: link, sort, filter and sub-totals
Protection of cells, spreadsheets and workbooks
Advanced functions and charts
What-if tables and scenarios
Auditing and solver tool
Macro and VBA