Take this
course

Business / Accounting & Finance

Effective Use of Excel 2013 in real life

Learn how to effectively use Microsoft Excel 2013 in real-life business scenarios

Description

Do you wish you knew how to effortlessly navigate a spreadsheet and easily find trends and abnormalities in the data? Do you wish you could create informative reports that really show off your numbers? Do you wish you could save time by knowing how to effectively use Excel to re-arrange and clean up your data? If so, this is the right course for you! Instead of walking through individual features of Microsoft Excel one by one, this course focuses on the end result and shows you how to accomplish typical business scenarios by effectively using Excel 2013. The course is structured into 6 sections with a total of 11 lectures. Each lecture is taught by Productivity Expert and ex-Microsoft employee, Ulrika Hedlund who shares her extensive knowledge of using Microsoft Excel 2013 effectively. Each lecture contains high-quality, High-Definition tutorial videos showing step by step how to accomplish the covered scenario. Sample spreadsheets are provided where necessary to enable students to follow along and perform the steps covered in the lecture. Full transcripts with screenshots (so called "User Guides") are available for download so that the steps covered in the lectures can be referenced at any time.
Full details

Curriculum

  • Introduction
    Introduction to the Course
    3:11
  • Viewing Data
    Effectively navigate a spreadsheet
    In this lecture you'll learn how to sort and filter data to find answers to specific questions. You'll learn how to sort data by multiple columns, how to sort by color and how to filter using different data types.
    9:54
    Check what you've learnt in this lecture
    Sort and filter data to find answers
    In this lecture you'll learn how to sort and filter data to find answers to specific questions. You'll learn how to sort data by multiple columns, how to sort by color and how to filter using different data types.
    9:55
    Test what you've learnt in this lecture
  • Cleaning and modifying data
    Rearrange and clean up your data
    In this lecture you will learn how to re-arrange data, how to spot and remove duplicates and how to change data types for easier analysis.
    9:03
    Check what you've learnt in this lecture
    Modify your data using Flash Fill
    In this lecture you will learn how to use the new, powerful tool Flash fill. You will also learn how to use traditional tools and formulas to modify your data.
    9:46
    Test what you've learnt in this lecture
  • Analyzing and visualizing data
    Analyze data using a PivotTable
    When you are analyzing data it helps to look at it from different perspectives. For instance, how much did we sell last month? Or how much did we spend this year compared to last? A very powerful tool for analyzing data that you quickly want to summarize is the PivotTable in Excel. In this lecture you'll learn how to use a PivotTable to analyze data.
    9:53
    Check what you've learnt in this lecture
    Visualize data using charts
    If you have a lot of numbers in a spreadsheet it really helps to visualize your data using charts. In this version of Excel, it's a lot easier to select appropriate charts since Excel analyzes your data and recommends charts for you. In this lecture you'll learn how to use charts to spot trends and how to use the updated charting tools to make your charts really stand out.
    9:49
    Test what you've learned in this lecture
  • Using formulas to perform calculations
    Use simple formulas to fill out a budget
    Excel is a fantastic tool for calculating numbers. You have a wide range of functions and formulas you can use. In this lecture you'll learn how to use basic calculations in Excel to fill out a marketing budget template. You'll also learn some shortcuts for how to quickly fill your spreadsheet with numbers, how to calculate sums and how to use absolute and relative references.
    9:22
    Check what you've learnt in this lecture
    Use Lookup formulas to fine-tune your spreadsheet
    Sometimes when you are doing calculations you need to base your numbers on a certain criteria. For example, the amount you pay your employees might depend on how well they have performed. In this lecture you will learn how to use lookup functions in Excel to fine-tune your calculations.
    9:08
    Test what you've learned in this lecture
  • Closing
    Summary
    1:08
    Test what you've learned in this course

Skills

  • Business Analytics
  • Spreadsheet
  • Microsoft Excel

Similar Courses

More Courses by this Instructor