Excel 2010 ▼ - mhelp4u.com

Office 2010 ▼‎ > ‎

Excel 2010 ▼

About Us l Contact Us l Forums l News Blog l Advertising l Press Room l

Getting Started

Introduction to the ribbon in Excel 2010 1.01

Getting started with Excel 2010 3.08

Get to work in Excel 2010 1.17

Work between new and old Excel versions 2.35

Check workbook for compatibility with earlier Excel versions 3.17

Enter and edit data in a worksheet 3.04

Create an Excel 2010 workbook from a template 2.35

Commands when you need them 2.29

Use the keyboard 2.17

Use the keyboard in Excel 2010 2.25

My add-ins are crashing 2.46

Message Bar

Turn on or off Message Bar security alerts 1.35

Working with the Enable Content button 3.06

File validation 1.36

Security decisions made easy 1.27

Macro security 3.22

ActiveX security, tips, and settings 4.06

Why use trusted documents? 3.21

Allowing macros and add-ins to run 2.40

Start Button

Create a digital certificate now 1.38

Quick Access Toolbar

Keep your favorite buttons visible 2.22

File - Backstage View

Backstage view in Excel 2010 2.36

Work with files in Backstage view 3.02

Find and fix accessibility issues in a workbook 2.42

Save & Save As

Save a workbook to a SharePoint site 2.07

Publish a workbook to a SharePoint site 6.59

Create an easily customizable template in Excel 2010 6.15

New

Create a workbook 0.48

Print

Printing in Excel 2010 3.01

Print a worksheet 2.45

Fit all columns on a single printed page 1.01

Options

Introduction to the Excel Options dialog box 3.07

What is the Trust Center? 3.44

Automatically save and recover Office files 3.26

Install and activate the Analysis ToolPak and Solver 2.27

Remove hyperlinks in Excel 1.40

Home

Do the basics on the Home tab 2.47

Format a worksheet 1.47

Paste with live preview 2.26

Number

Format numbers in a worksheet 0.53

Styles

Create an Excel table 1.09

Apply conditional formatting 3.17

Get even more out of conditional formatting 6.02

Introduction to conditional formatting 3.50

Cells

Protect worksheets and workbooks 6.59

Insert

Insert sparklines to show data trends 9.49

Add sparklines to a worksheet 3.12

Use shapes and SmartArt in a worksheet 7.50

Charts

Create a pie chart (or graph) 2.14

Combine two or more chart types in a chart 2.28

Pivot Tables

Using PowerPivot 3.05

Create a PivotTable report 2.28

Repeat item labels in a PivotTable report 1.29

Use the Show Values As feature in a PivotTable report 2.00

Use slicers to filter PivotTable data 2.41

Use the Show Values As feature in a PivotTable report 2.00

Use Named Sets in an OLAP PivotTable report 1.55

Repeat item labels in a PivotTable report 1.29

Group items in a PivotTable report 2.11

Use interactive controls in a PivotChart report 2.29

Use slicers to filter PivotTable data 2.41

Subtotal and total fields in a PivotTable report 1.33

Page Layout

No videos yet

Formulas

Enter a simple formula 2.47

Add and subtract numbers 2.01

Learn how to use the SUM function in Excel. 4.27

Fix broken formulas 6.51

Count cells in Excel 1.19

Use functions in formulas 6.15

Move and copy a formula 1.15

Add or subtract units of time 2.14

Calculate the difference between two times 4.33

Find and fix circular references 3.14

Combine the contents of multiple cells into one cell 4.27

Show and protect formulas 3.06

Calculate the difference between two dates 3.15

Convert numeric values to text 2.26

Introduction to VLOOKUP 3.48

SUMIF function in Excel 4.07

Change made to functions 2.21

Data

Get External Data

Use the Text Import Wizard 4.48

Sort & Filter

Filter data by using an AutoFilter 8.51

Use the Text to Columns Wizard 3.50

Find unique values and remove duplicates 6.50

Data Tools

Apply data validation 1.42

Create a drop-down list 3.32

Analysis

Use the Solver add-in 7.39

Remove subtotals 0.35

View

Freeze or unfreeze rows and columns 3.48

Web App (Collaboration)

Collaborate on a worksheet in the browser 4.20

Share a workbook in the cloud 2.09

Enable editing for your workbook in the browser 5.04

Easy project tracking in Office 365 2.19

Learn how to remove calculated subtotal rows from a worksheet in Excel 2010. 2.19

Important Notes:

The video's below are linked directly to Microsoft's Website. We hope these direct links make it easier to quickly find the video you want.
To turn on Microsoft Video transcripts. Click the "call-out" icon at bottom of video at the right of video player control panel
To get a quick-start on Office 2010 view the Video-clip courses.
Mhelp style video-clips will be available for this page shortly.

Contact us for Site Advertising Rates & Metrics

Contact us for Site Advertising Rates & Metrics

Contact us for Site Advertising Rates & Metrics

Sign in|Report Abuse|Print Page|Remove Access|Powered By Google Sites