How to create a combination view to look at resource over allocation in Microsoft Project – Visualising data in multiple panes. View more Microsoft Tutorial Videos on our Youtube page If you have a handy Excel tip that you’d like to share, why not email and we’ll consider publishing it here. Alternatively, if you’d …
Follow these Excel tips and best practice guidelines. Enter Data in columns with labels at the top and no spaces. Why do it? Most functions in Excel are looking for data arranged in columns I.e. lists. In this way functions like Autosum, Subtotals, Filters, Pivot tables and so on can …
Use these Excel Keyboard Shortcuts to navigate around a data sheet. Ctrl + Home key Moves the cursor to cell A1 Ctrl …
Excel Tutorial Video – navigation fundamentals Watch this short video tutorial on Excel navigation techniques. How to move around data blocks and use of …
