This one is just for you
Downloadable resources
An Introduction to Power BI
Transform your data into rich visuals that bring it to life!
Microsoft's Power BI is a suite of tools that enables any user to quickly visualize and analyze data with greater speed, efficiency, and understanding. It connects you to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations. It also allows you to quickly share that analysis and insight with other stakeholders across any device.
Join us in this session and learn how Power BI can quickly connect to data, shape that data and visualise it.
Learning outcomes:
In this session you will learn:
- How to get data from an Excel file, CSV, the web
- How to cleanse/scrub/shape that data
- How to load that data
Suited to:
This session is designed for Business professionals, Business owners, Financial Controllers, Accountants and anyone who requires to do data analysis.
Attendees should be comfortable with Microsoft Windows environment, and be familiar with Microsoft Office applications – particularly Excel.
This E-Learning includes:
- Recording of the Live Webinar, which can be viewed multiple times
- PowerPoint Presentation
- Verbatim Transcript, with Searchability
- Supporting Documentation
- CPD Quiz
- CPD Certificate
CPD Points: 1
Beyond Pivot Tables
If you are a fan of PivotTables you will love PowerPivot!
PowerPivot enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.
Join us in this webinar and learn what PowerPivot is, how to activate and how to conduct powerful business intelligence (BI) in an environment that is familiar.
Attendees must be familiar with Excel and PivotTables.
NB: PowerPivot is built into Excel since Office 2016. We will be demonstrating using Excel 365 but the content will be relevant to users of earlier versions.
Learning outcomes:
At the end of this webinar attendees will be familiar with:
- What is PowerPivot?
- Activating the PowerPivot
- The PowerPivot tab
- The PowerPivot managed window
- Adding data to the data model from various sources
- Create relationships between tables
- Create Basic Calculated Columns and Measures
- Create a PivotTable from PowerPivot data
Suited to:
This webinar is designed for Financial Controllers, Business Analysts, Business professionals, Administration support, Business owners and anyone who requires doing data analysis and data modelling in Excel.
This E-Learning includes:
- a recording of the webinar Event which can be viewed multiple times
- a PDF of the presenter's PowerPoint
- a verbatim Transcript
- any supporting documentation
- a CPD Certificate after successful completion of the Knowledge Quiz
CPD Points: 1
Downloadable resources
Downloadable resources
Bring Your Own Devices – Risks and Challenges
We are able to work from anywhere, and often use our own devices to facilitate this. This comes with security risks we need to know, & navigate.
There are budget constraints and cyber security constraints when we use our own devices to conduct work. These represent a significant attack vector in the current landscape and being able to navigate this is something we need to prioritise in 2024. Whether you have a whole team, or just a select few doing this, being aware of the threats and having a strategy is important.
In this webinar we will cover:
- The current landscape of the ‘work from anywhere’ model, and the risks that are present.
- Why we should consider a centralised IT hardware environment.
- Dealing with budgetary constraints on hardware, that can impact your cybersecurity posture.
- Strategies to help navigate this threat landscape.
Learning outcomes:
Attendees can expect to learn:
- An understanding of the current cyber threat landscape for mobile devices.
- Why staff and their personal assets make for a bad cybersecurity combination.
- The ability to navigate these through hardware, policy and procedure requirements.
Suited to:
All companies that have a bring your own device policy and all workers who use their own devices to work from anywhere.
This E-Learning includes:
- Recording of the Live Webinar, which can be viewed multiple times
- PowerPoint Presentation
- Verbatim Transcript, with Searchability
- Supporting Documentation
- CPD Quiz
- CPD Certificate
CPD Points: 1
Data Cleansing in Excel made easy
Get & Transform (Power Query) makes self-service Business Intelligence easy!
Have you ever had the experience of importing data into Excel and then having to reformat and clean it up to a workable format before you can even begin performing any kind of analysis?
Join us in this session and we’ll show you how Power Query can make your life a lot easier. It accesses, cleans and transforms all that untidy data and displays it in a way that Excel loves and can work with. The best thing is that the next time you receive the same file, all you need to do is press the Refresh button and your data will automatically be cleaned up and displayed the correct way!
Get & Transform is built into Microsoft Excel since 2016 (including Office 365) and is available as an add-in for Excel 2010 and 2013 users (it was called Power Query).
Learning outcomes:
In this session you will learn:
- How to get data from an Excel file, CSV, the web
- How to cleanse/scrub/shape that data
- How to load that data
Suited to:
This session is designed for Business professionals, Business owners, Financial Controllers, Accountants and anyone who requires to do data analysis.
Attendees should be comfortable with Microsoft Windows environment, and be familiar with Microsoft Office applications – particularly Excel
This E-Learning includes:
- Recording of the Live Webinar, which can be viewed multiple times
- PowerPoint Presentation
- Verbatim Transcript, with Searchability
- Supporting Documentation
- CPD Quiz
- CPD Certificate
CPD Points: 1
Downloadable resources
End of Financial Year Cash Flow Modelling
Compliance can be the ideal catalyst for a cash flow conversation
Finalising a client’s statutory obligations presents the perfect opportunity to discuss the year ahead and explore what they want to achieve.
Goals will often include ‘more time’ and ‘more money’. More money allows you to hire more people, which in turn can give you more time which is why all financial models ultimately come back to one critical element and that’s cash flow.
No matter what business you are in, cash is king and remains the single most critical resource in any company. This session will discuss what it means to provide cash flow modelling as a service including a practical example which can be implemented.
Lance will explain the fundamental concepts that one needs to understand when building a cash flow model and the different types of models that can be built, along with the approach.
Cashflow modelling also requires the right business model, including a well-established approach to pricing, managing and delivering this service in a manner that is complementary to compliance work.
This topic will address:
- Defining the foundations of cash flow modelling
- Linkages of cash flow modelling to end of year tax completion
- Business model and approach to delivering cash flow modelling services
- Pricing of a cash modelling service to clients
- Example use case and model will be shared
- Take Away & Next steps
- Questions & Answers
The content will include both high level concepts and foundations as well as a detailed use case involving a practical cash flow model. All attendees will be provided with an Excel model that they can use and apply for clients.
Learning outcomes:
Attendees will gain:
- clarity on the foundations that underpin cash flow modelling.
- an understanding how to link the service to the year-end compliance process.
- useful tips on value pricing and ensuring that both the accountants and the client get value.
Suited to:
This is suitable for anyone looking to get started in developing their skills in cash flow advisory and modelling and is applicable to all sectors and companies of all sizes as concepts and design principles are common.
Accountants in public practice, management accountants, FP&A, CFOs and those professionals providing advisory and other business consulting services to clients or in roles that require them to regularly develop and present financial insights and data, such as at monthly performance or management meetings, board meetings or potentially internal meetings with key stakeholders.
This E-Learning includes:
- a recording of the webinar Event which can be viewed multiple times
- a PDF of the presenter's PowerPoint
- a verbatim Transcript
- any supporting documentation
- a CPD Certificate after successful completion of the Knowledge Quiz
CPD Points: 1
Microsoft Teams working with SharePoint and OneDrive
Learn the key features of Microsoft Teams that will help you to easily collaborate from anywhere!
Microsoft Teams is a chat-based workspace that is integrated with Office 365. It gives teams instant access to everything they need in a dedicated hub for teamwork where chat, content, people, and tools live together in Office 365
Learning outcomes:
At the end of this session, you will be familiar with:
- The Microsoft Teams interface
- Creating teams and adding members
- Sending, receiving, editing, and deleting messages
- Using chats for private messages
- Managing and deleting teams, channels, and team members
- Scheduling a meeting and inviting attendees
- Sharing files with onedrive and sharepoint
- Customising channel tabs
- Adjusting user settings
- Using the mobile app for iOS and Android
Suited to:
This session is designed for Business professionals, Business owners, Executive Assistants, Administration support staff and anyone who is working remotely and wants to be more efficient.
Attendees should be comfortable with the Windows environment, using a Mouse and Keyboard; and have some experience using Microsoft Office.
This E-Learning includes:
- Recording of the Live Webinar, which can be viewed multiple times
- PowerPoint Presentation
- Verbatim Transcript, with Searchability
- Supporting Documentation
- CPD Quiz
- CPD Certificate
CPD Points: 1
Downloadable resources
The Best of Microsoft Outlook
You may have been using Microsoft Outlook for years but are you making the most of its functionality?
For most people Microsoft Outlook is the most frequently used Office application. This is where you manage email, your calendar, contacts and tasks – basically your life.
Join us in this session and learn the most useful features of Outlook and how they can help increase your productivity.
Note: We will be demonstrating in Outlook 365 ProPlus however this webinar will also be relevant for users of earlier versions
Learning outcomes:
At the end of this session you will be familiar with:
- Using the Reading Pane – Replying Inline, Attachment Preview, People Pane
- Using Sneak-a-peak and the Attachment Reminder
- Managing your e-mail with Quick Steps, Conversation View and Clean Up
- Manage your calendar – working with multiple calendars
- Creating and editing tasks and flagged items
Suited to:
This session is designed for Business professionals, Business owners, Executive Assistants and Administration support staff.
Attendees should be comfortable with Windows environment, using a Mouse and Keyboard; and be able to use Windows to manage information on a PC.
This E-Learning includes:
- Recording of the Live Webinar, which can be viewed multiple times
- PowerPoint Presentation
- Verbatim Transcript, with Searchability
- Supporting Documentation
- CPD Quiz
- CPD Certificate
CPD Points: 1
The Best of Microsoft PowerPoint
Do you want your presentations to really stand out and impress?
Most of us are expected to communicate effectively both within our organization and with clients. Often this is in the form of a formal presentation. Microsoft PowerPoint is the most used visual aid for augmenting your presentation.
Join us in this session and learn the key features of PowerPoint that will help you to easily create engaging and polished presentations.
Note: We will be demonstrating in Microsoft PowerPoint 365, however this webinar will also be relevant for users of earlier versions.
Learning outcomes:
At the end of this session, you will be familiar with:
- Working with Slides – Inserting, Layout, Sections, Duplicating, Hiding.
- Selecting a PowerPoint Design Theme.
- Adding text to slides and inserting a table.
- Working with Images – Inserting from file or online, formatting images.
- Adding Slide Transitions.
- Animating slide content
Suited to:
This session is designed for Business professionals, Business owners, Executive Assistants, Administration support staff and anyone who requires creating effective presentations using Microsoft PowerPoint.
Attendees should be comfortable with Windows environment, using a Mouse and Keyboard; and have some experience using Microsoft Office.
This E-Learning includes:
- Recording of the Live Webinar, which can be viewed multiple times
- PowerPoint Presentation
- Verbatim Transcript, with Searchability
- Supporting Documentation
- CPD Quiz
- CPD Certificate
CPD Points: 1
Downloadable resources
Downloadable resources
The Best of Microsoft Word
How well do you really know Microsoft Word?
You may have been using Microsoft Word to create documents for years but did you know that there are some great features, tips, tricks and shortcuts that will help you do things faster and more easily?
Join us in this session and learn the best of what you really need to know in Microsoft Word.
Note: We will be demonstrating in Microsoft 365 Word, however this webinar will also be relevant for users that have Word 2021, 2019, 2016, and 2013.
Learning outcomes:
At the end of this session you will be familiar with:
- Using Templates and Styles
- Saving time with the Navigation Pane
- Headers and Footers and Cover Pages
- Saving Time with Quick Parts
- SmartArt – turning boring text into enthralling diagrams
Suited to:
This session is designed for Business professionals, Business owners, Executive Assistants, Administration support staff and anyone who requires to efficiently create professional documents using Microsoft Word.
Attendees should be comfortable with Windows environment, using a Mouse and Keyboard; and have some experience using Microsoft Word
This E-Learning includes:
- Recording of the Live Webinar, which can be viewed multiple times
- PowerPoint Presentation
- Verbatim Transcript, with Searchability
- Supporting Documentation
- CPD Quiz
- CPD Certificate
CPD Points: 1