Excel is a part of Microsoft Office suite and is compatible with other applications within the Office suite.Įxcel is most commonly used for storing, organizing, and manipulating data along with visualization of data in the form of charts and graphs. Microsoft Excel is a software developed by Microsoft that allows users to enter, organize, format and analyze data using a spreadsheet system. Mode.A warm welcome to the Microsoft Excel course by Uplatz. Mode.sngl: one most common occurring value in range INT(cell #) abs function returns number without the - signĪBS(cell #) Statistical functions median: MEDIAN(cell 3) $A$4 mixed cell referencing either the row or the column is an absolute reference Int function rounds number down to nearest integer MIN(cell #, cell #.) or MAX(cell #, cell #.) sum in a total table row and filter results design > total rowĬan change filter to change results conditional formatting: highlighting home > conditional formatting > highlight conditional formatting: icon sets conditional formatting > icon sets relative cell referencing cell reference in formula that changes automatically when formula moved absolute cell referencing cell reference in formula that wont change when moved to different lacationĮx.

Put the column, the function, and subtotal appearance count function how many cells have numbers in it?ĬOUNT(cell #, cell #.) counta fxn how many cells have anything?ĬOUNTA(cell #, cell #.) average function averages the cellsĪVERAGE(cell #, cell #.) mix / max functions returns min or max number of the cells Specify print titles page layout > print titles > select rows and columns to have print on each page change page margins and scaling file > print outline data data > group >auto outline (has to already have subtotals) format cell borders home > font > square format painter select cells > clipboard > format painterĮsc to stop insert image easier fit: format, arrange and align, snap to grid sum using destination cells click where you want it to go > auto sum sum using source cells select the cells you want it to use > autosum apply table style to cell range home> format as table turn table to cell range design > convert to range remove duplicates select table > remove duplicates sorting data select column > sortĬustom list? sort> order> custom list insert subtotals MAKE SURE ITS NOT A TABLEĪlso that its properly sorted in the column you want subtotaled

Microsoft excel associate certification