Microsoft Excel Training for Professionals

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 5 lectures (1h 13m) | Size: 678.3 MB

Microsoft Excel Tips for Pros
What you'll learn:
Exceptional Microsoft Excel Tips for Presentation of Analysed Data
Quantitative Business Reporting
Analytics-based business decision making
Business Intelligence
Analytics for sales, transactional and operational business data
Business data validation
Data organising and restructuring
Data analysis and interpretation
Data visualizations
Data entries reconciliations
Business budgeting
Building senior management and executive dashboards
Business Trends Forecasting
Financial and Risk modeling in Excel

Requirements
Be able to use basic functionalities of Microsoft Excel

Description
This course provides a thorough grounding in Microsoft Excel. The themes covered include: Excel data structures; Cell Formatting; Excel Formulae; Excel Functions; Data Validation; Data visualisation; Data analysis; Data presentation; VBA programming, etc. The skills learnt in this course can be applied in the following ways: Data collection, consolidation and storage; Business data validation; Data organising and restructuring; Data analysis and interpretation; Data visualisations; Data entries reconciliations; Business budgeting; Building dashboards; Business Operations Reporting; Management Accounting Models; Management Reporting; Financial reporting; Forecasting; Financial modeling; Risk modeling; Product costing models; Project management; Task automation, etc.

This training is designed for professionals and aspiring professionals. It has been compressed to ensure completion within the shortest possible time. The training however remain comprehensive because it combines lecture, handholding and practical application. Participants are allowed to bring the data which they work with on a daily basis and relevant practical analysis will be done on their data. The training aims to churn out a complete Microsoft Excel expert who is able to put to practise the vast techniques covered in this program. Up and above that, the training is designed to kindle participants into the unlimited functionalities of Microsoft Excel.

Everyone who uses Microsoft Excel in their day-to-day work should attend this training. The list includes, but is not limited to: Reconciliation officers; Sales reporting personnel; Payments and settlement officers; Finance officers and managers; Financial controllers; Accountants; Credit monitoring officers; Credit controllers; Risk analysts & managers; Quantitative Data Analysts; Project analysts & managers; Research and Development Analysts; Quantitative Risk Analysts; Data Scientists; Database administrators; etc.

Who this course is for
Quantitative Data Analysts
Risk analysts & managers
Payments and settlement officers
Finance officers and managers
Financial controllers
Accountants
Credit monitoring officers
Credit controllers
Sales reporting personnel
Reconciliation officers
Project analysts & managers
Research and Development Analysts
Quantitative Risk Analysts
Data Scientists
Database administrators