Sharper skills using Microsoft Excel 2010 for business
4.3 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
710 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Sharper skills using Microsoft Excel 2010 for business to your Wishlist.

Add to Wishlist

Sharper skills using Microsoft Excel 2010 for business

Learn how to effectively use Microsoft Excel 2010 to modify, analyze and visualize business data
4.3 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
710 students enrolled
Created by Ulrika Hedlund
Last updated 5/2013
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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.

Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:26:45
+
Introduction
1 Lecture 01:54
Welcome to the course "Sharper skills using Microsoft Excel 2010 for business". In this welcome lecture I give an overview of what you will learn and how I have structured the course.
Preview 01:54
+
Viewing data
1 Lecture 08:17
Viewing data in a spreadsheet and getting a good overview of the numbers can be quite tricky if you don’t know how to arrange sheets, rows and columns. In this first lecture I’ll show you how you can effectively navigate a marketing budget with multiple sheets. 
Preview 08:17
+
Analyzing data
2 Lectures 16:57
In this lecture we’ll have a look at a spreadsheet with sales opportunity data and we’ll use sorting and filtering to find the top 10 opportunities, our top performing account managers and deals that are about to close within a specific date range.
Sort and filter your data to find answers
08:46

A very powerful tool for analyzing data is the PivotTable in Excel. Using a PivotTable you can instantly see the sum of a range of numbers and you can easily move data around to see it from different perspectives.
Create a PivotTable to analyze your data
08:11
+
Visualizing data
3 Lectures 24:52
If you have a lot of numbers in a spreadsheet it really helps to visualize your data using charts. Microsoft Excel 2010 has a lot of tools for creating and modifying charts. Unfortunately all of these tools can be a bit overwhelming sometimes.  In this lecture I will show you the most basic steps for creating and modifying charts. After watching this lecture you will know what chart to use when, how to insert a chart in your spreadsheet and how to make basic modifications.
Produce an informative PivotTable report
07:07

Whenever you need to present data during a presentation or share a report with colleagues you might want to spend some time on designing and formatting your charts so that the data is easy to understand and the presentation looks professional. There are countless options to modify charts in Microsoft Excel 2010 and even though I wouldn’t recommend that you spend hours and hours fine-tuning you charts, a few changes to spice up your spreadsheet is not a bad idea. In this lecture I’ll take the charts we created in the previous lecture and show you how you can format and design your charts so that they look great.
Visualize data with basic charts
08:51

Whenever you need to present data during a presentation or share a report with colleagues you might want to spend some time on designing and formatting your charts so that the data is easy to understand and the presentation looks professional. In this lecture I’ll take the charts we created in the previous lecture and show you how you can format and design your charts so that they look great.
Make great looking charts
08:54
+
Cleaning and modifying data
2 Lectures 15:36
From time to time you are given a data file that you need to clean up in order to make some sense of it. The data might have been extracted from a database in which case it isn’t very user friendly to read. In this lecture I will show you how you can take a spreadsheet and how you can clean it up by changing the layout, deleting unwanted data and spotting and removing duplicates.
Clean up your data
06:59

Quite often you have a spreadsheet with data that you need to manipulate in some way. Perhaps you need to share it with others but before you do, you need to rearrange, remove or censor some of the data. In this lecture I’ll show you how we can take the data from the previous lecture and manipulate it by splitting and combining columns, censoring data and changing data types.
Modify your data
08:37
+
Calculating numbers
2 Lectures 17:57
Microsoft Excel is a fantastic tool for calculating numbers. You have a wide range of functions and formulas you can use.  In this lecture I’ll show you how you can use basic calculations in Excel to fill out a simple marketing budget template. I’ll show you how you can quickly add numbers to your spreadsheet, how you can calculate costs and also how you can use absolute and relative references in your calculations.
Use simple formulas to fill out a budget
08:55

In Excel there are a number of built in lookup formulas you can use to determine a value based on a certain criteria. In this lecture I will show you how you can use the lookup functions in Microsoft Excel 2010 to fine-tune the marketing budget we started to fill out in the previous lecture.
Use Lookup formulas to fine-tune your spreadsheet
09:02
+
Closing
1 Lecture 01:12

To conclude, no matter what role you have, knowing how to effectively use Microsoft Excel is extremely important for a business professional. I hope that the enhanced skills you have gained by watching this course will have a significant impact on your work performance.

Summary
01:12
About the Instructor
Ulrika Hedlund
4.5 Average rating
777 Reviews
11,794 Students
13 Courses
Results-focused training

Are you bored of lengthy, feature-based product courses? We are, and that's why we founded Business Productivity. Business Productivity offers unique scenario-based courses showcasing real life business results. Our instructor, Ulrika Hedlund, has years of experience helping organizations improve productivity by combining workplace best practices with effective use of technology.