Go Back

Two day training on Excel for Business


From: 2019/10/15 9:30
To: 2019/10/16 17:00
Posted by: Ercess Inc.
Tickets - Prices from: $5850.00

Tickets are currently available at discounted price. The price at venue will be higher.

Overview:
Excel has been the go to tool for anyone who is looking at some basic
reporting. Not many who use Excel on a day to day basis realize that Excel
by itself is an excellent tool for Business. One can use Excel not only for
basic Table level information projection but can also be used for building
financial statement, analysis, etc. with some pleasing charts that will attract
the audience
Through this course we try to unlock some of the features that could help us
achieve more.

Workshop Content
 Working with Data – beyond Sort & Filter
 Performing Calculations using formula including Formula Auditing
o Common Statistical functions
o Lookup & Reference Functions
o Date & Time Functions
o Text Functions
 Conditional Statements & Logical Operators
 Using Visuals – Filters / Combination Charts etc
 Formula based Formatting
 Excel as an Analytical Tool
 Introduction to Macros

For Whom:
This is highly recommended for
 Everyone who works with Excel basics – those who are interested in
getting deeper knowledge of the excel.
 Everyone who likes to slice / dice the given data
Key Takeaways
 At the end of the workshop, the participant will be able to:
 Manipulate and Format data
 Analyse data and present the results in a user friendly manner
 Create charts / Tables that effectively summarize and present
the raw data
 Use formulae and functions for advanced calculations
 Find errors on formula
 Create basic macros for automating simple tasks

Pre-Requisites
 Laptop with latest version of Microsoft Excel loaded
 Sample data for the class would be provided by the Trainer on the
day of training
Facilitator Profile:
Mr.S Bhanu Kumar,
 Entrepreneur, Trainer, Mentor, Coach on Technology needs – provides
consulting services to multiple organizations on Technology
 26+ years of IT experience including Solutioning, Architecting,
Development, PM & QA experiences in Cloud services
 Longest stint of his career was in NTT Data GDS and when he quit, he
quit as Vice President – Cloud Services
 Incubated / established practice lines like Service Desk along with
competency centers around Service Desk, Communication for the
Cloud practice
 ITIL Foundation, Service Operation, SAFe Agilist Certified
 Conducted multiple training sessions and seminars in various colleges
in Cloud, Big Data, IoT, Agile, Data Warehouse / Analytics
 Good hands on experience in Agile, Data Analytics, cloud project
delivery and ITSM tool implementation across various domains
including Life Science, Retail, Manufacturing
 Visiting Faculty on Business Analytics


Location: Madras Management Association, off, Pathari Road, Anna Salai,Thousand Lights, Chennai,Tamil Nadu,Chennai,600006




Save this event

Share with friends:

Ercess Inc.

Buemoon Prime, 338, 9th Main Rd, Sector 7, HSR Layout, Bengaluru, Karnataka 560102

9886188705

Contact the Advertiser

http://ercess.com
Company Details
See other listings from this user


Featured Events


Ercess Inc.
ARTIFICIAL INTELLIGENCE DIGITAL TRANSFORMATION Summit
ABOUT THE SUMMIT: Simpliv, the learning platform, is organizing ...
Career Socially
FICCI Innovation Summit
The Federation of Indian Chambers of Commerce and Industry (FICCI) ...