Course Overview
Improve your efficiency and boost productivity with our instructor-led training on ADVANCED EXCEL. Advanced knowledge of Excel means possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks. You would learn new excel skills like using pivot tables, VLOOKUP, Conditional Formatting and calculations. This course is suitable for Data entry, Data management. Accounting, Data and Business Analysis.
Courses Included are:
Chapter 01 – Getting Started with Microsoft Office Excel 2016
Chapter 02 – Performing Calculations
Chapter 03 – Modifying a Worksheet
Chapter 04 – Formatting a Worksheet
Chapter 05 – Printing Workbooks
Chapter 06 – Managing Workbooks
Chapter 01 – Working with Functions
Chapter 02 – Working with Lists
Chapter 03 – Analyzing Data
Chapter 04 – Visualizing Data with Charts
Chapter 05 – Using PivotTables and PivotCharts
Chapter 06 – Working with Graphical Objects
Chapter 07 – Using Array Formulas
Chapter 01 – Working with Multiple Worksheets and Workbooks
Chapter 02 – Using Lookup Functions and Formula Auditing
Chapter 03 – Sharing and Protecting Workbooks
Chapter 04 – Automating Workbook Functionality
Chapter 05 – Creating Sparklines and Mapping Data
Chapter 06 – Forecasting Data
Chapter 1 – Understanding unlevered free cash flow.
Chapter 2 – Forecasting free cash flow.
Chapter 3 – Forecasting terminal value.
Chapter 4 – Present value and discounting.
Chapter 5 – Understanding stub periods.
Chapter 6 – Performing sensitivity analysis.
What Will I Gain From This Program?
By the end of this training you would be confident enough to work on Microsoft Excel. You would be able to apply the learned skills into any of:
- Data Entry and Storage.
- Collection and Verification of Business Data
- Accounting and Budgeting
- Data Analysis
What Our Students Have to Say
Some Of our Content Partners
