Workshop on Microsoft Excel intermediate Course

Program overview:
Microsoft Excel is the preferred spreadsheet software for many individuals and businesses to manage their data and reporting. Yet most are only using less than 10% of the features of this powerful productivity tool. Learning how to use Excel is an investment in both your personal and professional life.
Microsoft Excel is the spreadsheet and reporting software of choice for today’s busy professional. From
Accountants to Administrative Assistants, from warehouse personnel to the marketing department, there is no spot in any organization where this well-known software program is not used. Despite the daily demands we all face, few of us truly know all the ins and outs of this software program. This course will help you will learn ways to make your job easier and increase your data reporting and analysis. This 2 days hands-on practical training on Intermediate Excel will help participants acquire skills to accomplish tasks more efficiently.

For whom:
This course is designed for Individuals, SME owners, Entrepreneurs, Managers, Senior Supervisors and
Professionals who want expand their excel skills from basics to intermediate level.

Learning objectives:
At the end of the program, participants will be able to:
■ Use time-saving techniques that’ll allow you to get your work done faster with Excel
■ Work with data
■ Use collaboration tools effectively
■ Work with outlines
■ Analyze data with pivot tables
■ Use Logical Functions, Financial and Statistical Functions
■ Nest Functions ·Multiple Worksheet Management and Formulae
■ Create Charts, Use What-If Tools · Protect Worksheets & Workbooks
■ Use Lookup & Informational Functions

Course Outline
■ Module 1: Working with Functions
- Using the paste function tool
- Absolute and relative cell references
- Using range name in functions
- Crested nested functions
- Logical functions (SUMIF, COUNTIF)

■ Module 2: Working with Data
- Using Excel as a database
- Sorting Data
- Custom sorts
- Filtering using AutoFilter
- The Advanced Filter tool

■ Module 3: Working with External Data
- Writing formulas in cells
- Using the formula bar
- AutoSum and other basic functions

■ Module 4: Working with External Data
- Data consolidation
- Linking to another workbook
- Linking to an external database
- Getting data from the web
- Collaboration tools
 Protecting a workbook
 Protecting worksheets and cells
 Adding comments to cells  Sharing workbooks
- What-if Analysis
- Using the scenario manager
- Creating and editing scenarios
- Creating a scenario report
- Using Goal Seek

■ Module 5: Working with Outlines
- Applying an outline
- Automatic outlining
- Displaying and collapsing levels
- Modifying outline settings
- Creating subtotals

Module 6: Analyzing Data with Pivot Tables
- Creating a pivot table
- Defining the source range
- Inserting, moving and deleting fields
- Showing and hiding fields
- Grouping and ungrouping fields
- Excel Macros
- About macros and VBA
- Macro security
- Recording macros & Running a Macro
- Absolute and relative references
- Saving and distributing macros
- Assigning a macro to a button
- Editing macro code
- Automatic macros

Module 7: Protection & Security
- Specifying a password for opening a workbook
- Using the “read-only recommended” option
- Removing a password from an Excel workbook
- Protecting a worksheet or worksheet elements
- Removing workbook protection
- Allowing selective editing of a protected worksheet.

Available on Request

Early Bird: 5% Discount. 5-10 Participants (5% discount). 11 or more participants. (10% discount). This covers Course materials and Certificate of attendance.

No. of Days:	2
Total Hours:	10