About the Course
Objective Of The Course:
Microsoft Excel is equipped with so many great features that we don’t know about. The intermediate course is aimed to upgrade participants to their next level from basic awareness to proficient level.
This course provides an overview of the Intermediate and little advanced capabilities of Microsoft Excel like working with complex data, working with strong analysis, tools and techniques used in day to day operations, formulas and functions at intermediate level.
Topics CoveredIntroduction to GUI layout
Smartly working with data creation
Data preparation techniques
Data Formatting techniques
Introduction to data anlysis and analytical tools
Intermediate level formulas
Working smart and fast with graphs
Introduction to visual Basic for applications
Data setup and printing effectiveness
Other tools and techniques used in day to day operations
Working with excel settings
Who should attendParticipants who possess skills and knowledge at basics or intermediate level, who are capable of creating data, modifying data, basic formulas, formatting cells, inserting and deleting rows.
This course would be very useful to participants across all industries, functions, any roles or any positions vis-à-vis marketing, finance, business development, operations, human resources, information technology, sales, Administration, strategy etc.
Pre-requisitesBasic level of knowledge in Microsoft Excel
What you need to bringLaptop if possible
Notebook to take notes
Key TakeawaysEfficiency and effectiveness in Excel
Awareness to various tools and techniques
Smartness and userfriendlyness with the Software