Excel

How to change workbook Views

View > Workbook Views

How to customize quickaccess toolbar

last icon on quick access toool bar> More commands > add or remove commands and sort

How to freeze panes

highlight below the row you want to freeze > view > freeze panes > freeze panes

How to modify workbook properties

File > Info > properties

how to show display formulas

click cell >formula tab > show formulas

How to set the print area

select the print area > page layout > print area > set print area

How to save workbooks inn a specific file format

go to File > Save As, > choose location, >select the file format

How to configure print settings

Click file > print > adjust from there

Inspect workbooks for issues

File > Check for issues > Inspect document

how to paste data by using special paste options in excel

select the cells you want to copy >double click > click the Paste arrow > choose Paste Special, and then select the desired paste option

How to auto fill

Insert initial data > select data > go to the bottom right option > drag it to fill the rest

How to insert multiple cells

copy cell or row > paste it

How to merge and unmerge cells

Home tab > Merge and center or unmerge cells

Modify Cell Alignments

select the cells you want to format, go to the Home tab, and use the Alignment group

How to Format cells by using Format Painter

select the cell > home > format painter

How to apply number formats

Select the cells > Home > Number format

How to apply cell formats from the format cells dialog box

select cells > home > dialog box

How to apply cell styles

Select cells > Home > cell styles > choose

How to clear cell format

Select Cells > home > eraser icon > clear format

How to create a table

Select an area of cell or cells > insert > Table > choose name and Okay

How to define a range

Select cells > choose range

How to find name manager

formulas > name manager

How to insert sparklines

Select the cell > insert > sparklines > select the range > okay

How to apply conditional formatting

Select the cells > insert > conditional formatting > apply the rules

How to convert tables to cell ranges

Select table > table Design > convert to range

How to add or insert a row or column to a table

right click a table cell > insert > apply from options

How to configure table style options

Select a table > table design

how to add a total row ???

select table > table design > check total row

How to filter a table

Select table > click dialog box next to the column you want to filter > apply filter options

How to insert a relative reference ?

set the cell equal to cell you want to reference

How to insert a absolute reference ?

set the cell equal to cell but you need “$” signs before the row and column number

How do insert a mixed reference

set the cell equal to cell but you need “$” signs before the row or column number

How to reference a defined range

enter your function > select the range you want to inser into it

how to do if statements

=if(””condition"“,”result1”,result2)

How to use the left,right,mid function

=”desired poistion”(“cell”,”index”,”how many numbers you want returned”)

How to use the upper,lower and len functions

=”function”(cell)

How to do concat

=CONCAT(“ANY CELLS OR STRENGS SEPERATED BY A RANGE OR COMMA”)

How to text join

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

How to create a chart

select data > insert > chart >

How to create a chart sheet

select chart > Move chart > new sheet

How to add data series to chart

select chart > chart design > select data > data sorce > apply series

How to switch between rows and columns

select chart > chart design > switch between row and column

How todo quick layout

Select chart > chart design > quick layout

How to change the color of one column

select chart >format > double click the column > shape fill

How to change chart alt text

Select chart > right click > change alt text