180 likes | 343 Views
Excel 2010, Part II. CTC S ummer Workshop June 14, 2012 ; 9:00a.m. - 4:00p.m. Instructor: Janet Cannon. Agenda. Start at 9:00 a.m. Breaks ≈ 10:30 & 2:30 Lunch from 12:00-1:00 Finish at 4:00p.m. Review basics of Excel Navigation Commands/functions Changing row/col size
E N D
Excel 2010, Part II CTC Summer Workshop June 14, 2012; 9:00a.m. - 4:00p.m. Instructor: Janet Cannon
Agenda • Start at 9:00 a.m. • Breaks ≈ 10:30 & 2:30 • Lunch from 12:00-1:00 • Finish at 4:00p.m. • Review basics of Excel • Navigation • Commands/functions • Changing row/col size • View tabs • Learn more about: • Sort and Filter • Calculations • Charts/Graphs • Formatting • WS manipulation • Printing • Other features • Evaluations
I. Excel Basics Review • Navigation • Enter – down a row • Tab – right one column • Shift + Tab – left one column • Arrow keys – up, down, left, right • Ctrl + Home – beginning of document • Ctrl + End – end of document • Type coordinate/name in Name box
I. Excel Basics Review • Common commands • Undo/Redo • Select (all, row, column, cell) • Moving (row, column, cell) • Inserting/Deleting (pics, row, column, cell) • Functions • Always needs this symbol at front • Coordinates and operators: + - * / • (Auto) Sum • Average, Count, Min, Max
I. Excel Basics Review • Size • Columns, rows, cells • Pictures • Views • Normal • Page Layout • Page Break Preview
II. Excel part II • Sort and Filter • Type in “Money Earned Per Hour” data in a way that makes sense to your eyes. • Select your data including column headings • Click Sort and Filter then Custom Sort • Choose two (or more) columns to sort by. Remember you have to add a level to do the second sort. • Click okay and see the results.
II. Excel part II • Calculations • Logical operators (>, <, =, <>(not equal), >= (greater or equal), <=(less or equal)) Set them up like this: =cell reference, logical operator, cell reference to get TRUE or FALSE response. Example: =A2>B2 (If the value of A2 is greater than the value of B2, then the cell will show TRUE. If not, it will show FALSE.) • Multiple worksheets –data on sheet 1, calculations on sheet 2. • Relative, Absolute, and Mixed References (if formula copied, refs stay the same or change?)
II. Excel part II • Charts & Graphs • Design Tab-Change Chart Type (bar to pie to line etc.), Save As Template (create a template to re-use with other data), Switch Row/Column (change which data is used for horizontal/ vertical graphing), Select Data (change what information is used in the graph), Quick Layout (information formatting), Quick styles (graphics formatting), Move Chart (to another sheet or on its own sheet) • Layout Tab • Format Tab-
II. Excel part II • Charts & Graphs • Design Tab- • Layout Tab-Format Selection (add formatting just to selected area), Reset to Match Style (eliminates custom formatting and goes back to default), Insert (Pictures, Shapes, Text Box), Labels (Titles and Labels on chart), Axes (alter axes and gridlines), Background (add color/ pictures to chart background, rotate chart to 3D format), Analysis (mark trends), Properties (name the chart for advanced functions) • Format Tab-
II. Excel part II • Charts & Graphs • Design Tab- • Layout Tab- • Format Tab-Format Selection (add formatting just to selected area), Reset to Match Style (eliminates custom formatting and goes back to default), Shape Styles (change shape and color of chart), Word Art Styles (add/modify Word Art) Arrange (order of components – think of them as overhead slides), Size (measurements of the chart) • Copying into Word
II. Excel part II • Charts & Graphs • Design Tab- • Layout Tab- • Format Tab- • Copying into Word-Select section to copy, click copy, go to Word, click paste. OR use the Right Click command to copy and paste. This way you can create a chart in Excel but use Word as a Word Processor for the rest of your document.
II. Excel part II • Formatting • Convert Text to Columns- Converts word processing data into a table • Split worksheet- Lets you see separate parts of worksheet at same time. • Freeze row/column- Keeps row or column in same place as you move elements around it. • Hide worksheet-hides the worksheet • Conditional formatting- formats data based on conditions you set.
II. Excel part II • Printing • Headers/Footers – what will print at the top/ bottom of each page • Print titles – keeps column headings the same on each page • Print range – print only part of your document • Other Features • Templates – File, New, Choose a template • Saving format (.xls vs. .xlsx) • Hide/unhide columns
Practice • Go to • http://www.abacustraining.biz/Exercises/Excel/ BasicSSConcepts.htm • And • http://www.abacustraining.biz/Exercises/Excel/ BasicChartCreation.htm • To practice creating tables and charts. • If possible, use copy and paste to insert the data.
Practice Basic Charts - http://www.abacustraining.biz/Exercises/Excel/BasicChartCreation.htm Uses information from Intermediate exercises to help you practice setting up charts/graphs More Advanced Exercises - http://web.utk.edu/~dhouston/excel/exercise.html Real-world examples that take you step by step through the process. If you copy and paste the information, you WILL need to use the Text to Columns command (under Data tab) to separate data into each cell
Practice • More information/on-line tutorials • Florida Gulf Coast University Technology Skills Orientation -http://www.fgcu.edu/support/office2007/default.asp • University of South Dakota - http://people.usd.edu/~bwjames/tut/excel/index.html • Baycon Group Tutorial - http://www.baycongroup.com/el0.htm • *Excel Tutorial lessons (narrated video lessons) - http://www.exceltutorial.info/excel_tutorial_1.htm • Microsoft Excel Training (video lessons)- http://www.free-training-tutorial.com/
Practice • OfficialMicrosoft Training lessons (video with text AND optional audio) - http://office.microsoft.com/en-us/training/CR010047968.aspx • *Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun by Mike Girvin • *Written by same author • Mike Girvin (Author) • ›Visit Amazon's Mike Girvin Page • Janet Cannon (specific questions) – cannonj@capetigers.com
Questions? • Something else you’d like to know how to do? • Anything unclear? • Any suggestions for the next class? • Please fill out an evaluation/leave it in folder. I do not read these, so please be honest. • Thank you for your time. I hope you learned something that will help you use Excel more efficiently. • More questions?: cannonj@capetigers.com Thank you!