Microsoft Excel 2007 Module 1

1. Microsoft Excel 2007 Module 1

2. Course Outline This course consists of seven sessions:- • Basic skills • Doing useful work with Excel • Taking your skills to the next level • Making your worksheets look professional • Charts and graphics • Working with multiple Worksheets and Workbooks • Printing your work

3. Overview • Essential Skills course contains seven sessions designed to give you a solid grounding in Excel 2007 • Expert course adds another sixteen sessions to bring you to expert level Essential Skills Expert

4. Session One: Basic Skills A bad beginning makes a bad ending. Euripides, Aegeus (484 BC - 406 BC).

5. Objectives By the end of this session you will be able to:- • Start Excel and check your program version • Maximize, minimize, re-size, move and close the Excel window • Understand the Application and Workbook windows • Open and navigate a workbook • Save a workbook • Pin a document and understand file organization • View, add, rename, delete and navigate worksheet tabs • Use the Ribbon • Understand Ribbon components • Customize the Quick Access Toolbar and preview the printout • Use the Mini Toolbar, Key Tips and keyboard shortcuts • Understand Views • Use full screen view • Use the help system

6. Session Two: Doing Useful Work with Excel • Only those who have the patience to do simple things perfectly ever acquire the skill to do difficult things easily. • Unknown authors

7. Objectives By the end of this session you will be able to:- • Enter text and numbers into a worksheet • Create a new workbook and view two workbooks at the same time • Use AutoSum to quickly calculate totals • Select a range of cells and understand Smart Tags • Enter data into a range and copy data across a range • Select adjacent and non-adjacent rows and columns • Select non-contiguous cell ranges and view summary information • Re-size rows and columns • Use AutoSum to sum a non-contiguous range • Use AutoSum to quickly calculate averages • Create your own formulas • Resize a column and create functions using Formula AutoComplete • Use AutoFill for text and numeric series • Use AutoFill to adjust formulas • Use AutoFill Options • Speed up your AutoFills and create a custom fill series • Use the zoom control • Print out a worksheet

8. Session Three: Taking Your Skills to the Next Level • One only gets to the top rung of the ladder by steadily climbing up one at a time, and suddenly all sorts of powers, all sorts of abilities which you thought never belonged to you – suddenly become within your own possibility. • Margaret Thatcher, • Prime Minister of the United Kingdom from 1979-1990

9. Objectives By the end of this session you will be able to:- • Insert and delete rows and columns • Use AutoComplete and fill data from adjacent cells • Cut, copy and paste • Cut, copy and paste using drag and drop • Use Paste Values • Increase/decrease decimal places displayed • Transpose a range • Use the multiple item clipboard • Use Undo and Redo • Insert, View and Print cell comments • Understand absolute, relative and mixed cell references • Create a template • Use a template • Freeze columns and rows • Split the window into multiple panes • Check spelling

10. Session Four: Making Your Worksheets Look Professional • It is only shallow people who do not judge by appearances. • Oscar Wilde (1854 - 1900)

11. Objectives By the end of this session you will be able to:- • Format dates • Understand date serial numbers • Format numbers using built-in number formats • Create custom number formats • Horizontally and Vertically align the contents of cells • Merge cells, wrap text and expand/collapse the formula bar • Understand themes • Use cell styles and change themes • Add color and gradient effects to cells • Add borders and lines • Create your own custom theme • Create your own custom cell styles • Use a master style book and merge styles • Use simple conditional formatting • Manage multiple conditional formats using the rules manager • Bring data alive with visualizations • Create a formula driven conditional format • Use the format painter • Rotate text

12. Session Five: Charts and Graphics • A picture is worth a thousand words. • Frederick R. Barnard in “Printers’ Ink”, 8th Dec 1921.

13. Objectives By the end of this session you will be able to:- • Create a simple chart with two clicks • Move, re-size, copy and delete a chart • Change the chart layout and add a data table • Format chart element fills and borders • Format 3-D elements and align text • Move, re-size, add and delete chart elements • Change a chart’s source data • Create a chart with numerical axis • Deal with empty data points • Add data labels to a chart • Highlight specific data points with color and annotations • Add gridlines and scale axis • Emphasize data by manipulating pie charts • Create a chart with two vertical axis • Create a combination chart containing different chart types • Add a trend line • Switch chart rows/columns • Add a gradient fill • Create your own chart templates

14. Session Six: Working With Multiple Worksheets and Workbooks • There are no big problems; there are just a lot of little problems. • Henry Ford (1863-1947) • American industrialist and pioneer of assembly-line production

15. Objectives By the end of this session you will be able to:- • View the same workbook in different windows • View two windows side by side and perform synchronous scrolling • Duplicate worksheets within a workbook • Move and copy worksheets from one workbook to another • Hide and unhide a worksheet • Create cross-worksheet formulas • Understand worksheet groups • Use find and replace

16. Session Seven: Printing Your Work • The greatest misfortune that ever befell man was the invention of printing. • Benjamin Disraeli, British Prime Minister and Novelist (1804-1881).

17. Objectives By the end of this session you will be able to:- • Print Preview and change paper orientation • Use page layout to adjust margins • Use Page Setup to set margins more precisely and center the worksheet • Set paper size and scale • Insert, delete and preview page breaks • Adjust page breaks using Page Break Preview • Add auto-headers and auto-footers and set starting page number • Add custom headers and footers • Specify different headers and footers for the first, odd and even pages • Print only part of a worksheet • Add row and column data labels and grid lines to printed output • Print several selected worksheets and change the page order • Suppress error messages in printouts

18. The Next Step www.LearnMicrosoftExcel.com