enq@springstep.co.uk202R0/8 Panes & Views in MS Excel
freeze panes and split your worksheet
Read More →freeze panes and split your worksheet
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 →Toolbars Provide Options Here is a fairly complicated toolbar (“Ribbon“) for MS Word. Its really worth getting to know how the Ribbon toolbar is arranged Toolbars consist of two main parts, an upper and a […]
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 →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 →
Spreadsheets are not very visually appealing, and its often difficult to see trends and comparisons, especially if there is a lot of data We can use tabular data (ie the information in a spreadsheet) to […]
Read More →We can apply formatting to values manually to highlight results. But what if there are many results and they change regularly? Conditional formatting is a useful tool to highlight important values in a spreadsheet. Once […]
Read More →
West London -
Camden, Ealing, Uxbridge