Shoshannah Thorpe
18075533
CPTR112 Section A
EXCEL TUTORIAL NOTES
Video 1- Microsoft Excel Tutorial For Beginners #1 Overview
http://www.youtube.com/watch?v=8L1OVkw2ZQ8
• Exel is used to calculate and tabulate numeric data eg. Sales figures
• It consists of rows and columns and these are made up of cells which each have a specific name
• To automatically calculate the sum of or the total of a column or row of numeric data, the “sum” button is used. This function can be dragged and automatically inserted into a column or row of cells.
• To merge and centre a title simply click “merge and centre”
• To make numeric data neat they can be centred using the centre button.
• A chart of any choice can be easily inserted by highlighting selected data and selecting the chart wizard.
• Any information changed in the cells will automatically be changed in the chart.
Video 2-Microsoft Excel Tutorial for Beginners #2 - Get Started
http://www.youtube.com/watch?v=lJqfZw5j2R0&feature=related
• Editing can be done by using del esc or F5 keys
• To adjust column widths, the mouse pointer can be used to drag left or right to resize the cell
• Tab is used to go to the next cell
Video 3-Microsoft Excel Tutorial for Beginners #3 - Calculations
http://www.youtube.com/watch?v=rpCaVZCURZQ&feature=related
• Excel uses mathematical operators such as division, multiplication, addition and subtraction. Each operation has a specific key eg. +,-,/,*
• By selecting cells with numeric values and entering the correct function using the specific cell names, calculations can be carried out. Eg (=B4*C4)
• The fill function is used to fill the same function in a number of cells by clicking on the bottom right of the cell with the function and dragging or double clicking
• As in Microsoft word, text can be right or left aligned, italized or bolded.
• To calculate the total the function is =SUM (click and drag range of numbers needed) and press enter
• The autosum button can also make an intelligent guess as to what cells need to be added and automatically selects a range and inserts a function into the cell
Video 4-Microsoft Excel Tutorial for Beginners #4 - Functions
http://www.youtube.com/watch?v=sYxiYzx0_yY&feature=related
• To calculate the average, the function is = AVERAGE(select range of cells to be averaged) enter
• The paste function has a list of functions that can be used in excel. It opens a dialog box which aids in calculations
• To calculate the max of a range of numbers, the function is =MAX (select range of cells) enter, and the highest value will be displayed.
• To calculate the min of a range of numbers, the function is =MIN (select the range of cells)enter, and the lowest value will be displayed
• The count function = COUNT (select range of numbers) enter, and the number of items will be displayed
Video 5-Microsoft Excel Tutorial for Beginners #5 - Number Formats
http://www.youtube.com/watch?v=RIIcRArOCok&feature=related
• Numbers can be formatted by clicking the currency button if the value is monetary.
• Formats can be applied by clicking a formatted cell and clicking the format paste button on the cell that should be formatted.
• Comma formatting can also be done by clicking the comma icon on the toolbar
• Percentages can also be applied by clicking the percentage icon
• In excel the number 1 =100% therefore decimals should be inserted to avoid incorrect values.
Video 6-Microsoft Excel Tutorial for Beginners #6 - Formatting Pt.1
http://www.youtube.com/watch?v=qZbWJC7mO4o&feature=related
• Wrapping text can be used to accommodate them in cells
• Background cell colours can be applied by using the icon fill
Video 7-Microsoft Excel Tutorial for Beginners #7 - Formatting Pt.2
http://www.youtube.com/watch?v=csQrfaAXin0&feature=related
• Text colours can also be changed using the palette
• Gridlines can be seen when printed or not
• The print preview allows the page to be seen as it would be printed
• Conditional formatting can be used to differentiate between cells that would have a high or low value.
Video 8-Microsoft Excel Tutorial for Beginners #8 - Formatting Pt.3
http://www.youtube.com/watch?v=YU-KmgpG-ew&feature=related
• Conditional formatting can also be done manually by combining functions eg. Max or min. This is done using the conditional formatting dialog box.
• Conditions can also be easily deleted without altering the information
Video 9-Microsoft Excel Tutorial for Beginners #9 - Charts Pt.1
http://www.youtube.com/watch?v=HVX2tAHq_J0&feature=related
• To create a chart, select the information needed by selecting cells, go to chart wizard, select a type of chart, preview chart and press finish
• Size of chart can be altered by dragging the ends of the chart
• A picture can be inserted into the columns or segments of the pie chart
Video 10-Microsoft Excel Tutorial for Beginners #10 - Charts Pt.2
http://www.youtube.com/watch?v=qwx_h6DlypU&feature=related
• Charts can be easily updated when information in selected cells is changed
• It can be placed on the spreadsheet or on another sheet in the same workbook.
No comments:
Post a Comment