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.

Note: Participants come along with their laptops

For whom:
This course is designed for Individuals, SME owners, Entrepreneurs, Managers, Senior Supervisors and Professionals who want expand 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; and
• use Lookup & Informational Functions.

Course Outline

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)

Working with Data

• Using Excel as a database
• Sorting Data
• Custom sorts
• Filtering using AutoFilter
• The Advanced Filter tool

Working with External Data

• Writing formulas in cells
• Using the formula bar
• AutoSum and other basic functions

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

Working with Outlines

• Applying an outline
• Automatic outlining
• Displaying and collapsing levels
• Modifying outline settings
• Creating subtotals

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

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.

Training Methodology

Lectures, discussions, exercises, and case studies will be used to reinforce these teaching/learning methods.