DATA MANAGEMENT, ANALYSIS AND
REPORTING WITH MICROSOFT EXCEL.
Let us help you transform the way you organize and use your data.
VENUE: FAIRWAY HOTEL, KAMPALA
DATE: SATURDAY 16th July 8:30 AM to 5:00 PM
Sunday 17th July 8:30 AM TO 3:00 PM
REGISTRATION CLOSES
FRIDAY, 8TH JULY 2016
Many people at different levels in many organizations use Microsoft Excel as a data management and data analysis tool, but few of them can truly use it effectively for this purpose. Most Excel users don’t know about Microsoft Excel’s vast array of data management and analysis tools that can be used to effectively manage and interpret business information in a coherent and organized manner.
Excel users need to manage their data efficiently and they need to optimize their use of Excel’s many powerful and easy-to-use database tools and techniques in order to free and devote their time more profitably to making decisions and acting on results, with more effective outcomes.
Why attend this course?
This course is a MUST have skill for every user of Microsoft Excel. It will transform the way you manage and analyze data in excel. It explores the basic and advanced features needed to effectively build and manage an Excel database to facilitate easy analysis and reporting. Our Excel experts will lead participants through a full array of powerful and easy-to-use database tools, commands and methods critical to working more effectively with Microsoft Excel. Participants will be introduced to the relevant Excel features, explore them in detail with real business examples and practice on how these can be used to efficiently manage, analyze and report data in Excel.
What you will learn.
Participants to this training will learn Excel features that are critical to managing, analyzing and reporting about their data. They will learn about how to develop dynamic databases using the Excel table feature, control data in puts, and analyze data using advanced features like PIVOT Tables. Participants will also learn;
- Easy-to-use methods to build and manage Excel data using the Excel table feature.
- DATE functions and formats and how these affect the usefulness of most databases.
- How to identify, control or remove duplicates from your excel database.
- Tips and tricks to validate data inputs in Excel and guarantee accuracy.
- Techniques to link sort and filter data in order to identify business trends.
- How to quickly retrieve information using multiple filters and VLOOKUP.
- How to use Excel’s Name Box and Name Manager features to name cell ranges.
- How to easily summarize, analyze and report data using tools like PIVOT Tables, PIVOT Charts, SUBTOTAL, Conditional Formatting, etc.
- How to use conditional functions like IF, SUMIF(S) etc. and database functions like DSUM, DCOUNT etc. to analyze and report data.
- How to format reports and protect your database and reports from unauthorized changes
Who should attend this course?
This course is aimed at every Microsoft Excel user, and specifically professionals who have, or will soon have, responsibility for managing and manipulating data using Microsoft Excel on a day to day basis. The following will particularly find this course useful.
|
|
- School Bursars and Teachers
|
- Marketing and sales personnel
|
|
|
|
|
|
|
|
|
|
|
Participants should have some basic experience and understanding of Microsoft® Excel 2007 or later version. Come with your own laptop loaded with office 2007 or above. Class size is limited to 30 participants only.
FEES
Enroll for this blended three in one course at a discounted rate of UGX: 750,000 per participant payable to DATAHOUSE Business Solutions Account No 0121152307200 with Housing Finance Bank Ltd Kololo Branch. SWIFT CODE: HFINUGKA.
**********************************************************************************************
August 19th to 20th, 2016.
MANAGING AN AUDIT WITH MICROSOFT EXCEL.
Email info@datahousebiz.biz to request for a brochure and book your space.
Visit our website www.datahousebiz.biz for other products and training offers.
.
|
