MS Excel Advanced

Manipal Executive Education

Price: USD 408

Duration: 16 Hour

Course details

Participants will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.
They will apply visual elements and advanced formulas to a worksheet to display data in various formats. Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel's advanced functionality to simplify and streamline their day-to-day work.
Participants will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.
They will apply visual elements and advanced formulas to a worksheet to display data in various formats. Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel's advanced functionality to simplify and streamline their day-to-day work.
COURSE OUTLINE
Working with Formulae and Functions

Introducing Formulae and Functions
Creating formulae that manipulate text
Working with Dates and Times
Creating Formulae that Count and Sum
Creating Formulae that Look Up Values
Creating Formulae for Financial Applications
Introducing Array Formulae
Performing advanced tasks with Array Formulae

Using advanced Excel features

Customizing the Excel User Interface
Using Custom Number Format
Using Data Validation and Text to Columns
Creating and Using Worksheet Outlines
Linking and Consolidating Worksheets
Excel and the Internet
Sharing Data with Other Office Applications
Using Excel in a Workgroup
Protecting Your Work
Making Your Worksheets Error-Free

Creating Charts, Graphics and Dashboards

Getting Started Making Charts
Learning Advanced Charts
Visualizing Data Using Conditional Formatting
Creating Sparkline Graphics
Enhancing Your Work with Pictures and Drawings
Maintaining and creating advanced dashboards

Analyzing data with Excel

Getting Data from External Database Files
What-if Analysis
Data Validation - advanced
Introducing Pivot Tables
Analyzing Data with Pivot Tables
Analyzing Data Using Vlookup
Analyzing Data Using Hlookup
Maintaining and creating Dashboards

MACROS
Basics of Macros
Updated on 01 March, 2017

About Manipal Executive Education

Manipal Executive Education (MEE) is Manipal Global Education’s corporate and executive education entity based out of Dubai, UAE. It services the Middle East & Africa Region including strategic markets such as UAE, Kuwait, Kingdom of Saudi Arabia, Oman, Qatar & Bahrain.

Its purpose is to deliver world class certification and training programs for students, working professionals and corporates in various formats ranging from classroom based training, online programs and hybrid programs across multiple sectors which are of relevance to the region.

Based out of Dubai Knowledge Village, the HR & Training Hub of Dubai, MEE offers high end certification programs in functional and technical programs across multiple sectors ranging from Logistics, Banking & Financial Services, IT, Telecom, Retail and Hospitality.

See all Manipal Executive Education courses

Ask Laimoon

View more similar courses

Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.