This course will cover all aspects of creating Spreadsheets, Performing calculations, Data Validation, VLookup, HLookup, SumIf, CountIf, Ranges, Match, Index, etc. It also guides you on data presentation using Conditional Formatting, Excel Tables, Pivot Tables, Excel-Charts, Formatting and using page setup for printing. Excel users who have not had any formal training will find this course extremely useful, as it will bridge the gap in your knowledge of Excel
This Course is designed for Excel users who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel. Dashboards, Macros, and programming in Excel will be the main Topics covered in this course.
5 Day Advanced Excel Training for the Admin team of United Nations Environment Program at Geneva (17/06/19 to 21/06/19)
Customize Sheets / DashBoard
I design Sheets and Dashboards for individuals and enterprises based on their requirements.