Classroom/ Online: Yes/ Yes
Scheduling Date(s):
Note: Please click specific date for detailed venue and course fee etc.
Excel Tips and Tricks session
If you are looking to increase your productivity and efficiency and make most out of your work with optimum effort then this training will help you achieve the same.
Our expert trainer will work with all the participants on different data sets and practical examples to help them bring in use the most used techniques in excel. This will help them make better business decisions and interpretations through best visual representations.
Hands on exercises will be given helping all the participants to master these functionalities and apply them in a meaningful way.
Our expert trainer will work with all the participants on different data sets and practical examples to help them bring in use the most used techniques in excel. This will help them make better business decisions and interpretations through best visual representations.
Hands on exercises will be given helping all the participants to master these functionalities and apply them in a meaningful way.
Objective
The objective of this introduction session is to learn few fast and robust techniques that will help every professional to perform their work in much easier and efficient way.
The participants will master analytical techniques required to enhance their productivity through efficient working on excel platform and its analysis tools
The participants will master analytical techniques required to enhance their productivity through efficient working on excel platform and its analysis tools
Outline
Introduction
1. Refresher on basic features of Excel
2. Excel Templates and creating your own Text styles
3. Advanced Pasting options
Learning about Tables and Pivots
1. Creating Tables and its features
2. Playing with data in tabular format
3. Create summaries
4. Making dynamic tabular representations
Working with Graphics and Shapes
1. Use of complex shapes and its use
2. Inserting and deleting objects
3. Formatting objects
4. Enhancing presentation of data
Introduction to charts
5. Few tips and shortcuts
6. Shortcuts to create charts
7. Quick graphical analysis tool
8. Customizing charts and graphs
9. Hands on graphical representations
Something more than just learning formulae’s
1. Learn most commonly used formulae’s
2. Practical scenarios on applicability of formulas
3. 3D referencing for formulae’s and formatting options
4. Shortcuts of looking at formulae’s
Playing with Data and make it comprehensible
1. Quick tricks in data mining
2. Embedding objects
3. Advanced selections options
4. Getting unique set of values
5. Using Text to columns
6. Inserting screenshots
Some Basic Analysis
1. Quick Analysis Tools
2. What if Analysis
3. Shortcuts to forecast data
Learning on Data mining and slicing and dicing the data
1. Creating, inserting and modifying hyperlinks
2. Using specialized pasting options
3. Moving and copying worksheets and cells
Additional Features
1. Work on daily reports and schedules using Calendars in Excel
2. Working with multiple scenarios in finance world
3. Shortcuts to conversions
4. Making excel file show results as "Live" web
1. Refresher on basic features of Excel
2. Excel Templates and creating your own Text styles
3. Advanced Pasting options
Learning about Tables and Pivots
1. Creating Tables and its features
2. Playing with data in tabular format
3. Create summaries
4. Making dynamic tabular representations
Working with Graphics and Shapes
1. Use of complex shapes and its use
2. Inserting and deleting objects
3. Formatting objects
4. Enhancing presentation of data
Introduction to charts
5. Few tips and shortcuts
6. Shortcuts to create charts
7. Quick graphical analysis tool
8. Customizing charts and graphs
9. Hands on graphical representations
Something more than just learning formulae’s
1. Learn most commonly used formulae’s
2. Practical scenarios on applicability of formulas
3. 3D referencing for formulae’s and formatting options
4. Shortcuts of looking at formulae’s
Playing with Data and make it comprehensible
1. Quick tricks in data mining
2. Embedding objects
3. Advanced selections options
4. Getting unique set of values
5. Using Text to columns
6. Inserting screenshots
Some Basic Analysis
1. Quick Analysis Tools
2. What if Analysis
3. Shortcuts to forecast data
Learning on Data mining and slicing and dicing the data
1. Creating, inserting and modifying hyperlinks
2. Using specialized pasting options
3. Moving and copying worksheets and cells
Additional Features
1. Work on daily reports and schedules using Calendars in Excel
2. Working with multiple scenarios in finance world
3. Shortcuts to conversions
4. Making excel file show results as "Live" web
Who should attend
This course is specifically designed for all those professionals and individuals who are engaged in day to day working on excel. Work with humungous data sets and require excel tips and tricks to enhance their efficiency in everyday work.
The tips and tricks that participants will learn in this workshop will help them perform quick data analysis to further help in business decision making
The tips and tricks that participants will learn in this workshop will help them perform quick data analysis to further help in business decision making
Profile of Divya Arora Hans
Expert Speaker, Business Consultant with almost 20yrs experience in field of Artificial Intelligence, Data Science, Gen AI, Machine Learning, Digitalization, Data & Predictive Analytics, Creating Interactive Dashboards, Data Storytelling, Data Visualizations, Creating automated reports for real time reporting, Data & Visual Analytics using Excel and business intelligence tools like Power BI and Tableau.
In addition Divya also specializes in Academic and Corporate and Government Trainings and consulting engagements, Insights generation, decision making, driving efficiency in processes, Process Automations and creating roadmap for use of Artificial Intelligence and automation for organizations to enhance data driven decision making.
She has excellence in her oration and has been responsible for conducting CEO round tables and training Faculty members, Students and staff of prestigious Academic institutions and Leadership teams across public sector , corporates,
Government and SME’s both in Singapore and Globally
Key Experience
• National University of Singapore (NUS)
• Nanyang Technological University (NTU) – Training Adult Learners
• Singapore Management University (SMU)
• Singapore University of Social Sciences (SUSS)
• Ministry of Foreign Affairs Singapore– Trained across 25 countries
• Ministry of Defence (MINDEF)
• Institute of Singapore Charted Accountants (ISCA)
• 1FSS
• Agency for Integrated Care- Ministry of Health
• UWCSEA – United world college South east Asia
• Murdoch University – Australian university
• Association of Chartered Certified Accountants (ACCA)
Sector Experience
• Academia
• Universities
• Education Sector
• Finance and Accounting
• Government Sector – Multiple Ministries across Singapore
• Public sector
• FMCG
• Healthcare
Key Trainings conducted across above sectors
• Artificial Intelligence & Generative AI
• Data Visuaization
• Power BI and Tableau Trainings
• Data Analytics & Machine Learning
• Data Visualization and Big Data
• Creating Data Dashboards & Excel Expertise
Professional and Technical qualifications
• Masters in Business Economics
• Masters in Business Administration
• a certified Green Belt Six sigma professional.
• Economics (Hons)
