Last updated 5/2013
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.77 GB | Duration: 1h 27m
Learn how to effectively use Microsoft Excel 2010 to modify, analyze and visualize business data
What you'll learn
By the end of this course you will know how to effectively use Microsoft Excel 2010 to:
Easily navigate spreadsheets
Quickly find answers by sorting and filtering data
Analyze data using PivotTables
Create great looking reports
Clean up and modify data to make it more readable
Requirements
Basic knowledge of any version of Microsoft Excel. Those viewers who have Microsoft Excel 2010 will benefit the most from this course.
Description
Do you wish you were one of those who can do wonders with numbers in a spreadsheet? Do you want to get up to speed quickly and learn from an expert how to effectively use Microsoft Excel to perform common business tasks? If so, this is the course for you!In this course you will learn how to efficiently navigate spreadsheets, you will learn how to use various tools to analyze data and how to create great looking reports with tables and charts. Instead of learning how to use Excel feature by feature, you will learn how to effectively use Microsoft Excel 2010 in real life business scenarios like calculating costs in a marketing budget, analyzing sales opportunities and creating sales reports.
Overview
Section 1: Introduction
Lecture 1 Welcome
Section 2: Viewing data
Lecture 2 Effectively navigate a spreadsheet
Section 3: Analyzing data
Lecture 3 Sort and filter your data to find answers
Lecture 4 Create a PivotTable to analyze your data
Section 4: Visualizing data
Lecture 5 Produce an informative PivotTable report
Lecture 6 Visualize data with basic charts
Lecture 7 Make great looking charts
Section 5: Cleaning and modifying data
Lecture 8 Clean up your data
Lecture 9 Modify your data
Section 6: Calculating numbers
Lecture 10 Use simple formulas to fill out a budget
Lecture 11 Use Lookup formulas to fine-tune your spreadsheet
Section 7: Closing
Lecture 12 Summary
This course is intended for those who have basic knowledge of how to use Microsoft Excel but who want to sharpen their skills using Microsoft Excel 2010 for business.
Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
