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:
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
Basic Excel Course Outline
Microsoft Excel – Intermediate
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:
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
Microsoft Excel – Advanced
Already comfortable using Microsoft Excel? Take your skills to the next level in this Advanced Excel course. Our Excel master will share Excel’s most powerful and advanced tools, including Advanced Formula, PivotTables, Macros, and more. You will gain skills for better collaboration, including tracking changes, learn to audit worksheets, validate data to ensure consistency, and use other essential business tools in Microsoft Excel.
At the end of this course, you will be able to:
At the end of this course, you will be able to:
1. Enhance Formula in Worksheets
2. Learn to auditing, validating and protecting workbook
3. Create advanced charts, graphs and Pivot tables
4. Import and export data
5. Create, use, edit and manage Macros
Advance Excel Course Outline