This is the "Home" page of the "Excel Training" guide.
Alternate Page for Screenreader Users
Skip to Page Navigation
Skip to Page Content

Excel Training   Tags: archived webinars, excel, statistics, webinar  

Recordings, planned webinars, pertinent tips and tricks for Excel
Last Updated: Jun 20, 2017 URL: http://tsla.libguides.com/excel Print Guide RSS Updates
Home Print Page
  Search: 
 
 

Excel 2010

 

Excel Tip

Small Tip Graphic

Did you know?

Did you know, you can use Alt + = (Alt plus the equal keys) to sum a column or row?

Select the cell where you want the resulting sum. Press Alt + = and your total will appear!

Links to archived Excel webinars

Excel Hours #3

Freeze panes, Comments, Find & Replace, Sort, Filter, Text to Columns / Concatenate, View same workbook in 2 windows, Re-arrange columns, Hide & Unhide columns

http://stateoftennessee.adobeconnect.com/p3t8ak4ob9o/

Excel Hour #4

Formatting your worksheet. Font style, size & color. Text Alignment, Formatting numbers, Insert picture, Call Outs, Format Painter, Printing (margins, center, gridelines, shrink-to-fit)

http://stateoftennessee.adobeconnect.com/p8x7816yssw/

Excel Hour #5

Working with multiple sheets. Summarizing three ways (Paste Special, Building a Formula, Consolidate dialog box). Moving and copying sheets. Hyperlinks

http://stateoftennessee.adobeconnect.com/p923pelpkiw3/

Excel Hour #6

 

All things charting! If your goal is to convey the greatest number of ideas in the smallest amount of space with the least amount of words, charting is for you! We'll talk about one-click charts, changing chart types, and formatting along with some visualization techniques.

http://stateoftennessee.adobeconnect.com/phkbemoe93hd/

      
     

    Upcoming Excel Webinars

    Excel Hour #7 - Thursday, July 20 10:30 am Cenetral

    Pivot tables & pivot charts

    Excel Hour #8 - Thursday, August 3 - A little of this and a little of that

    What-if analysis. Data Validation. Hiding portions of the worksheet. Protecting a workboo. Conditional Formatting

    Subject Guide

    Profile Image
    Lauri Thompson
    Contact Info
    Send Email
     
    Description

    Loading  Loading...

    Tip