Spreadsheets are all about recording and managing data, but sometimes there is too much to understand or it is disorganised Columns of cells can be sorted alphabetically and numerically All data remains visible (restore hidden […]
Read More →MS Excel is a tool for managing data, really numerical data,such as sales figures or weather data! Sometimes it is used for keeping records like an address book or catalogue. Without doubt its real strength […]
Read More →freeze panes and split your worksheet
Read More →We normally think of MS Excel as a Spreadsheet Document, but actually the Excel file is a Workbook, made up of one or many sheets VIDEOCONTENT https://youtu.be/qRShQc-v3LI 4 min creating, removing sheets working with monthly […]
Read More →Spreadsheets can be huge, containing massive amounts of data. We rarely print them, and even more rarely print the entire sheet You should always consider the security implications of printing a spreadsheet
Read More →When editing or redesigning a worksheet, all the data and and formulae can be moved all over! So that our formulae will continue to work, we have to consider if that cell reference will be […]
Read More →The order of operations Excel calculates formulas based on the following order of operations: Operations enclosed in parentheses Exponential calculations (3^2, for example) Multiplication and division, whichever comes first Addition and subtraction, whichever comes first […]
Read More →Formatting is very similar to Word, the toolbar is virtually identical. Obviously there is extra focus on table like tools. VIDEOABOUT https://www.youtube.com/watch?v=etAMC0KRuBE link https://www.youtube.com/watch?v=etAMC0KRuBE 4 minutes (Fitness) Changing the font size and color Using bold, […]
Read More →The greatest power of spreadsheets is that they can be programmed (the formula with built-in functions) to do the maths as you update the data Format Painter is a tool that can help speed up […]
Read More →
enq@springstep.co.uk
West London -
Camden, Ealing, Uxbridge