7 - 8 September, 2017 | Intercontinental Hotel, Lusaka
The Advanced Microsoft Excel Techniques Training workshop , will deal with advancing functions and tools for working with and reporting on large spreadsheets. This training teaches how to work with auto shapes, graphs , word Art, clip art as well as work with pivot tables, pivot charts and learn how to manage exporting and importing of files, data and query external databases.
This course is instructor led, and involves lots of examples and exercises in a workshop environment.
BENEFITS
- Excellent learning material
- More efficient data management and consolidation
- Use logical functions, Financial and statistical Functions
- Job advancement
- Improved productivity in the workplace
- Learn what business is all about.
- Learn how to model and work with data.
- Learn how to design and build your own BI applications.
- Get familiar with Microsoft as a Business Intelligence solution.
WHO SHOULD ATTEND
This training has been designed for Excel users who’re ready to tap into the advanced features and functions for increased efficiency and productivity, and for greater capability to analyze and share data.
- Managers and supervisors
- Office managers
- Accounting and finance professionals
- Administrative assistants
- Project managers
- Sales managers
- Business professionals
- Personal Assistants
- Human Resources Personnel
- Database administrators
- Anyone who generates reports, analyzes data, or uses spreadsheets in their work
Workshop Prerequisites
All delegates are requested to come with a Laptop with preinstalled Excel.
WHAT WILL BE COVERED
Various topics will be covered including:
Data and Worksheets
- Working with data by splitting and combining cells
- Using conditional formatting to analyze data easier
- Creating hyperlinks
- Grouping, viewing or hiding
- multiple worksheets and workbooks
- Protecting worksheets and workbooks
Formulas and Data Analysis
- Understanding formulas and functions
- Using different methods to sum up totals
- Using cell references and names in formulas
- Using lookup functions, text functions, logical functions, financial functions, statistical functions and mathematical functions
- Analyzing data
- Creating a summary worksheet
- Using Power View to create a visual worksheet
Data analysis using Pivot
- Tables and Pivot Charts
- Giving a definition of a Pivot Table and describing its layout
- Creating a PivotTable
- Modifying and formating an existing PivotTable
- Creating charts
- Creating charts from PivotTables
FEES: K2,500 Per delegate (inclusive of teas, lunch & certificate)
EARLY BIRD OFFER: Get 10 % Discount on bookings made 10 work days before the event date. Enroll 3 participants and get the 4th at 50% Discount.
For bookings and clarification, contact: Phone- 0211 295486, 0975 844051; Email- This email address is being protected from spambots. You need JavaScript enabled to view it.