Lynda.COM Excel for Mac 2011 Essential Training

Author:
Curt Frye

Duration:
06h 32m

Released on:
10/26/2010

Exercise files:
Yes

Software works on:
Mac only


In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
Topics include:

    Customizing the Ribbon
    Formatting worksheets, cells, and cell data
    Sorting and filtering data
    Working with formulas
    Detecting formula errors
    Creating charts
    Importing data
    Inserting objects and graphics
    Using PivotTables
    Recording macros
    Sharing workbooks




Introduction
Welcome           01m 16s
Using the exercise files           00m 42s

1. Getting Started with Excel
Exploring the Excel 2011 window           04m 16s
Introducing the Ribbon for Mac           04m 44s
Customizing the Ribbon           04m 20s
Setting program preferences           03m 20s
Getting help in Excel           04m 16s

2. Managing Workbooks
Opening, creating, and saving workbooks           05m 23s
Setting workbook properties           04m 14s
Creating and modifying workbook templates           04m 18s
Managing workbooks across multiple versions of Excel           06m 09s

3. Managing Worksheets, Cells, and Cell Data
Selecting cells and groups of cells           04m 58s
Copying and pasting cell data           02m 39s
Entering data using AutoFill and other techniques           04m 32s
Inserting symbols and special characters           05m 03s
Creating an Excel table           04m 43s
Locating and changing data using Find and Replace           04m 57s
Restricting input using validation rules           04m 42s
Using lists to limit data entered into a cell           02m 32s
Sorting worksheet data           03m 02s
Creating a custom sort order           03m 54s
Filtering worksheet data           04m 06s
Inserting, moving, and deleting cells and cell ranges           03m 50s
Splitting and freezing rows and columns           03m 51s
Managing worksheets           05m 28s
Creating, editing, and deleting headers and footers           04m 41s

4. Summarizing Data Using Formulas and Functions
Introducing Excel formulas and functions           03m 17s
Adding a formula to a cell           04m 00s
Introducing arithmetic operators           04m 13s
Using absolute and relative cell references           06m 29s
Controlling how Excel copies and pastes formulas           06m 05s
Referring to Excel table data in formulas           02m 03s
Creating an AutoSum formula           03m 22s
Summarizing data on the status bar           02m 22s
Joining text in cells with concatenation           03m 59s
Summarizing data using an IF function           06m 21s
Summarizing data using SUMIF and other conditional functions           05m 41s
Creating formulas to count cells           02m 37s
Rounding cell values up and down           04m 55s
Finding data using VLOOKUP and HLOOKUP           06m 33s
Auditing formulas by identifying precedents and dependents           03m 25s
Managing Excel formula error indicators           04m 42s
Managing scenarios           04m 59s
Performing Goal Seek analysis           02m 31s

5. Formatting Worksheet Elements
Applying fonts, background colors, and borders           06m 07s
Applying number and date formats to cells           07m 01s
Managing text alignment           03m 56s
Copying cell formats           04m 02s
Managing cell styles           03m 16s
Managing Office themes           03m 31s
Creating rule-based conditional formats           03m 54s
Defining Top 10 conditional formats           04m 19s
Defining data bar, color scale, and icon set conditional formats           06m 06s
Editing, ordering, and deleting conditional formats           03m 36s

6. Working with Charts
Creating bar and column charts           05m 26s
Creating pie charts           02m 32s
Creating line charts           04m 34s
Creating XY (scatter) charts           01m 49s
Creating stock charts           04m 11s
Changing chart types and layouts           02m 22s
Changing the appearance of a chart           04m 25s
Managing chart axes and numbering           02m 51s
Adding trendlines to charts           04m 14s
Creating sparkline charts           04m 31s

7. Working with External Data
Importing data from comma separated value (CSV) or text files           04m 20s
Connecting to an external data source           02m 22s
Using hyperlinks           06m 01s
Including an Excel workbook in another Office document           03m 05s
Linking to an Excel chart from another Office program           02m 51s

8. Working with Objects
Creating and formatting shapes           03m 10s
Adding and adjusting images           05m 38s
Cropping, compressing, and removing image backgrounds           04m 46s
Creating SmartArt graphics           05m 07s
Creating WordArt           02m 34s
Aligning and layering objects           05m 06s

9. Exploring PivotTable Reports
Introducing PivotTable reports           03m 47s
Creating a PivotTable report           04m 37s
Pivoting a PivotTable report           03m 18s
Managing subtotals and grand totals           03m 23s
Summarizing more than one data field           01m 34s
Changing the data field summary operation           02m 40s
Changing the data field number format           02m 27s
Filtering a PivotTable report           02m 46s
Applying a PivotTable style           02m 20s
Creating and editing styles           02m 59s

10. Reviewing and Sharing Your Spreadsheets
Checking spelling           03m 32s
Setting AutoCorrect and automatic Replace options           03m 59s
Managing workbook comments           03m 40s
Tracking and reviewing changes           05m 12s
Printing a worksheet or workbook           03m 44s
Setting and removing print areas           02m 31s
Exporting to other formats           01m 33s
Protecting a workbook           02m 36s

11. Automating Workbooks Using Macros
Running an existing macro           04m 56s
Recording a macro           03m 56s
Recording a macro using relative references           06m 15s
Renaming, viewing, and deleting macros           02m 58s
Adding comments to a macro           02m 43s
Turning off screen updating in a macro           03m 04s

Conclusion
Additional resources           01m 01s