Scribd
Upload
14 views2 pages

Learning Roadmap For Excel 2011

The document outlines a learning roadmap for Excel 2011 with topics organized into sections covering Excel basics, working with sheets and data, formulas and functions, charts and graphics, data analysis and sharing, and additional resources. The roadmap provides video and text tutorials on essential skills to become productive using Excel.

Uploaded by

amokeade4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views2 pages

Learning Roadmap For Excel 2011

The document outlines a learning roadmap for Excel 2011 with topics organized into sections covering Excel basics, working with sheets and data, formulas and functions, charts and graphics, data analysis and sharing, and additional resources. The roadmap provides video and text tutorials on essential skills to become productive using Excel.

Uploaded by

amokeade4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Learning roadmap for Excel 2011

Follow this roadmap of training and Help topics to learn how to use Microsoft Excel for
Mac 2011 in a systematic, step-by-step approach.
1. Become familiar with Excel
Title Description
Video: Excel basics Whether you’re brand new to Excel for Mac 2011 or need a refresher, this
video provides an overview of essential concepts to help you become
productive quickly.
Tutorial: Excel This step-by-step tutorial covers the same concepts as in the Excel basics
basics video, only using text and images.
Video: Up to speed Get familiar with the Microsoft Office for Mac 2011 ribbon, which combines
with the Office the Formatting Palette and Elements Gallery from previous versions of
ribbon Office, giving you quick and convenient access to the features and tools
that you use the most.
Start with a Learn how to find templates for budgets, lists, reports and more by using
template to create a the Excel Workbook Gallery.
new document

2. Work with sheets and data


Title Description
Insert or delete cells, rows, Work with cells, rows, and columns.
columns, or sheets
Copy and paste specific cell Use the Paste Special command to copy and paste special cell
contents contents or attributes.
Freeze column headings for easy Keep column headings visible while you scroll.
scrolling
Adjust the column size to see Change the width of columns so that you can see all the data
everything in cells.
Show or hide sheets Display only those sheets that you want to appear in your
workbook.
Protect a sheet Prevent unauthorized changes, moves, or deletions of
important data.
Highlight patterns and trends Change the appearance of cells based on certain criteria, for
with conditional formatting example, all cell values in the top 10% of a range.

3. Work with functions, formulas, and lists


Title Description
Enter a formula Learn the elements of a formula as well as how to enter a
formula on a sheet.
Tutorial: Get started with Create and use simple formulas and functions to do basic
formulas and functions mathematical calculations.
Calculation operators and Learn about the different kinds of operators (for example, +, -,
order of operations /, and *) and the order in which they are applied.
Switch between relative and Learn the difference between relative and absolute cell
absolute references references and how to switch between them.
Have Excel complete your lists Automatically complete common lists, such as the months of the
year or the days of the week.
Tutorial: Sort and filter lists Arrange a list alphabetically or numerically, and filter a list to
show specific items.
Video: Manage your data with Use Excel Tables to quickly sort, filter, and format worksheet
Excel Tables data.
4. Work with charts and graphics
Title Description
Create a chart Learn the basics of charts, including the elements of a chart, which
chart is appropriate for your data, and how to apply chart layouts and
styles.
Edit data in a chart Add chart and axis titles, change the axis scale, add data labels, and
more.
Add error bars or Use error bars to indicate potential error amounts in relation to each
up/down bars to a chart data point.
Video: Spot trends with Watch this short overview on how to use sparklines, which are small
sparklines charts inside of cells, to reveal data trends.
Add or replace a picture Add pictures or clip art to a worksheet by using the Media Browser.

5. Analyze, share, and collaborate


Title Description
Video: Summarize your Watch this short overview on how to use Pivot Tables to quickly
data with Pivot Tables summarize and analyze large amounts of data.
Create a PivotTable Learn the two different ways to create a Pivot Table and how to use
the Pivot Table Builder to add, move, and arrange fields.
Predict data trends Create a projection based on an existing series of data.
Video: Access your Watch this short overview on how to open and edit workbooks that
workbooks anywhere are saved on Windows Live SkyDrive directly from Excel for Mac
2011.
Save a document to Use Excel for Mac 2011 to check out a SharePoint file so that only
SharePoint or SkyDrive you can make changes.

6. Explore other useful resources


Title Description
Interactive: Can’t find it in Office Use this visual, interactive guide to find where Excel 2008
for Mac 2011? commands are located in Excel 2011
Excel keyboard shortcuts See the full list of keyboard shortcuts, organized into logical
categories.
Customize the ribbon Rearrange, show, and hide tabs on the ribbon.
Known issues in Excel 2011 See a list of known issues as well as potential workarounds.

You might also like