Tutor for Microsoft Excel

Tutor for Microsoft Excel

Regular price
Sale price

Learn how to use Microsoft Excel with our tutorial Tutor for Microsoft Excel. This tutorial covers the Mac version of Excel and includes 49 easy-to-follow video lessons. We start out by looking at the interface to Excel and how to create documents and save a document as a template. From there we look at working with Workbooks and worksheets including how we can add headers a footers to a workbook, add security, and freeze panes in a worksheet. We then take a look at working with cells including selecting and formatting cells, adding and deleting cells, autofilling cells, and merging multiple cells into a single cell. From there we look at how we work with rows and columns including inserting and deleting rows and columns, sorting and filtering columns, and grouping rows and columns. We also look at inserting tables, charts, pictures, and SmartArt into a worksheet. From there we look at working with data including validating data, highlighting duplicates, and creating data connections. We also look at our review options including adding comments and trading changes in Excel. From here we look at our different printing and sharing options as well as looking at Excel shortcuts.

If you need to learn Excel for the Mac – our tutorial is for you!

Lessons include:

  • Introduction to Microsoft Excel
    • Interface Overview
    • Managing Windows and Full Screen Mode
  • Working with Workbooks and Worksheets
    • Creating Workbooks and Templates
    • Page Layout, Themes, and View Options
    • Adding Headers and Footers
    • Adding Security to a Workbook
    • Working with Worksheets
    • Splitting and Freezing Panes in a Worksheet
  • Working with Cells
    • Adding Text and Formulas to Cells
    • Selecting, Styling, and Formatting Cells
    • Adding Borders and Fills to Cells
    • Using the Format Painter
    • Adding Conditional Formatting to Cells
    • Clearing and Autofilling Cells
    • Merging Multiple Cells into One Cell
    • Moving, Inserting, and Deleting Cells
  • Working with Rows and Columns
    • Moving and Resizing Rows and Columns
    • Adding and Hiding Rows and Columns
    • Sorting and Filtering Columns
    • Grouping Rows and Columns
  • Tables, Pictures, Shapes, and Charts
    • Creating and Formatting Tables
    • Working with PivotTables
    • Working with Pictures
    • Working with Text Boxes and Shapes
    • Working with SmartArt
    • Working with Charts
  • Working with Data
    • Creating Data Connections
    • Converting Text to Columns
    • Highlighting and Removing Duplicates
    • Validating Data
    • Consolidating Data
  • Review Options
    • Checking Spelling
    • Adding Comments to Cells
    • Tracking and Reviewing Changes
  • Printing and Sharing Options
    • Printing Options
    • Sharing Documents
    • Exporting Documents
  • Excel Shortcuts and Preferences
    • Cut, Copy, and Paste Options
    • Undo and Redo Changes
    • Excel Preferences

Please note: This tutorial is 949MB as the videos are enclosed in the tutorial. I recommend you download it from a wi-fi network. Also, depending on your network speed, it may take a while to download. When you purchase the tutorial, you will be sent a link from where you can download the tutorial. You can always download the tutorial at a later time if you are on a slower network. Once you download the tutorial, you will no longer need a network connection to view the videos.