Excel Made Easy

Watch Excel Made Easy

  • 2010
  • 1 Season

These videos will show how to use to use Microsoft Excel, step-by-step. They will include videos on: Formulas, Formatting, Functions, Sorting, Filtering, Subtotals, Pivot Tables, Charts, Data Analysis, Macros, and many other topics

Excel Made Easy
Filter by Source
No sources available
Seasons
Importing a CSV file into a Microsoft Excel Spreadsheet
5. Importing a CSV file into a Microsoft Excel Spreadsheet
 
This video will show you how to import a CSV file into Microsoft Excel. It will work in Excel 2016, Excel 2013, Excel 2010, Excel 2007 and even Excel 2003. A CSV file is a plain text file. CSV means Comma Separated Values, which means that each field is separated by a comma. It is a very popular format. This video will demonstrate 2 different ways to import that file into an Excel spreadsheet.
Episode 4 : Making and Managing Charts in Excel
4. Episode 4 : Making and Managing Charts in Excel
 
This video will show you everything you need to know to start making and managing charts in Excel. It covers column charts, adding chart options, adding a trend line, adding vertical titles on the chart bars, creating chart templates, 2-axis charts, using an Excel chart in Word or PowerPoint or other programs, printing charts, sparklines, pie charts, doughnut charts, and the bar in the pie charts.
Episode 3 - named ranges, linking worksheets and workbooks, the speed fill and auto fill, and how to calculate the percent of change.
3. Episode 3 - named ranges, linking worksheets and workbooks, the speed fill and auto fill, and how to calculate the percent of change.
 
This video will show you some more very important features of formulas, including using named ranges, linking formulas from one sheet to another, the speed fill / autofill, and a real life example of how to calculate the percent of change. These are must have skills for all Microsoft Excel users. I will show you step-by-step on exactly how to do these formulas. Microsoft Excel 2010 Introductory.
Using AutoSum, relative and absolute formulas, speed fill / auto fill with a formula, creating an average,
2. Using AutoSum, relative and absolute formulas, speed fill / auto fill with a formula, creating an average,
 
This video will show how to use the AutoSum, relative and absolute formulas, speed fill / auto fill with a formula, creating an average, It will really show you how to continue build your spreadsheets with techniques that you will use all the time, and that will save you lots of time.
Excel Formula Basics
1. Excel Formula Basics
December 31, 2010
In this video, I will show you the fundamentals in building an Excel math formula. It will include the three rules of building a formula, the mathematical order, and a bunch of examples.
Description
  • Premiere Date
    December 31, 2010