POWER OF EXCEL...
Introduction
Participants will learn to how to use pivot table in excel, use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work. They will apply visual elements and advanced formulas to a worksheet to display data in various formats. Students 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 2016 advanced functionality to simplify and streamline their day-to-day work.
Target Audience
Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Program Objectives
After completion of this program, the participants will be able to the following
RD also brings you a unique model of delivering this program in different methodologies as well :
Method 1 - In house workshop (Facilitator in client facility) - Based on your audience size we can plan dates for a 2-day in-house workshop or a customized workshop that can be conducted at your facility.
Method 2 - Exclusive Webinar - For your company, - Based on a scalable approach process we can also conduct the same in shorter sessions across a 3 hour 2 modules split sessions wherein it will be more convenient for your people to attend. It can be attended from any location with just simple web-based log in the platform. These will be completely exclusive to your organization sessions blocked for you.
Our first public webinar plan is for 3 hours with the 1st two sections of the modules. (Register yourself below we will notify pricing & dates post registration)
Our facilitator is a Microsoft Office Specialist Certified Trainer with more than 17,000 training behind him.
Participants will learn to how to use pivot table in excel, use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work. They will apply visual elements and advanced formulas to a worksheet to display data in various formats. Students 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 2016 advanced functionality to simplify and streamline their day-to-day work.
Target Audience
Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Program Objectives
After completion of this program, the participants will be able to the following
- Create and use defined names in a workbook
- Work with logical function in excel
- Use a variety of data validation techniques
- Use a range of lookup and reference functions
- Create summaries in your spreadsheets using subtotals
- Understand and create simple pivot tables
- Construct and operate pivot tables using some of the more advanced techniques
- Perform a variety of analytical tasks using PowerPivot
- Use the data consolidation feature to combine data from several workbooks into one
- Create and work with scenarios and the scenario manager
- Use solver to solve more complex and intricate problems
- Import data into excel and export data from excel
- Create and use a range of controls in a worksheet
- Create recorded macros in excel
- Import data into excel and export data from excel
RD also brings you a unique model of delivering this program in different methodologies as well :
Method 1 - In house workshop (Facilitator in client facility) - Based on your audience size we can plan dates for a 2-day in-house workshop or a customized workshop that can be conducted at your facility.
Method 2 - Exclusive Webinar - For your company, - Based on a scalable approach process we can also conduct the same in shorter sessions across a 3 hour 2 modules split sessions wherein it will be more convenient for your people to attend. It can be attended from any location with just simple web-based log in the platform. These will be completely exclusive to your organization sessions blocked for you.
Our first public webinar plan is for 3 hours with the 1st two sections of the modules. (Register yourself below we will notify pricing & dates post registration)
Our facilitator is a Microsoft Office Specialist Certified Trainer with more than 17,000 training behind him.