2014
Pluralsight
Heather Ackmann
5h 34m
English
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.
01. Introduction to Excel 2013
01. Introduction.mp4
02. Creating a New Workbook.mp4
03. Opening an Existing Workbook.mp4
04. Signing into Excel 2013.mp4
05. The Ribbon.mp4
06. The Quick Access Toolbar.mp4
07. The Formula Bar.mp4
08. The Status Bar.mp4
02. Navigating, Selecting, and Entering Data
01. Introduction.mp4
02. Navigating a Spreadsheet.mp4
03. Selecting and Entering Data.mp4
04. AutoFill.mp4
05. FlashFill.mp4
06. Saving.mp4
03. Working with Rows, Columns, and Worksheets
01. Introduction.mp4
02. Inserting and Deleting Rows and Columns.mp4
03. Hiding and Unhiding Rows and Columns.mp4
04. Adding, Renaming, and Coloring Worksheets.mp4
05. Moving and Deleting Worksheets.mp4
06. Viewing Multiple Worksheets or Workbooks.mp4
04. Introduction to Formulas
01. Introduction.mp4
02. Excel Math.mp4
03. Creating a Simple Formula.mp4
04. Relative, Absolute, and Named References.mp4
05. Named References.mp4
05. Introduction to Functions and 3D Formulas
01. Introduction.mp4
02. Excel Functions.mp4
03. Sum, Average, and Count.mp4
04. Introduction to 3D Formulas.mp4
06. Sorting and Filtering Data
01. Introduction.mp4
02. Quick Sort and Custom Sort.mp4
03. Creating Subtotals.mp4
04. AutoFilter.mp4
05. Custom Filters.mp4
06. Advanced Filters.mp4
07. Introduction to Formatting
01. Formatting Basics.mp4
02. Working with Alignment.mp4
03. Number Formats.mp4
04. Date and Times.mp4
05. Conditional Formatting.mp4
08. Introduction to Charts
01. Introduction.mp4
02. Chart Types.mp4
03. Creating a Chart.mp4
04. Chart Elements.mp4
05. Chart Filters.mp4
06. Change the Chart Type.mp4
07. Sparklines and Data Bars.mp4
09. Introduction to PivotTables and PivotCharts
01. Introduction.mp4
02. Creating a PivotTable.mp4
03. Formatting a PivotTable.mp4
04. Creating a Calculated Field.mp4
05. Slicers.mp4
06. Creating a PivotChart.mp4
10. Introduction to Printing
01. Introduction.mp4
02. Print Views and Page Breaks.mp4
03. Print Scaling.mp4
04. Print Settings.mp4
05. Adding Print Titles and Gridlines.mp4
11. Conclusion
01. Conclusion.mp4
http://pluralsight.com/
Download File Size:1.26 GB