Excel 2013 - Intro Training View a tutorial on this topic

Platform: PC

Description

Microsoft Excel 2013 is a powerful spreadsheet application that is perfect for maintaining long lists of data, budgets, sales figures and other data. In this online series of training tutorials, we'll show you how to navigate through the basics of Excel and use some new features including Skycloud -- which allows you to share and store files in a location where you can access them with any computer that has Excel. Additionally, you'll learn how to create tables, move information around with ease, and use formulas that can calculate the totals of everything from a monthly budget to a loan payment. Microsoft 2013 has been redesigned and several common functions are now much easier to use. This training series will make sure you get the most out of the program.
Click any of the highlighted titles to view free sample tutorial movies. Atomic Learning subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.
Key # Length
1. preview Introducing the Start screen 98873 1:45
2. locked Introducing the new user interface 98874 1:23
3. locked Signing into and using your Microsoft account 98875 1:07
4. locked Introducing and using Apps for Office 98876 3:04
5. locked Introducing the Formatting task pane 98877 1:41
6. locked Using Backstage view 98878 2:59
7. locked Understanding a worksheet and entering information into a cell 98879 3:14
8. locked Changing the default number of worksheets and the cell movement 98880 2:33
9. locked Using Save and Save As 98881 3:08
10. locked Sharing your files pt. 1 98882 1:56
11. locked Sharing your files pt. 2 98883 2:14
12. locked Working together on a file 98884 2:09
13. locked Moving with the keyboard pt. 1 98885 3:06
14. locked Moving with the keyboard pt. 2 98886 2:11
Key # Length
1. locked Changing the Office Background and/or Office Theme 98887 2:46
2. locked Using and minimizing the Ribbon 98888 2:38
3. locked Changing the Ribbon display options 98889 1:32
4. locked Using the Quick Access toolbar 98890 2:23
5. locked Customizing the Quick Access toolbar 98891 3:15
6. locked Adding/using the Touch/Mouse Mode 98892 1:11
7. locked Resetting the Quick Access toolbar 98893 1:33
8. locked Customizing the Ribbon pt. 1 98894 2:49
9. locked Customizing the Ribbon pt. 2 98895 2:16
10. locked Adding a new tab to the Ribbon 98896 3:13
11. locked Resetting Ribbon customizations 98897 3:44
12. locked Importing/exporting Ribbon customizations 98898 2:27
13. locked Using Keytips 98899 1:11
Key # Length
1. locked Zooming in and out of a worksheet 122960 1:23
2. locked Viewing a worksheet in multiple windows 122961 1:46
3. locked Viewing workbooks side by side 122962 1:02
4. locked Splitting the worksheet window 122963 1:27
5. locked Freezing and unfreezing panes 122964 2:36
6. locked Monitoring cells with the Watch Window 122965 2:32
7. locked Viewing using full screen 122966 1:45
8. locked Creating custom views 122967 2:28
Key # Length
1. locked Using AutoComplete 98900 2:30
2. locked Editing a cell 98901 2:41
3. locked Using spell check 98902 2:13
4. locked Selecting cell ranges pt. 1 98903 3:04
5. locked Selecting cell ranges pt. 2 98904 3:31
6. locked Entering values in a cell range 98905 2:05
7. locked Using AutoFill 98906 2:42
8. preview Using Flash Fill 98907 2:12
9. locked Using Cut, Copy and Paste 98908 3:46
10. locked Using Paste Preview 98909 1:42
11. locked Using Paste Special 98910 1:54
12. locked Using the clipboard pt. 1 98911 3:22
13. locked Using the clipboard pt. 2 98912 2:07
14. locked Using Drag and Drop editing 98913 1:35
15. locked Using Undo and Redo 98914 1:59
16. locked Using the Clear command 98915 1:00
Key # Length
1. locked Sorting data in a worksheet 122968 1:07
2. locked Sorting by columns or multiple criteria 122969 3:13
3. locked Filtering data in a worksheet using AutoFilter 122970 2:53
4. locked Clearing a filter in a worksheet 122971 0:55
5. locked Creating and/or statements using AutoFilter 122972 2:17
6. locked Creating a criteria range 122973 0:49
7. locked Defining criteria using the criteria range 122974 1:55
8. locked Creating and/or statements using the criteria range 122975 2:06
Key # Length
1. locked Using AutoCalculate 98916 2:07
2. locked Using AutoSum 98917 3:09
3. preview Using the Quick Analysis tool pt. 1 98918 2:02
4. preview Using the Quick Analysis tool pt. 2 98919 2:19
5. locked Creating formulas 98920 2:38
6. locked Using functions and the Function Wizard pt. 1 98921 2:16
7. locked Using functions and the Function Wizard pt. 2 98922 3:43
8. locked Editing formulas 98923 3:35
9. locked Checking formulas for errors 98924 1:46
10. locked Using Relative Cell Referencing 98925 2:15
11. locked Understanding Absolute Cell References 98926 2:45
12. locked Creating an Absolute Cell Reference 98927 1:22
Key # Length
1. locked Formatting numbers using the Ribbon 98928 2:54
2. locked Formatting text using the Ribbon 98929 3:16
3. locked Using the Alignment and Indentation commands 98930 1:27
4. locked Rotating information in a cell 98931 2:19
5. locked Wrapping text in a cell 98932 0:57
6. locked Using the Merge and Center command 98933 1:35
7. locked Using the Borders command 98934 1:48
8. locked Drawing cell borders 98935 2:42
9. locked Formatting cells using the Format Cells dialog box 98936 3:41
10. locked Using the Format Painter command 98937 1:53
Key # Length
1. locked Selecting columns and rows pt. 1 98938 2:34
2. locked Selecting columns and rows pt. 2 98939 1:43
3. locked Changing column width 98940 3:56
4. locked Changing row height 98941 3:53
5. locked Hiding and unhiding columns and rows 98942 3:51
6. locked Inserting columns 98943 2:28
7. locked Inserting rows 98944 2:51
8. locked Deleting columns and rows 98945 2:55
9. locked Inserting and deleting cells 98946 2:27
Key # Length
1. locked Creating an outline automatically 122976 1:44
2. locked Creating a manual outline 122977 0:43
3. locked Displaying levels in an outline 122978 1:40
4. locked Hiding the outline symbols 122979 0:43
5. locked Clearing an outline 122980 1:37
6. locked Adding subtotals to a worksheet pt. 1 122981 2:09
7. locked Adding subtotals to a worksheet pt. 2 122982 1:06
Key # Length
1. locked Using cell styles 98947 2:00
2. locked Creating a custom cell style by example 98948 2:35
3. locked Creating a custom cell style 98949 2:58
4. locked Deleting a custom cell style 98950 0:47
5. locked Modifying a custom cell style 98951 1:46
6. locked Merging custom cell styles 98952 1:14
7. locked Using themes 98953 0:46
8. locked Customizing themes 98954 1:12
9. locked Formatting as a table pt. 1 98955 1:41
10. locked Formatting as a table pt. 2 98956 2:46
11. locked Creating a custom table style pt. 1 98957 2:05
12. locked Creating a custom table style pt. 2 98958 2:05
13. locked Deleting a custom table style 98959 1:13
Key # Length
1. locked Using Normal view 98960 0:51
2. locked Using Page Layout view 98961 3:27
3. locked Using Page Break preview 98962 0:46
4. locked Using the Page Layout tab 98963 3:46
5. locked Changing the margins 98964 2:52
6. locked Changing the page orientation and paper size 98965 0:50
7. locked Setting manual page breaks 98966 14:52
8. locked Setting print titles 98967 2:36
9. locked Creating headers and footers 98968 2:20
10. locked Using the Page Setup dialog box 98969 2:13
Key # Length
1. locked Using Print and Print Preview 98970 1:55
2. locked Using Share 98971 1:42
3. locked Using Export 98972 0:56
4. locked Setting print areas 98973 3:20
5. locked Adding to and clearing print areas 98974 1:57
Key # Length
1. locked Formatting numbers automatically 129096 1:42
2. locked Understanding custom number formatting 129097 2:02
3. locked Creating a custom number format 129098 2:53
4. locked Creating custom date and time formats 129099 2:22
5. locked Hiding the contents of a cell using a custom format 129100 1:48
6. locked Deleting a custom format 129101 0:55
Key # Length
1. locked Importing a text document 129102 4:14
Tutorial series by Dan Kuemmel, Cindy Rybaczyk
Box shot reprinted by permission from Microsoft Corporation. Microsoft and Excel are registered trademarks of Microsoft Corporation in the United States and/or other countries.

Prices and offers are subject to change. © 2016 Best Buy. All rights reserved. BEST BUY, the BEST BUY logo, the Tag Design, MY BEST BUY, and BESTBUY.com are trademarks of Best Buy and its affiliated companies.