Using Excel Macros can speed up work and save you a lot of time, increasing productivity! In this ‘Deep Dive’ into the topic, we will devote the full day to exploring Macros and how they are used in Excel. We recommend that you have a basic to intermediate understanding of Microsoft Excel. In this course,...
Pivot Table in Excel is one of the most powerful features of the software. It allows you to analyse hundreds of rows with just a few clicks. In this ‘Deep Dive’ into the topic, we will devote the full day to exploring Pivot Tables and how they can be used for Data Analysis. We recommend...
For individuals who are already using Word to an Intermediate level. This course will streamline and perfect your Word skills by teaching the advanced features available in the Word package. What you will learn: Tables Creating Tables Altering Tables Rows & Columns Deleting Tables Entering Date Table Layouts Formatting Tables Sorting Data Drawing Tables Charts...
For individuals who are already using Word to an Intermediate level. This course will streamline and perfect your Word skills by teaching the advanced features available in the Word package. What you will learn: Mail Merge Creating Mail Merge Merge Envelopes & Labels Creating Data Sources Editing Data Sources Tracking Tracking Changes Accept/Reject Options Viewing...
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/Edit Text Spell & Grammar Checking Change Case Saving Documents...
Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualisations. Connect to and visualise 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. Attending this workshop will help you to: Get to know...
Effective communication is key in every situation we find ourselves in, whether it is work related or in our personal life. We all know or work with people, whom we respect as effective communicators, but what is it about their behaviour that we aspire to and how do they do it? How is it that...
Have you ever been in a situation, perhaps at a business meeting, where you wanted to say something but didn’t or couldn’t? Or perhaps you have lost your temper or got upset and regretted it afterwards? These are a couple of examples of where assertive communication would have helped. Assertion involves standing up for personal...
Develop your report outline quickly and efficiently and meet your deadline! Do you dread the time it takes to put together your report? You are not alone; many people find it challenging when putting reports together. How do you know where to start? Will your reader understand your message? How do you get that message...
Ask yourself the following questions: Do I find I am constantly tense and worried about things? Do I have a general feeling of uneasiness? Are my colleagues and friends avoiding me – perhaps because they know I will easily lose my cool? Am I becoming less productive, finding it difficult to remember things or make...
For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. What you will learn: Macros Editing & Deleting Macros Record Macros Customising Ribbon Review Data Track Changes Auditing Tools...
For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. What you will learn: Formula VLookups IF Statements SumIf CountIf(s) Text Formula - Concatenate Linking Spreadsheets Separating Text Data Data Analysis Advanced Sort Options Filters...