Free Excel 2016 Tutorial At GCFGlobal

Có thể bạn quan tâm

1 Getting Started with Excel arrow_forward_ios ✓ Learn your way around the Excel 2016 environment.
2 Understanding OneDrive arrow_forward_ios ✓ Learn all about working with your Microsoft account and OneDrive.
3 Creating and Opening Workbooks arrow_forward_ios ✓ Learn how to create and open Excel workbooks.
4 Saving and Sharing Workbooks arrow_forward_ios ✓ Learn how to save and share Excel workbooks.

5 Cell Basics arrow_forward_ios ✓ Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
6 Modifying Columns, Rows, and Cells arrow_forward_ios ✓ Learn how to modify rows, columns, and cells in Excel.
7 Formatting Cells arrow_forward_ios ✓ Learn all about formatting text in Excel.
8 Understanding Number Formats arrow_forward_ios ✓ Learn all about formatting numbers in Excel.
9 Working with Multiple Worksheets arrow_forward_ios ✓ Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
10 Using Find & Replace arrow_forward_ios ✓ Learn how to use Excel's Find and Replace features to search for specific data.
11 Checking Spelling arrow_forward_ios ✓ Learn how to use Excel's spell check feature.
12 Page Layout and Printing arrow_forward_ios ✓ Learn how to use Excel commands that let you control the way your content will appear on a printed page.

13 Intro to Formulas arrow_forward_ios ✓ Learn how to use cell references to create a simple formula in Excel.
14 Creating More Complex Formulas arrow_forward_ios ✓ Learn how to create a complex formula in Excel.
15 Relative and Absolute Cell References arrow_forward_ios ✓ Learn all about absolute and relative cell references and how they're used in Excel.
16 Functions arrow_forward_ios ✓ Learn the different parts of a function and how to create arguments to calculate values and cell references.

17 Basic Tips for Working with Data arrow_forward_ios ✓ Learn these basic tips for working with data to help you organize it and find what you need.
18 Freezing Panes and View Options arrow_forward_ios ✓ Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
19 Sorting Data arrow_forward_ios ✓ Learn how to sort data to better view and organize the contents of your spreadsheet.
20 Filtering Data arrow_forward_ios ✓ Learn how to filter the data in your worksheet to display only the information you need.
21 Groups and Subtotals arrow_forward_ios ✓ Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
22 Tables arrow_forward_ios ✓ Learn how to use styles to format tables in Excel.
23 Charts arrow_forward_ios ✓ Learn how to insert and modify Excel charts to visualize comparisons in your data.
24 Conditional Formatting arrow_forward_ios ✓ Learn how to apply, modify, and delete conditional formatting rules in Excel.

25 Track Changes and Comments arrow_forward_ios ✓ Learn how to use Excel's track changes and comments features when proofreading workbooks.
26 Inspecting and Protecting Workbooks arrow_forward_ios ✓ Learn how to inspect and protect your Excel workbook.
27 Intro to PivotTables arrow_forward_ios ✓ Learn how to use PivotTables in Excel for stronger data analysis.
28 Doing More with PivotTables arrow_forward_ios ✓ Learn how to do more with PivotTables in Excel to better summarize data.
29 What-if Analysis arrow_forward_ios ✓ Learn how to use what-if analysis to answer different types of questions.

30 Buying Office 2016 arrow_forward_ios ✓ If you're considering purchasing Office 2016, learn about some important changes you should know about.
31 New Features in Office 2016 arrow_forward_ios ✓ Discover some of the new features in Office 2016.
32 What are Reference Styles? arrow_forward_ios ✓ Learn all about using reference styles in Excel.
33 More Resources arrow_forward_ios ✓ These free resources can help you better work with and manipulate data in Excel.

34 Excel Quiz arrow_forward_ios ✓ Test your knowledge of Excel by taking our quiz.