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
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)
Excel Hour #5
Working with multiple sheets. Summarizing three ways (Paste Special, Building a Formula, Consolidate dialog box). Moving and copying sheets. Hyperlinks
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.
Excel Hour #7
Finally! We're arrived at Pivot Tables. In this session we built both pivot tables and charts, formatting the data, grouping, and manipulating it to meet our needs.
Upcoming Excel Webinars
Excel Hour #7 - Thursday, July 20 10:30 am Central
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 workbook. Conditional Formatting