2015
Lynda
Curt Frye
6h 20m
English
Learn everything you need to master the world's most popular spreadsheet program—now accessible from anywhere with an Office 365 subscription. Curt Frye provides a comprehensive overview of Excel for Mac, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks.
Introduction
1m 29s
Welcome
55s
Using the exercise files
34s
1. Getting Started with Excel
18m 22s
What you can do with Excel 2016
2m 37s
Exploring the Excel 2016 program window
4m 39s
Introducing the Ribbon for the Mac
3m 46s
Setting program preferences
4m 9s
Getting help in Excel
3m 11s
2. Managing Workbooks
12m 54s
Opening, creating, and saving workbooks
3m 18s
Setting workbook properties
2m 45s
Creating and modifying workbook templates
3m 47s
Managing workbooks across multiple versions of Excel
3m 4s
3. Working with Worksheets, Cells, and Cell Data
44m 26s
Selecting cells and groups of cells
3m 58s
Copying and pasting cell data
3m 50s
Entering data using AutoFill and other techniques
4m 7s
Inserting symbols and special characters
4m 57s
Creating named ranges
5m 58s
Creating an Excel table
5m 9s
Locating and changing data using Find and Replace
5m 54s
Restricting input using validation rules
7m 25s
Using lists to limit data entered into a cell
3m 8s
4. Sorting, Filtering, and Managing Worksheets
29m 4s
Sorting worksheet data
3m 6s
Creating a custom sort order
4m 49s
Filtering worksheet data
3m 55s
Inserting, moving, and deleting cells and cell ranges
4m 22s
Splitting and freezing rows and columns
4m 28s
Managing worksheets
5m 4s
Creating, editing, and deleting headers and footers
3m 20s
5. Summarizing Data Using Formulas and Functions
42m 32s
Introducing Excel formulas and functions
3m 12s
Adding a formula to a cell
3m 56s
Introducing arithmetic operators
4m 30s
Using relative and absolute cell references
5m 47s
Controlling how Excel copies and pastes formulas
4m 42s
Referring to Excel table data in formulas
3m 5s
Creating an AUTOSUM formula
4m 1s
Summarizing data on the status bar
2m 19s
Summarizing data using an IF function
4m 54s
Summarizing data using SUMIF and other conditional functions
6m 6s
6. Analyzing Data and Formulas
31m 53s
Creating formulas to count cells
2m 43s
Rounding cell values
4m 14s
Joining text in cells with concatenation
3m 45s
Finding data using VLOOKUP and HLOOKUP
3m 38s
Auditing formulas by identifying precedents and dependents
3m 4s
Managing Excel formula error indicators
4m 27s
Managing scenarios
7m 1s
Performing Goal Seek analysis
3m 1s
7. Formatting Worksheet Elements
48m 13s
Applying fonts, background colors, and borders
4m 50s
Applying number and date formats to cells
5m 30s
Managing text alignment
4m 46s
Copying cell formats
3m 29s
Managing cell styles
4m 10s
Managing Office themes
5m 45s
Creating rule-based conditional formats
4m 33s
Defining top 10 conditional formats
4m 47s
Defining data bar, color scale, and icon set conditional formats
6m 22s
Editing, ordering, and deleting conditional formats
4m 1s
8. Working with Charts
32m 29s
Creating bar and column charts
5m 8s
Creating pie charts
2m 25s
Creating line charts
3m 11s
Creating XY (scatter) charts
2m 38s
Creating stock charts
2m 42s
Changing chart types and layouts
2m 29s
Changing the appearance of chart elements
3m 16s
Managing chart axes and numbering
2m 52s
Adding trendlines to charts
3m 31s
Creating sparkline charts
4m 17s
9. Working with External Data
15m 15s
Importing data from comma-separated value (CSV) or text files
3m 53s
Connecting to an external data source
1m 28s
Using hyperlinks
4m 18s
Including an Excel workbook in another Office document
3m 13s
Linking to an Excel chart from another Office program
2m 23s
10. Working with Objects
30m 53s
Creating and formatting shapes
5m 40s
Adding and adjusting images
4m 58s
Manipulating text boxes
3m 20s
Cropping, compressing, and removing image backgrounds
5m 9s
Creating SmartArt graphics
4m 19s
Creating WordArt
2m 55s
Aligning and layering objects
4m 32s
11. Exploring PivotTables
29m 14s
Introducing PivotTable reports
2m 41s
Creating a PivotTable report
3m 3s
Pivoting a PivotTable report
3m 9s
Managing subtotals and grand totals
2m 59s
Summarizing more than one data field
1m 58s
Changing the data field summary operation
4m 51s
Changing the data field number format
1m 58s
Filtering a PivotTable report
6m 9s
Applying a PivotTable style
2m 26s
12. Reviewing and Sharing Your Spreadsheets
26m 55s
Checking spelling
2m 55s
Setting AutoCorrect and automatic Replace options
4m 31s
Managing workbook comments
3m 29s
Tracking and reviewing changes
4m 23s
Printing a worksheet or workbook
2m 48s
Setting and removing print areas
2m 38s
Exporting to other formats
2m 48s
Protecting a workbook
3m 23s
13. Automating Workbooks Using Macros
15m 41s
Running an existing macro
4m 31s
Recording a macro
2m 46s
Renaming, viewing, and deleting macros
2m 40s
Adding comments to a macro
2m 23s
Turning off screen updating in a macro
3m 21s
Conclusion
1m 13s
Next steps
1m 13s
Download File Size:865.15 MB
|
