Microsoft Excel Training Course

Your desire to acquire Microsoft Excel Skills shows that you are interested in data creation, reporting, development, and analysis. Data Analysis, alone, is one of the most important competencies in today’s business. The Learning Edge’s Microsoft Excel Training brings these and more to you.

Microsoft Excel Training is now a very important requirement for every professional. The reason for this is that at various levels of your career, you will be required to use the skill.

Microsoft Excel Training Schedules

We have 2 kinds of training schedules. They are the weekend schedule and the weekdays’ schedule.

1. The first program spans 3 weekends (3 Saturdays ). It is workshop style. It is designed for people who work and are too busy to attend the weekday plan. Those in this category must complete their assignments and projects before the next class. They must also participate in the post-training support class group so that they can master the use of the software.

2. The second program spans for 2 weeks (Weekdays Version). It’s from Tuesday to Friday on both weeks.

What you will get after the training

microsoft excel training lagos — **PHOTO**: Participants after a training session. Copyright (All Rights Reserved).

The training will help you to get the following

1. A full knowledge of Microsoft Excel, its tools, how to use them, and so on.

2. Application of Microsoft Excel skills.

3. New acquaintances. There will be an opportunity to network and make new friends.

4. Post-training support focus group

5. Enhanced chances of being employed or of getting a promotion.

6. You will get a recognized certificate that demonstrates that you have developed competence in Data Analysis through Microsoft Excel.

Microsoft Excel Training Outline

The Microsoft Excel Training course content is segmented into introduction, intermediate and advanced.

INTRODUCTION TO EXCEL
1. Understanding the Excel Interface
2. Creating Excel Spreadsheets
3. Entering/Editing Data
4. Working with Formulas
5. How to Format Data
6. Understanding Excel Print Options
7. Common Excel Shortcuts
8. How to Visualize Data with Charts

INTERMEDIATE EXCEL
1. Working with Excel lists & tables
2. How to Sort and Filter Data
3. Understanding & Working with List Functions
4. Rules for Data Validation
5. How to Import and Export data
6. How to Summarize Data with Pivot tables
7. Managing large sets of data

ADVANCED EXCEL
1. Create advanced Excel Formulas
2. Lookup functions
3. Text-based functions
4. Auditing Excel Worksheets
5. “What if” Analysis
6. Protecting Excel Worksheets
7. Introduction to Macros

AUTOMATING EXCEL WITH MACROS/VBA
1. Automate Excel Tasks
2. Save time and money
3. Macro Recording
4. Creating Buttons
5. Introduction to Excel VBA
6. Creating VBA Procedures
7. Create a User Interface with VBA Forms
8. Importing Data with VBA.