|
|
Title |
Duration |
|
|
|
Installing Office 2011 for Mac
As with any new application suite, it's always good to review the installation. With Office 2011 there are a few gotchas and things to watch out for, however the most important thing will be how you customize the installation if necessary.
|
00:17:22 |
|
|
|
Workspace Fundamentals
There are definitely some differences between Excel 2011 and Excel 2008. The biggest difference is the addition of the Office Ribbon which has been in the PC version since Office 2007. But Excel 2011 for Mac has a few extras that the PC version doesn't have and we believe harnesses the best of both worlds! Check out the palette you've been given to paint your spreadsheets upon!
|
00:28:32 |
|
|
|
Data and Content Fundamentals
When you look at the screen after opening Excel 2010, you'll notice that it's blank. Nothing there. You need to fill in the worksheets with data and content, but what does Excel handle when it comes to content? We'll see how Text, Numbers, Symbols, and even Graphics can be manipulated, calculated, and just plain discombobulated in Excel 2011.
|
00:24:58 |
|
|
|
Data and Content - Cells
Once you get some numbers or text into a cell, what else can you do? In this Nugget we see how we can change the look and feel with different fonts, adding borders to the cells, aligning the text to the top, bottom, left, or right, and finally looking at "quick styles."
|
00:29:17 |
|
|
|
Data and Content - Cells Advanced
For you advanced users and Mac experts, there are a few things Microsoft expects you to know and understand when it comes to cell formatting. We'll look at how to merge cells and their content together, use format painter, advanced styles, and even put some hyperlinks into play.
|
00:25:24 |
|
|
|
Data and Content - Rows, Columns, Worksheets
There's more to Excel than just cells. You have rows, columns, even multiple worksheets that can be formatted and manipulated. We look at how we re-size our rows and columns, insert and delete, freeze, and even hide rows and columns. We'll also take a look at worksheet behaviors and formatting.
|
00:22:12 |
|
|
|
Printing and Page Setup
Most people look at Excel on their monitors or laptops, however, there are occasions when you are going to want to print out a report on that spreadsheet or perhaps show everyone the charts that are produced by your data. Excel 2011 has upped the ease of use when it comes to printing and you'll find out how and why in this Nugget.
|
00:24:57 |
|
|
|
Database Functionality
While you can use a SQL database, Oracle, or some other database program, Excel 2011 has many of the functions that are performed by databases and you can just as easily sort, filter, hunt for duplicates, and other database features. We'll also look at functions that produce different results and look at creating new datasets.
|
00:37:33 |
|
|
|
Charts and Graphics
Images can really help people understand the information that is in front of them on their Excel Spreadsheets. The impact a chart or graph brings to the table is huge! Check out this Nugget for some great ways to bring your data to life.
|
00:27:19 |
|
|
|
PivotTables
It's always hard when you have large amounts of data or many different categories to understand what it is you are looking at. One of the most misunderstood and underutilized tools in Excel, PivotTables are a great way to design a table that showcases data the way YOU want it to appear.
|
00:28:00 |
|
|
|
Charts and Graphs - Advanced
Not only can you put in histograms, pie charts, and Venn diagrams into Excel 2011, but now there are ways for you to put a small graphic WITHIN a cell to showcase trends (Sparklines) and a way to project future results (Trendlines).
|
00:20:57 |
|
|
|
Introduction to Functions and Formulas
You can have a lot of data, especially numbers, all over the place. What if you want to add them up, average them out, count how many cells are filled? That's where the calculating side of Excel comes into play as we look at basic formulas and functions.
|
00:28:57 |
|
|
|
Advanced Functions and Formulas
As your formulas become more complex, your references, data, and dependencies become more involved. In this Nugget, we show you the difference between Absolute and Relative references, showcase Conditional Formatting, and get you ready overall for the more advanced functions.
|
00:29:32 |
|
|
|
Conditional Formulas
Many people never took logic as a class in high school or college, but logic is important when it comes to conditional formulas. We'll look at "if," "and," "or" statements to help create situational and logical functions. You'll also have the ability to do VLOOKUP and calculate a payment for your new house!
|
00:34:11 |
|
|
|
Data Summarization
Organizing your data can be tough sometimes, but Excel 2011 is all about helping you make sense of the information on the screen. With the help of Subtotals and Outlines, users can more clearly see what it happening on their page.
|
00:29:30 |
|
|
|
What If Analysis
There are many times you would like to see if when results change on your spreadsheet, there are different scenarios or perhaps changed data. With Goal Seek, Data Tables, and Scenario manager, you can perform these "pretend" situations on your data without harming the original data!
|
00:41:35 |
|
|
|
Secure Collaboration
Sometimes you don't want people messing with your numbers, changing your Excel Workbooks, or even allowing them access to the files. With encryption, you can password protect your files. We all need help sometimes on our spreadsheets, and Excel 2011, along with the rest of the Office 2011 series, makes it easy for users to interact with each others work. Whether it's just putting a few comments on the worksheet or actually tracking changes on a shared file, Excel 2011 has you covered.
|
00:30:50 |
|
|
|
Advanced Customization
Excel 2011 added the Ribbon, and while it isn't as customizable as the Windows version, it's still pretty flexible. Plus, with Excel 2011 you have incredible control over the toolbars you set up. You'll also take a look at how to validate data before it's inserted into a cell, and we'll wrap up the series with a look at using Visual Basic and Macros!
|
00:33:32 |
