Microsoft Excel Part 2 & 1

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