Microsoft Excel 2013: Essentials

Microsoft Excel 2013: Essentials

by Wiley
Released May 2014
Publisher(s): Wiley
ISBN: 9781118792889

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Master Excel 2013 on your terms with this one-of-a-kind video training course Microsoft Excel 2013 is the industry leading spreadsheet application that allows you to organize, visualize and calculate your data. Our instructors provide expert, straight-forward, user-friendly training to help you tackle Excel 2013 the way you want to learn. Get to know the Excel 2013 window and terminology Create, edit, and manage cells, worksheets, and workbooks Apply styles and themes to worksheets and adjust cell formatting with various fonts, colors, and borders Work with formulas and functions to analyze data then present that data in a PivotTable, chart, or graph Includes 8-1/2 hours of Excel 2013 video training. If youre looking for comprehensive beginning-intermediate video instruction on Excel 2013, youll find it here.

Table of contents

  1. Part 1 - Getting Familiar with Excel 2013
    1. Opening Excel 2013 in Windows 8 00:03:06
    2. Exploring the Excel 2013 Window and Excel Terminology 00:07:04
    3. Working with Backstage View in Excel 2013 00:03:45
    4. Entering Information, Moving Around, and Selecting Commands in Excel 2013 00:13:16
  2. Part 2 - Managing Workbooks
    1. Saving a Workbook to Your Computer in Excel 2013 00:09:51
    2. Reopening a Workbook in Excel 2013 00:04:16
    3. Starting a New Workbook, Switching Between Open Workbooks, and Closing a Workbook in Excel 2013 00:05:40
    4. Importing a Text File into Excel 2013 00:06:49
    5. Setting Options for Saving Excel 2013 Workbooks 00:04:15
  3. Part 3 - Editing Cells and Workbooks
    1. Selecting Cells in Excel 2013 00:04:31
    2. Moving or Copying Information in Excel 2013 00:05:33
    3. Changing Fonts or Font Size and Applying Effects in Excel 2013 00:06:21
    4. Fitting Text within Cells in Excel 2013 00:04:12
    5. Understanding and Assigning Number Formatting in Excel 2013 00:03:48
    6. Using Cell Colors and Borders in Excel 2013 00:05:44
    7. Indenting and Aligning Text in Excel 2013 00:07:19
    8. Copying and Clearing Formatting in Excel 2013 00:02:32
  4. Part 4 - Adjusting Worksheets and Workbooks
    1. Adding, Deleting, Hiding, and Unhiding Rows and Columns in Excel 2013 00:09:32
    2. Swapping Rows and Columns in Excel 2013 00:02:53
    3. Adjusting Row Height and Column Width in Excel 2013 00:07:09
    4. Working with Worksheets in an Excel 2013 Workbook 00:08:25
  5. Part 5 - Applying Styles and Themes, Proofing Worksheets, and Managing On-Screen Elements
    1. Working with Styles and Applying a Theme in Excel 2013 00:03:21
    2. Finding and Replacing Text in Excel 2013 00:02:17
    3. Checking Spelling, Using the Thesaurus, and Translating Text in Excel 2013 00:05:13
    4. Switching Views and Zooming in Excel 2013 00:05:04
    5. Hiding or Displaying Gridlines, Row Numbers and Column Letters, and the Formula Bar in Excel 2013 00:03:13
    6. Freezing Column and Row Titles in Excel 00:04:56
  6. Part 6 - Printing Worksheet Information
    1. Setting Margins, Page Orientation, Paper Size and Scaling in Excel 2013 00:09:10
    2. Adding Headers and Footers to a Worksheet in Excel 2013 00:04:46
    3. Setting a Print Area and Working with Page Breaks in Excel 2013 00:06:44
    4. Printing Gridlines, Row Numbers and Column Letters, Row and Column Titles, Formulas in Cells and Previewing and Printing in Excel 2013 00:10:47
  7. Part 7 - The Basics of Math in Excel 2013
    1. Filling a Range with Information in Excel 2013 00:03:44
    2. Creating Formulas in Excel 2013 00:11:35
    3. Working with Absolute and Relative Cell References and Copying a Formula in Excel 2013 00:07:08
    4. Changing a Formula to a Value in Excel 2013 00:02:05
    5. Adding Data Across Ranges and Worksheets in Excel 2013 00:05:58
    6. Using Cell Names and Ranges Name in Excel 2013 00:08:23
    7. Analyzing Data using Conditional Formatting in Excel 2013 00:09:37
    8. Working with Tables in Excel 2013 00:19:03
  8. Part 8 - Working with Functions in Excel 2013
    1. Summing, Subtotaling, Calculating a Running Balance, Calculating a Conditional Sum and Rounding Values in Excel 2013 00:14:39
    2. Working with Frequency Functions in Excel 2013 00:08:00
    3. Working with Dates in Excel 2013 00:05:10
    4. Working with Financial Functions in Excel 2013 00:12:27
    5. Using Text Functions in Excel 2013 00:17:04
    6. Working with Database Functions in Excel 2013 00:11:49
    7. Analyzing Formulas and Functions in Excel 2013 00:16:26
  9. Part 9 - Graphics and Charting in Excel 2013
    1. Working with Graphic Elements in Excel 2013 00:12:52
    2. Creating and Moving a Chart in Excel 2013 00:11:23
    3. Making Changes to a Chart in Excel 2013 00:08:01
    4. Working with Chart Elements in Excel 2013 00:17:04
    5. Setting Chart Element Shape Style Attributes 00:07:11
    6. Working with Sparkline Charts in Excel 2013 00:05:38
  10. Part 10 - Summarizing Data with PivotTables and Pivot Charts in Excel 2013
    1. Creating a PivotTable and Filtering and Sorting PivotTable Information in Excel 2013 00:16:01
    2. Adjusting the Appearance of a PivotTable in Excel 2013 00:08:05
    3. Changing Values and Data in a PivotTable in Excel 2013 00:05:01
    4. Working with a PivotChart in Excel 2013 00:02:07
  11. Part 11 - Linking and Consolidating in Excel 2013
    1. Linking Workbooks in Excel 2013 00:10:02
    2. Consolidating Data in Excel 2013 00:08:03
  12. Part 12 - Performing What-If Analysis in Excel 2013
    1. Creating and Switching Scenarios in Excel 2013 00:05:56
    2. Merging Scenarios 00:02:39
    3. Reporting on Scenarios in Excel 2013 00:05:02
    4. Examining What-If Examples in Excel 2013 00:11:27
  13. Part 13 - Using Workbooks in a Multi-User Environment
    1. Marking a Workbook as Final, Assign a Password, Encrypting and Protecting Workbooks in Excel 2013 00:12:20
    2. Working with Comments in Excel 2013 00:05:16
    3. Change Tracking in Excel 2013 00:09:40
  14. Part 14 - Customizing Excel 2013
    1. Customizing the Status Bar and Hiding or Displaying Ribbon Buttons in Excel 2013 00:03:06
    2. Customizing the Ribbon in Excel 2013 00:10:28
    3. Customizing the Quick Access Toolbar in Excel 2013 00:03:58
    4. Working with Macros in Excel 2013 00:06:27
  15. Part 15 - Excel 2013 and the World Beyond Your Desktop
    1. Creating a Hyperlink and Emailing a Workbook in Excel 2013 00:06:27
    2. Signing in to Office Online, Opening a Workbook in the Cloud, and Saving a Workbook to the Cloud in Excel 2013 00:06:40
    3. Using SkyDrive to Share an Excel 2013 Workbook 00:02:52
    4. Using the Excel 2013 Web App in SkyDrive 00:03:46
    5. Download Excel 2013 Apps from the Office Store 00:05:16

Product information

  • Title: Microsoft Excel 2013: Essentials
  • Author(s): Wiley
  • Release date: May 2014
  • Publisher(s): Wiley
  • ISBN: 9781118792889