Excel and project management training

According to Wikipedia:

“Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.”

 

Learn how to use the clipboard pane

The clipboard can be very useful when using Excel, as you often need to cut or copy and paste information from one part of a sheet to another, or between different sheets and workbooks. The chances are that you’ll need to repeatedly copy and paste different items at different times, depending on the complexity of the task in hand.

You can make this easier by opening the clipboard pane as it enables you to handle multiple clipboard items at the same time. On the Home tab of the ribbon, click the arrow button to the bottom right of the Clipboard group to toggle it open or closed.

2. Open ribbon dialogs

You’ll find similar buttons in the bottom right of numerous different ribbon groups on various different tabs.

3. Update calculations manually

By default, Excel performs calculations in real time, updating each value as you input numbers or as the data changes. This is a handy feature because you can be sure that all your values are up to date.

4. Lock copy formatting

5. Customise the Quick Access Toolbar

Other courses available include:

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>