Summary
This intensive, hands-on webinar demonstrates, through numerous practical examples, how utilizing Microsoft Excel can increase the efficiency of Financial Managers.

This intensive webinar is designed to introduce financial people to the many ways that Excel can be used as a support tool for the financial function. The webinar is filled with practical exercises that show finance people how to get the most out of Excel with the least additional effort.

During this Webcast, you will learn to:
• Monitor expenditure budgets effectively by using Excel's features to help recognize and correct misallocations
• Generate financial statements accurately, faster and more effectively
• Set up special reports that highlight over or under-spending in time to take remedial action, ensuring that your department remains within their budgets
• Avoid repeat work by setting up Excel Databases and Pivot Tables to effectively use the same data for different purposes
• Develop financial projection and trend analysis spreadsheets to assist with management decision making and managing external factor risk
• Free up more time by learning how to effectively set up Financial Macros, use Function Wizards and take advantage of other advanced functions in MS Excel

For inquiries or complaints concerning this Webcast, please call (001) 646-371-0082.

About the Presenter

Philip Gamey

Philip Gamey is popularly known as “Excel Monster.” He owns ExcelMonster.com and provides Excel App Development and Consultancy services to top companies in America, Europe and South Africa.

Summary
This highly intensive and practical webinar will show you how to use Excel for HR data management, analytics, reporting and dashboards. This webcast focuses on developing real-world HR applications and reporting.

In a breakthrough session, attendees will learn how to use Excel’s tools and functions to create a full “Management HR Report Set” that can be used to automate the creation of routine HR reports and provide data for “adhoc” reporting with Pivot Tables.

The course provides attendees with the knowledge and the skills that are required to take interactive HR application development, reporting and analytics to a new level.

Topics to be discussed will include:
• How to consolidate HR data from multiple sources into a mini HR data warehouse for analysis and reporting
• Designing and Developing Excel applications that simplifyHR expense tracking, training management, employee leave management, workforce data analysis, etc
• HR dashboards that help you retrieve employee records faster and accurately.
• Automating the production of HR reports to save you several hours and days.

For inquiries or complaints concerning this Webcast, please call (001) 646-371-0082.

About the Presenter

Philip Gamey

Philip Gamey is popularly known as “Excel Monster.” He owns ExcelMonster.com and provides Excel App Development and Consultancy services to top companies in America, Europe and South Africa.

Summary
Most Managers and Professionals work with Excel, but few utilize the functions and tools that enable Interactive Reporting, Automation and extended Data Analysis.

This practical webcast demonstrates the full capabilities of the MS-Excel program for a wide range of Business Applications including Macro Creation, Extensive Data Analysis, Data Importing, KPI monitoring and Enhanced Management Reporting.

During this intensive webinar, you will learn to:
• Set up Excel databases and pivot tables to effectively use the same data for different purposes
• Understand how to import data directly from other applications to make a wider range of information available for analysis
• Conduct advanced analysis, KPI tracking, sensitivity and margin analysis to help highlight problems before they occur
• Take advantage of Excel’s many specialized features to produce management reports, quickly and easily
• Automate the creation of graphs and charts to help illustrate key business issues and trends
• Utilize Macros and advanced functions to save time when manipulating data and automating the production of management reports and charts

For inquiries or complaints concerning this Webcast, please call (001) 646-371-0082.

About the Presenter

Philip Gamey

Philip Gamey is popularly known as “Excel Monster.” He owns ExcelMonster.com and provides Excel App Development and Consultancy services to top companies in America, Europe and South Africa.

Summary
This powerful webinar provides Excel dashboard developers with the tools and techniques for building an effective business dashboard exclusively with Microsoft Excel.

During the webcast, attendees will learn how to build powerful dashboards by suing Excel functions and tools such as slicers, conditional formats, controls, sparklines, LOOKUP functions and pivot tables.

You’ll learn to create a dashboard that is easy to understand and yet illustrates key data trends.

During this intensive webinar, you will learn to:
• Setup data for pivot table dashboards;
• Work with form controls and slicers;
• Master KPI data visualization techniques;
• Create function labels to show performance indicators;
• Develop dashboard reports that trend and compare forecast and actuals;
• Use collapse and expand buttons on dashboards; and
• Other powerful data visualization techniques

For inquiries or complaints concerning this Webcast, please call (001) 646-371-0082.

About the Presenter

Philip Gamey

Philip Gamey is popularly known as “Excel Monster.” He owns ExcelMonster.com and provides Excel App Development and Consultancy services to top companies in America, Europe and South Africa.