2013
Lynda
Dennis Taylor
6:32
English
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
Introduction 1m 6s
Welcome 43s
Using the exercise files 23s
1. Getting Started with Excel 2013 29m 37s
What is Excel used for? 1m 49s
Using the menu system 4m 30s
The Quick Access Toolbar 4m 41s
The structure of a worksheet or workbook 3m 41s
Using the Formula bar 1m 43s
Using the Status bar 2m 24s
Navigation and mouse pointers 2m 20s
Shortcut menus and the Mini toolbar 3m 24s
Using the built-in help 2m 54s
Creating new files 2m 11s
2. Entering Data 24m 1s
Exploring data entry and editing techniques 4m 41s
Entering data with AutoFill 4m 6s
Working with dates and times 3m 32s
Using Undo and Redo 4m 50s
Adding comments 2m 55s
Using Save or Save As 3m 57s
3. Creating Formulas and Functions 30m 7s
Creating simple formulas: Totals and averages 5m 25s
Copying a formula for adjacent cells 2m 54s
Calculating year-to-date profits 3m 9s
Creating a percentage-increase formula 4m 7s
Working with relative, absolute, and mixed references 4m 7s
Using SUM and AVERAGE 3m 25s
Using other common functions 7m 0s
4. Formatting 46m 7s
Exploring font styles and effects 4m 7s
Adjusting row heights and column widths 3m 37s
Working with alignment and Wrap Text 4m 2s
Designing borders 3m 26s
Exploring numeric and special formatting 5m 36s
Formatting numbers and dates 4m 31s
Conditional formatting 4m 21s
Creating and using tables 9m 59s
Inserting shapes, arrows, and other visual features 6m 28s
5. Adjusting Worksheet Layout and Data 20m 40s
Inserting and deleting rows and columns 4m 52s
Hiding and unhiding rows and columns 4m 2s
Moving, copying, and inserting data 5m 42s
Finding and replacing data 6m 4s
6. Printing 17m 51s
Exploring the Page Layout tab and view 7m 20s
Previewing page breaks 4m 56s
Working with Page Setup and printing controls 5m 35s
7. Introduction to Charting 30m 30s
Creating charts 4m 36s
Exploring chart types 7m 47s
Formatting charts 5m 42s
Working with axes, labels, gridlines, and other chart elements 5m 35s
Creating in-cell charts with sparklines 6m 50s
8. Adjusting Worksheet Views 12m 49s
Freezing and unfreezing panes 2m 39s
Splitting screens horizontally and vertically 4m 48s
Showing necessary information with the Outlining feature 5m 22s
9. Multiple Worksheets and Workbooks 23m 0s
Displaying multiple worksheets and workbooks 4m 17s
Renaming, inserting, and deleting sheets 2m 23s
Moving, copying, and grouping sheets 3m 39s
Using formulas to link worksheets and workbooks 6m 1s
Locating and maintaining links 6m 40s
10. IF, VLOOKUP, and Power Functions 20m 25s
Using IF functions and relational operators 3m 43s
Getting approximate table data with the VLOOKUP function 7m 6s
Getting exact table data with the VLOOKUP function 4m 42s
Using the COUNTIF family of functions 4m 54s
11. Security and Sharing 23m 50s
Unlocking cells and protecting worksheets 7m 50s
Protecting workbooks 2m 40s
Assigning passwords to workbooks 4m 41s
Sharing workbooks 4m 7s
Tracking changes 4m 32s
12. Database Features 28m 32s
Sorting data 6m 9s
Inserting subtotals in a sorted list 8m 25s
Using filters 6m 16s
Splitting data into multiple columns 5m 4s
Removing duplicate records 2m 38s
13. PivotTables 35m 2s
Creating PivotTables 8m 36s
Manipulating PivotTable data 9m 47s
Grouping by date and time 6m 0s
Grouping by other factors 2m 33s
Using slicers to clarify and manipulate fields 4m 7s
Using PivotCharts 3m 59s
14. Data Analysis Tools 23m 29s
Using Goal Seek 6m 8s
Using Solver 6m 34s
Using Scenario Manager 6m 11s
Using Data Tables 4m 36s
15. Introduction to Macros 24m 31s
Definition and examples 6m 48s
Creating a simple macro 7m 0s
Running a macro 10m 43s
Conclusion 29s
Next steps 29s

http://www.lynda.com/Excel-tutorials/Excel-2013-Essential-Training/116478-2.html

Download File Size:1.52 GB

---