Some Excel 2013 videos by Microsoft…

LAST UPDATE 03/07/2015

Here is a list of videos made by Microsoft on Excel 2013; I think they are all very well made and they are listed in skill level, from basic to advanced.

Add numbers in Excel 2013: Watch these videos to see how Excel 2013 makes it easy to add numbers using formulas, buttons, and functions (such as the SUM and SUMIF functions).
Watch online

Basic math in Excel: Let Excel be your calculator. Take this course to learn how to add, subtract, multiply, and divide using formulas and functions.
Watch online

Create a chart: Charts provide a visual representation of your data, making it easier to analyze. Each type of chart highlights data differently. And some charts can’t be used with some types of data.

Watch online

Create your first Excel 2013 workbook: Watch these videos to learn how to use Excel 2013. Get started with the new version to see how to do everyday tasks.

Watch online

Freeze or lock panes: You want to scroll down and see your rows of data, but when you get to the bottom of the screen, your column names in the top row have disappeared. To fix this, you freeze the top row so that it’s always visible. Good news – the command is easy to get to. Click View > Freeze Panes > Freeze Top Row.
Watch online

Understand and use cell references: One of the key things you’ll calculate in Excel are values in cells, the boxes you see in the grid of an Excel worksheet. Each cell is identified by its reference—the column letter and row number that intersect at the cell’s location. For example, a cell in column D and row 5 is cell D5. When you use cell references in a formula, Excel calculates the answer automatically using the numbers in the referenced cells.
Watch online

Use AutoFill and Flash Fill: Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious. But the AutoFill feature can help. Or say you have information in Excel that isn’t formatted the way you need it to be, and going through the entire list manually to correct it is daunting. In this case, Flash Fill (a new feature in Excel 2013) can do the work for you. AutoFill and Flash Fill are tremendous time savers, and in this course, we’ll cover them in more detail.
Watch online

Sort and filter data

Excel is an amazing tool for analyzing data. And Sort and Filter are some of the most commonly used features to help you. To change the order of your data, you’ll want to sort it. To focus on a specific set of your data, you can filter a range of cells or a table. Take this course to learn more.

Watch online

Take conditional formatting to the next level

In the course Use conditional formatting, we covered the basics of conditional formatting. Here, we’ll go a few steps further and see how to apply conditional formatting to cells, tables, PivotTables, and worksheets. For example, to quickly conditionally format cells, you can use a Quick Analysis option or an option on the Conditional Formatting button in the ribbon. We’ll also use formulas to apply conditional formatting, and learn how to edit and delete rules using the Conditional Formatting Rules Manager.

Watch online

Use conditional formatting

It can be hard to get a lot of meaning out of numbers in a worksheet. But Excel provides a bunch of ways to quickly analyze your data using conditional formatting. For example, you can use a color scale to differentiate high, medium, and low temperature values.

Watch online

VLOOKUP: When and how to use it
Learn how to use the VLOOKUP function to find data in a large spreadsheet, and on other worksheets in a large workbook. These videos explain each of the VLOOKUP arguments, and mistakes to avoid.
Watch online

Webinar: Simplifying Your Excel Data
This 15-minute video goes over Conditional Formatting, the new Quick Analysis feature, and making better charts for presentations.
Watch online

Advanced Excel Videos

Advanced IF functions: Take this course to learn complex examples and variations of the IF function in Excel, including nested IF functions, IF with AND and OR, COUNTIFS and SUMIFS, and AVERAGEIFS and IFERROR.
Watch online

Array formulas: Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results. Take this course to learn more.

Watch online

Create and manage drop-down lists: You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list. Take this course to learn more about how best to use and manage them.
Watch online

PivotTable: Learn what a PivotTable and PivotCharts are and how you can use them to summarize and analyze data in Excel 2013.
Watch online

Password protect workbooks and worksheets: Your Excel workbook or worksheets contain sensitive strategic data, so you want to require others to enter a password to open them. Or you can share the data freely with anyone without requiring a password, but require a password to make changes. Take this short course to find out more.
Watch online

Print worksheets and workbooks: Print Excel worksheets and workbooks one at a time, or several at one time. You can also print a partial worksheet, such as an Excel table.
Watch online

Webinar Understanding Power Pivot: Power Pivot lets you import massive amounts of data from different sources and mash it together to create useful reports. Now that you have started in, Owen Duncan, Senior Content Developer for Power Pivot, will show you the ropes in this video.
Watch online

Webinar: Understanding the Excel Data Model – The Excel data model is revolutionizing how you work with data. A discussion and demo with Owen Duncan, Senior Content Developer.
Watch online

Work with macros: You want to automate a repetitive task in Excel so that you can do the task again with a single click. The best way to do that? Record a macro. And the macro recorder is the easiest way to create a new macro in Excel. Take this course to learn more.
Watch online

These are from the office.com webisite

Hector Garcia

Hector Garcia

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published.



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022