IT Training - Microsoft Excel

Microsoft Excel Course Overview
 

Among the computer programs which exist, Microsoft Excel is one of the most important because of the key role it plays in many sectors. It is the most used spreadsheet program in many business activities, classwork and even personal data organization. Excel was first released in the year 1985. Since then, it has played a vital role in performing formula based arithmetic and calculations, and other activities that may require mathematical calculations. Many businesses, personal and institutional enterprises have embraced the use of Excel because of its utility and the ability to serve as a visual basic for different applications. To possess the excel skills, we provide three different classes for three different levels. Which are Basic, Intermediate and Advance.
 

Microsoft Excel – Basic

If you have little or no experience with Microsoft Excel, this 1-day Excel course will provide you with a comprehensive introduction to use all features in Excel. You will gain practical skills to use immediately in the workplace. Learn to create, edit, format, and print basic Microsoft Excel worksheets. Our Excel master will share tips that will help you save time and better display your data on screen and in print.

At the end of this course, you will be able to:

1. Create basic worksheets using Microsoft Excel

2. Modify and manage Excel workbooks

3. Learn to insert the right data

4. Manage to format and align the data

5. Print the content of an Excel worksheet

Choose this Excel level if you are comfortable doing basic tasks in spreadsheets and want to learn to create more powerful and dynamic spreadsheets. This level trains you to streamline and analyze data. Learn to keep data organized by managing large data sets with lists and tables especially Pivot tables and Vlookup functions.

At the end of this course, you will be able to:

1. Create and understand the concept of formula

2. Insert and modify other function in worksheets

3. Learn and work with table and charts

4. Learn to use conditional formatting and styles

5. Utilize the Pivot tables to obtain a desired report
 

Intermediate Excel Course Outline