The Advanced 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
Topics will include:
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 Pivot able
- Modifying and formatting an existing Pivot Table
- Creating charts
- Creating charts from Pivot Tables
