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
Course Location
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- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Certified Information Security Manager (CISM) St. Paul's CollegeAED 46Duration: Upto 16 Hours
- Microsoft Excel 2016 Advanced Adams AcademyAED 143
AED 1,506Duration: Upto 8 Hours
