Microsoft Excel 2013

Microsoft Excel 2013

Released December 2012
Publisher(s): Infinite Skills
ISBN: 9781771370530

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

In this Microsoft Excel 2013 training course, veteran trainer Guy Vaccaro takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but Guy breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel or spreadsheets is required to get the most out of this Excel beginners video training.
You will start with the absolute basics, creating and saving a new workbook. Guy proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet.
By the time you have completed this video training course for Microsoft Excel 2013, you will be comfortable with day to day operations that you would perform in this software program. You will be able to perform calculations, and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material that the author uses throughout the lessons in this computer based training video.

Table of contents

  1. Start Here
    1. Getting Started With Excel 2013
    2. The Excel Workbook Explained
    3. Signing Up For Your Own Free SkyDrive
    4. Customize The Quick Access Toolbar
    5. Using The Included Working Files
    6. About The Author
  2. Managing Excel Workbooks And Worksheets
    1. Creating And Saving A New Workbook
    2. Opening Workbooks And Save As Options
    3. Saving And Opening SkyDrive Files
    4. Navigating An Excel Workbook
    5. Adding And Removing Worksheets
    6. Renaming Copying And Moving Worksheets
  3. Entering And Editing Data In Cells
    1. Entering Text, Numbers, And Dates
    2. Entering Numbers As Text
    3. Editing The Contents Of A Cell
    4. Undo And Redo Actions
    5. Cut, Copy, And Paste
    6. Dragging And Dropping Cells
    7. The Fill Handle
    8. Inserting And Deleting Cells Columns And Rows
    9. Changing Column Widths And Row Heights
    10. Hiding And Un-Hiding Columns And Rows
    11. Searching For Values In A Workbook
  4. Math Basics
    1. Getting Started With Basic Math Formulas
    2. Order Of Operation With BODMAS
    3. Introduction To Basic Formulas
    4. Copying Formulas And Functions - Chapter 4
    5. Displaying Formulas On A Worksheet
  5. Formatting Worksheets
    1. Selecting Cells For Formatting
    2. Modifying Typeface Font, Size, And Colour
    3. Merging And Wrapping Cell Contents
    4. Using Number Formats
    5. Cell Content Alignment And Orientation
    6. Adding And Removing Borders From A Selection
    7. Applying A Date Format To A Cell Or Range
    8. The Format Painter
    9. Finding And Replacing Formats
    10. Clearing Cell Contents Vs. Clearing Cell Formatting
  6. Workbook And Worksheet Management
    1. Worksheet Navigation And Coloured Worksheet Tabs
    2. Moving Or Copying Worksheets Within And Between Workbooks
    3. Viewing And Scrolling Multiple Workbooks At The Same Time
    4. Hiding And Un-Hiding Sheets
    5. Modifying More Than One Worksheet At A Time
  7. Page Setup And Printing
    1. Using Print Titles And Print Areas
    2. Paper Size, Orientation, Margins, And Scaling Options
    3. Creating Headers and Footers
    4. Using The Page Break And The Page Layout Views
    5. Printing A Range Of Cells
    6. Running The Spell Checker
    7. Controlling Most Print Settings In One Place
  8. Mathematical Formulas
    1. The Sum Function
    2. Copying Formulas And Functions - Chapter 8
    3. Other Mathematical Functions: Average, Min, And Max
    4. Useful Count Functions
    5. Absolute Referencing Explained
    6. Formulas Across Worksheets
    7. 3D Referencing
    8. Making Use Of Named Cells And Ranges
  9. Advanced Formatting
    1. Enhancing Worksheets Using Themes
    2. Adding, Editing, And Deleting Comments
    3. Creating Your Own Autofill List
    4. Converting Data To A Table For Formatting
  10. Security
    1. Activating And Deactivating Worksheet Protection
    2. Protecting Part Of A Worksheet To Aid Data Entry
    3. Password Protecting The Whole Workbook
  11. Excel 2013 Templates
    1. Using The 2013 Templates
    2. Creating And Using Your Own Template
  12. Graphics Objects
    1. Obtaining And Inserting Online Images
    2. Using SmartArt Graphics
    3. Inserting Shapes And Screenshots
    4. Formatting Graphical Objects
    5. The Stacking Order
    6. Grouping Multiple Objects Together
    7. Using Graphical Objects And Mathematical Formulas
  13. Using Charts In Excel
    1. The New Recommended Charts Option
    2. Create A Chart Using The Long Or The Short Method
    3. Formatting A Chart With The 2013 Shortcut Options
    4. Modifying The Chart Type
    5. Formatting Chart Elements
    6. Adding A Trendline
    7. The Pie Chart In Detail
    8. Mini Graphs: Sparklines
  14. Excel As A Database
    1. Fixing On Screen Rows And Columns
    2. Fixing Print Rows And Columns
    3. Sorting Data In Excel
    4. Filtering Data To Reduce Dataset Size
    5. Removing Duplicate Entries In The Data
    6. Adding Subtotals To A Worksheet Of Data
    7. Using Text To Columns Effectively
    8. Linking To Data On A Webpage
  15. Advanced Formulas
    1. Using An If Formula
    2. Use Of The If Function To Hide Excel Error Messages
    3. Datedif: A Useful But Hidden Formula
    4. Text Manipulation Using Functions
    5. Use The Text Function To Format Numbers
    6. Date Manipulation Functions
    7. Introducing Sumif, Countif, And Averageif
    8. Use Of Rank To Calculate Placings
    9. Flash Fill: The Magic Touch
  16. Conditional Formatting
    1. Altering Cell Appearance Based On The Cell Value
    2. Displaying Data Bars, Color Scales, Or Icon Sets
    3. Using Top And Bottom Rules For Formatting
    4. Creating A Formatting Rule From Scratch
    5. Managing The Conditional Formatting Rules
  17. What's Next
    1. The New Office Apps For Excel 2013
    2. Ready To Go Advanced

Product information

  • Title: Microsoft Excel 2013
  • Author(s):
  • Release date: December 2012
  • Publisher(s): Infinite Skills
  • ISBN: 9781771370530