Management reports are commonly found in most organizations. They are called different names in different organizations. Some of the common names used are
Key Performance Indicator (KPI) report
Daily, Weekly or Monthly Snapshot
Business Performance / Deck Report
These management reports provide Senior Managers with a quick overview of the business performance in just a few minutes. But preparing the reports can take up a lot of time, as long as a few hours. The whole process is very manual if these managers and executives only know the common functions and formulas of Excel. Unknown to these executives and managers, as much as 90% of their report preparation time can be saved if they know how to combine formulas and functions in Excel together. If properly setup, they can even do away with calculations and the coloring of cells. All they have to do is to change the date in the report and Excel will take care of the rest. This means an error free report, caused by manual calculation and formatting.
Through the course, participants will learn how to create interactive and maintenance free reports for their companies without using macros. They will also learn more advanced formula and functions which can be used to increase their productivity in their Excel reports.
• Create a chart with 2 x-axis
• Customize your bar charts with pictures
• Using your corporate colors within Excel
• Set up an interactive title for your chart
• Create an user interactive chart
• Making use of Pivot Table and Charts in your report
• Naming concepts / Using Tables
FORMULAS AND FUNCTIONS COVERED IN THE COURSE
CHOOSE FORM CONTROLS PIVOT TABLE
COUNTIF / COUNTIFS INDEX RANGE NAME
CUSTOMISE TEMPLATE INDIRECT SUMIF / SUMIFS
DATA VALIDATION MATCH SUMPRODUCT
DROPDOWN BOX PIVOT CHART VLOOKUP and more…
WHO SHOULD ATTEND
Managers and Executives who are required to prepare Reports for Management
Before you sign up for the course, it is important to you read this. The course is not for everyone. Do not attend the course if you do not have at least 2 years of experience working with Excel. And to make sure that you are able to benefit from the course, please answer the following questions:
a. Do you know how to create a VLOOKUP formula?
b. Do you know how to combine formulas?
c. Do you know how to create Pivot Table?
Duration: 18 Hours ~ Course Fees or Investment : Rs.3600
We have extensive experience in working with clients to gather requirements and in building the exact report necessary for your organization.
Consultants abound for almost any business situation in any industry -- whether manufacturing, education, healthcare, telecommunications, entertainment, or virtually any other slice of the economy -- bringing expertise in finance, accounting, IT, marketing, operations, strategy, or nearly any other functional discipline.
We take Microsoft Excel Classes on Excel 2003 / Excel 2007 / Excel 2010 and Mac too...
Send your Excel questions in advance via e-mail rajesh.xls @ gmail.com or bring them to the class.
Batch Details Timing:
Week Days: Morning - 06:00 IST - 07:30 IST (1:30 Hours) 2 days Per Week
(Mon-Sat) Evening - 20:00 IST - 21:30 IST (1:30 Hours) 2 days Per Week
21:45 IST - 23:15 IST (1:30 Hours) 2 days Per Week
(Online Classes one to one @ Internet)
We take online classes 30 Hours per week 3 Hours
Who can attend this Excel Hours?
This program is only for the Working professional only not for students or fresher.
…I will not teach you just a formula, because there is no point in me teaching you that, if any want to learn a formula, please use the Excel help or Excel Dictionaries. I will teach only the concept of the formula; mainly why this formula, what is the purpose, if this formula is the best option or some other way is available. When you understand the concept of the formula, you can innovate in your own style with your own views. For that I will help you in person, like a personal instructor to you.
For more details and Demo contact Rajesh - 98865 17585, only limited seats available
Email: rajesh.xls [at] gmail.com; Website: www.excelhours.yolasite.com