For individuals who are already using Excel, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. What you will learn: Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets. Utilities – Protecting data, hide and unhide data, named ranges, working with dates,...
For managers who are developing into senior leaders. You are even less involved in the day-to-day delivery of the work; your success depends on your ability to manage your managers as well as mentor and inspire others. Your people skills need more finesse because there is more at stake; your emotional intelligence comes to the...
For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. What you will learn: Macros – Editing and deleting macros, recording macros, customizing ribbon. Review Data...
For individuals who have never used spreadsheets or the Excel application before or only used Excel for limited tasks. At the end of the day, you will be able to create professional-looking spreadsheets. What you will learn: An Introduction to Excel - the ribbon bar, enter move and clear data, saving in Excel, creating new...
This course is ideal for any staff who are representing the company in a front-line reception position or those who are asked to deputize in this important role from time to time. It is designed to address the importance challenges that receptionists face, in addition to learning effective verbal and visual communication skills; participants will...
For anyone who organizes and takes minutes at meetings and those who would like to do this role to a professional standard. What you will learn: The difference between formal and informal meetings. How to set out an agenda. Tips and techniques for note taking. The role of the minute taker What minutes are and...
This 1-day workshop has been developed for people who would like to improve their telephone communication skills. It is particularly aimed at those who use the telephone as an important part of their job role. What you will learn: Improved communication skills The importance of voice and attitude Listening skills and questioning techniques. To sound...
For Individuals who are already using Word to an introductory level – this course will streamline and perfect your Word skills by teaching you intermediate features available within the Word application. What you will learn: Tables – creating tables, altering tables rows and columns, deleting tables, entering date, table layouts, formatting tables, sorting data, drawing...
For individuals who have never used a word processing package before or have only used Word for limited tasks. At the end of the day, you will be able to create professional looking Word documents. What you will learn: Introduction – screen layout, ribbon bar, entering and editing text, spell and grammar checking, change case,...
For individuals who are already using Excel, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. What you will learn: Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets. Utilities – Protecting data, hide and unhide data, named ranges, working with dates,...
Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight. What you will learn: Design a data model. Introduction to...
In this ‘Deep Dive’ topic, we will devote the full day to exploring Pitvot Tables and how they can be used for Data Analysis. We recommend that you have a basic to intermediate understanding of Microsoft Excel but no prior knowledge of Pivot Tables is required. What you will learn: Introduction to pivot tables Convert...
