Excel 2013 Fundamentals

If you are new to Excel or Excel 2013, this course will walk you through some basics to get you started, including navigation, functions, PivotTables and PivotCharts, and more.
Course info
Rating
(482)
Level
Beginner
Updated
Feb 5, 2014
Duration
5h 34m
Table of contents
Introduction to Excel 2013
Navigating, Selecting, and Entering Data
Working with Rows, Columns, and Worksheets
Introduction to Formulas
Introduction to Functions and 3D Formulas
Sorting and Filtering Data
Introduction to Formatting
Introduction to Charts
Introduction to PivotTables and PivotCharts
Introduction to Printing
Conclusion
Description
Course info
Rating
(482)
Level
Beginner
Updated
Feb 5, 2014
Duration
5h 34m
Description

This course covers everything you need to know to get started in Excel 2013. Starting with an overview of how to navigate in Excel using both the mouse and keyboard shortcuts, Heather Ackmann dives into popular topics including writing formulas and expressions, popular functions, sorting and filtering, conditional formatting, PivotTables and PivotCharts, and more.

About the author
About the author

Heather Ackmann is an accomplished instructor with a decade of teaching experience, helping students at the high school, college, and adult levels in a variety of topics. Specializing in Microsoft Office computer applications, she is a Microsoft Office Certified Master and holds a degree in English and Secondary Education.

More from the author
End-user Communications for Better IT
Beginner
2h 37m
17 May 2017
Word 2016 for Power Users
Beginner
2h 23m
21 Dec 2016
Microsoft Word (2016): Essentials
Beginner
1h 32m
4 May 2016
More courses by Heather Ackmann
Section Introduction Transcripts
Section Introduction Transcripts

Introduction to Excel 2013
Welcome to Pluralsight, I'm Heather Ackmann and this module is introduction to Excel 2013. If you are brand new to Excel or upgrading from a previous version of Excel this will be a tremendously valuable lesson to watch. Moving to a new version of a program is a lot like moving to a new city. You can stumble through it on your own or go on a guided tour. Trust me a guided tour is way better. So consider this module a guided tour of your new Excel 2013 working environment.

Navigating, Selecting, and Entering Data
Welcome once again to Pluralsight, this is the second module in the Excel 2013 fundamentals course. In the first module we took a tour of the Excel 2013 interface briefly discussing where things are located in the ribbon, within backstage view, and other areas of the Excel window. Now we're going to focus our attention on the individual spreadsheet and discuss the various ways of navigating, selecting, and entering data within that spreadsheet.

Working with Rows, Columns, and Worksheets
Hi again I'm Heather Ackmann and this module is Working with Rows, Columns, and Worksheets. Now I you have ever found yourself cutting and pasting cells of information just to rearrange data or to add a new row in-between existing data. Or if you have ever wished you had more than one worksheet or even wished you could view separate worksheets side by side in Excel or across multiple monitors, then this lesson is for you.

Introduction to Formulas
Hi again Heather Ackmann here to give you an introduction to formulas in Excel 2013. Now there is a ton that you can do with formulas or expressions in Excel, but given the scope of this fundamentals course I will be quickly introducing you to some key topics and concepts to get you started,

Introduction to Functions and 3D Formulas
Hi again Heather Ackmann here to give you an Introduction to Functions and 3D Formulas in Excel. Now there are a ton of functions that you can use in Excel and like the last lesson, given the scope of this fundamentals course, I will be quickly introducing you to some of the most commonly used functions to get you started.

Sorting and Filtering Data
Hi again, Heather Ackmann here and this module is Sorting and Filtering Data in Excel 2013. Now if you are like most Excel users you more than likely use Excel to store data and if you don't you more than likely will store data at some point. Now considering that Excel has the potential to store, as we learned in another module, billions of cells on a single worksheet, that's a lot of data to sort through. And sure, I showed you a few keyboard shortcuts to help you navigate large spreadsheets, but with that amount of data you're going to need something a little bit better to sort and filter your information.

Introduction to Charts
Hi again, Heather Ackmann here to give you an Introduction to Charts in Excel 2013. As you've already seen, entering numbers into Excel is not hard. What is hard is staring in Excel and trying to analyze or derive meaning from all those rows and columns of numbers. In fact, the spreadsheet row, column format, although it is great for calculating is terrible for viewing and unless you are a special type of person who can glance at numbers and immediately internalize their meaning you're going to need a better way of visualizing data. Charts can help with that.

Introduction to Printing
If you are one of the dwindling percentage of people still in need of printing your spreadsheets, then this lesson is for you, especially if you have ever hit that print button only to realize after the spreadsheet printed that the last column or last few rows appear all by itself on page 2, then this lesson is really for you. Yes, I will be showing you a quick and easy way to fix just that, as well as give you a tour of all the various print settings and views in Excel 2013.