Tip Sheets

Excel 2013

Please select the tip you would like to review.

» Absolute reference » Autofill cells » Basic formula » Bodmas formula » Cell borders » Cell number format » Cell shading » Chart background » Chart legend » Chart Pivot table » Chart series data » Chart style » Chart title » Chart type » Column row adjust selection » Column row insert delete » Columns distribute equally » Conditional format » Copy formula » Copy paste cells » Countif function » Data selection » Draw line » Draw line chart » Edit chart series point » Edit text

» Excel data and value » Excel screen » Format text » Format painter » Functions » Hide column row » Hide gridlines » IF function » Insert combo box » Insert comment » Insert Pivot table » Merge cells » Open new file » Percentage format » Picture background » Query Pivot table » Range formulae » Save as new file type » Sort data copy » Start Excel » Text flow » Unhide columns rows » VLOOKUP function » Worksheet workbook » Wrap text