MICROSOFT EXCEL PART 1 & 2

About the Course:
Microsoft Excel is very popular software program included in the Microsoft office suite and used to create spreadsheets documents which is laid out in rows and columns as a big table. Excel has become one of the most used software programs in the business world due to its supreme versatility and power. Excel is an extraordinary powerful tools used frequently in the business world to store, manipulate and measure complex set of data. Below are a few examples a company might use Excel. these are just examples, excel is very flexible and robust so the uses are endless:

• Keeping track of sales by customer from month to month
• Monitoring customer payments to ensure that none are late
• Keeping track of expenses and assign them to particular employees
• Calculating hours worked per employee for monthly payroll;
• Calculating monthly payments on the office mortgage;
• Creating graphs or charts to explain company performance over time
• Estimate monthly sales for the next three years based on historical data
• Assign projects and tasks to employees in a centralized location.

Exams:
77-727, 77-728

Course Duration:
16 Hours

Awarding Body:
Microsoft

Pre-Requisites:
Pre and Post Course Tests

Modules:
Part 1
Lesson 1: Getting Started with Microsoft Office Excel 2013

Lesson 2: Performing Calculations

Lesson 3: Modifying a Worksheet

Lesson 4: Formatting a Worksheet

Lesson 5: Printing Workbooks

Lesson 6: Managing Workbooks

Part 2
Lesson 1: Working with Functions

Lesson 2: Working with Lists

Lesson 3: Analyzing Data

Lesson 4: Visualizing Data with Charts

Lesson 5: Using PivotTables and Pivot Charts