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.
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.
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.