| Event Profile | |
| Class/ Online | Classroom |
| Date | December 20, 2024 |
| Time | 9:00am to 5:00pm |
| Venue | Hotel Grand Pacific Singapore 101 Victoria Street Singapore 188018 |
| Fee | 9% GST will apply SGD 500.003 & above: SGD480.00 each For Member SGD 475 3 & above: SGD456 each |
| Note | Two tea breaks and set lunch or buffet will be served. Limited complimentary car parking coupons are available upon request. Please note: Its a Hands on training session and hence all participants must carry their laptop with pre installed MS office 2010/ 2013 / 2016 / 2019 / 365 or other MS version. In addition trainer will also circulate few Excel Exercise files before the training session. Participants are required to bring those exercise files in their laptops during the training session. |
| Trainer | |
| Activity | |
| You may reach us via T: 6204 6214 E: info@ccisg.com Alternatively, you may send below details to register Contact Person Company (optional), Name, Job Title, Mailing Address, Tel, Email Participant(s) Name, Job Title, Email | |
This workshop is designed for all professionals who are ready to work on complex business problems. This workshop is focused on learning excel formulas and functions and learning new excel tips and tricks to use them in their daily routines
Our expert trainer will work with all the participants on huge data sets and work on practical examples to help them gain expertise in all the advanced formulae and functions, complex charting techniques with enhanced functionalities, and mastering pivots
Hands-on exercises will be given by working on complex workbooks helping participants to summarize and organize data for meaningful reporting and help them derive insights.
Our expert trainer will work with all the participants on huge data sets and work on practical examples to help them gain expertise in all the advanced formulae and functions, complex charting techniques with enhanced functionalities, and mastering pivots
Hands-on exercises will be given by working on complex workbooks helping participants to summarize and organize data for meaningful reporting and help them derive insights.
Objective
The participants of this workshop will learn complex calculations through nested functions, dynamic formulas, enhanced pivot tables, and its features, modifying and creating complex charts, dynamic filtering conditions and creating meaningful and insightful information using excel and use them to perform their daily tasks efficiently
This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day-to-day work
In addition, participants will understand about VBA and get knowledge of Recording macros and creating their own macros and use them to perform their daily tasks efficiently
This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day-to-day work
This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day-to-day work
In addition, participants will understand about VBA and get knowledge of Recording macros and creating their own macros and use them to perform their daily tasks efficiently
This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day-to-day work
Outline
Creating Dynamic excel workbooks
Mastering Pivot Tables
Participants to work on multiple examples to master creating complex reporting solutions through pivot tables
Expertise in graphical representation through Charts
Dashboard designing
Work with the trainer on Hands-on exercises and create dashboard examples
Practical scenarios and examples to perform Hands on exercises
- Learning on Data mining and slicing and dicing the data using Creating customized formulae’s
- Mastering the art of creating tables and its use in day to day work
- Creating Data validations and linking it with data
- Use of named ranges and creating the same
- Creating Dynamic dropdowns and linking data basis different criteria’s
Mastering Pivot Tables
- Creating complex Pivot charts
- Creating summaries in Pivots
- Adding and Removing Subtotals
- Using Slicers in Pivot Table
- Creating graphical representations through pivots
- Inserting formulae’s in Pivots
Participants to work on multiple examples to master creating complex reporting solutions through pivot tables
Expertise in graphical representation through Charts
- Summarizing data visually through charts
- Mastering the art of depicting information graphically by working on multiple 2D and 3D charts.
- Creating combination charts and customized version of different charts to show the information as per the problem statement
- Developing 3 dimensional charts with practical examples
- Use of waterfall charts for professionals from various industries
- Uses and applicability of Bubble charts
- Creating Gauge Charts
Dashboard designing
- What is Management Dashboard
- Principles of dashboard design
- Using Advanced formulas to create dynamic data
- Linking humungous data with customized view and selections
- Mastering Developer Tab
Work with the trainer on Hands-on exercises and create dashboard examples
Practical scenarios and examples to perform Hands on exercises
Who should attend
All professionals who use excel not only for day to day processing but also for interpretation and insight generation in their day to day work and use them for drawing out interpretations in the form of dashboards, MIS or any other form of data mining to convert raw data to meaningful analysis.
The aim of the course is to make the participants learn advanced excel tips and techniques in a way that helps you enhance your productivity, speed and make your work much easy to interpret.
The aim of the course is to make the participants learn advanced excel tips and techniques in a way that helps you enhance your productivity, speed and make your work much easy to interpret.
Divya Arora Hans's Profile
Divya is an expert Speaker and Trainer with more than decade experience in field of Management Reporting, Data Analytics, Business Intelligence and Change Management. She has excellence in her oration and has been responsible for training Corporates, Self employed, Individuals and stakeholders in areas of Advanced MS Excel, Mastering Power Point, Data Analytics, Delivering Impactful Presentations, Data visualizations, Advanced business communications, Wow your audience and many Soft Skills Trainings
Her Span of Experience has been to varied CXO’s, Department Heads and leadership teams across Finance, Accounting, Insurance, Engineering, Healthcare and FMCG industries
Her experience has been with ACCA Singapore, NTU, Delphi Technologies and multiple Retail trainings in Singapore
Her core skills are trainings in areas of MS Office, Power BI, Project Management, Business Intelligence, Business Communication Skills, Stakeholder Management, Team management/leadership, Process Transitions, Process excellence, Continuous Improvement and Change Management. She has varied experience working with big giants like Glaxo Smith Kline, ABN AMRO Bank and Max Life Insurance joint venture with MITSUI SUMITOMO and various training institutes in India and Singapore.
She has been a key contributor to Quality and service excellence and is a certified Green Belt Six sigma professional.
Her Span of Experience has been to varied CXO’s, Department Heads and leadership teams across Finance, Accounting, Insurance, Engineering, Healthcare and FMCG industries
Her experience has been with ACCA Singapore, NTU, Delphi Technologies and multiple Retail trainings in Singapore
Her core skills are trainings in areas of MS Office, Power BI, Project Management, Business Intelligence, Business Communication Skills, Stakeholder Management, Team management/leadership, Process Transitions, Process excellence, Continuous Improvement and Change Management. She has varied experience working with big giants like Glaxo Smith Kline, ABN AMRO Bank and Max Life Insurance joint venture with MITSUI SUMITOMO and various training institutes in India and Singapore.
She has been a key contributor to Quality and service excellence and is a certified Green Belt Six sigma professional.
