Intermediate Excel

MS Excel is most frequently used for business analysis, managing contact lists, operations management, and performance reporting. In addition to office administration and project management, the software is useful for administering programmes, contracts, and accounts.

Excel enables users to recognise trends, organise and classify data into meaningful categories. Excel also performs many different department functions for example - Human Resources functions, such as arranging worked hours and organising employee profiles and expenses, enabling businesses to better comprehend the structure and activities of their workforce.

To help you understand this more we will cover the following topics:

• Improve readability using cell styles;
• Using logical functions;
• Mastering the If function and nested If statements;
• The power of using Lookup to extract information;
• Sorting using a custom list and using advanced filters;
• Effective use of time and date functions;
• Top useful functions;
• Understanding pivot tables.