Excel Training
Mastering Excel Fundamentals Through to Intermediate Level
You can use Excel for basic tables, spreadsheets, calculations and charts through to powerful data management, PivotTables, professional graphs and automation of repetitive tasks. Confident skills in this most popular and powerful Microsoft application are becoming an essential requirement in banking, finance, business, government and education sectors. Gain a solid foundation to efficiently build your know..
Excel - Effective Data Visualization Without Charts
Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it. Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on and we're constantly hearing words like data vis..
Excel - Creating an Interactive Dashboard
No matter what business you are in, a dashboard is a critical tool in your communication armory and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, its flexibility, and the fact that most people have it installed on their computers. This training focuses on what you need to know to..
Mastering Data and Information Management Essentials
Learn the powerful fundamentals of managing data and efficient techniques to transform data into valuable information for business decision making.Skills to effectively manage, present and communicate data are now vital in the competitive financial and business analysis fields and offer vast opportunities to expand accounting client services and career paths.Microsoft Excel offers powerful ‘market-leading’ ..
Power BI - Create Compelling Interactive Reports
Power BI is an application from Microsoft that turns your raw data(loaded in from a variety of sources) into stunning interactive visual reports, providing you with real-time insights into your data and enabling you to make better business decisions.Gone are the days of submitting a request to the IT Department and waiting for them to produce a less than perfect report. With Power BI you can create those re..
Linking Techniques in Depth in Excel
Linking between spreadsheets, workbooks and applications offers huge efficiencies, but needs clear understand to work accurately and avoid risks that linking can pose.Understand and apply the power of linking techniques within Excel and other key MS Office applications to boost productivity and efficiency for you and your organization. Object Linking and Embedding (OLE) makes content that is created in one ..
Leave Work On Time With Microsoft Outlook
This webinar is for individuals working in Outlook 2013, 2016, or 2019. If you want to catapult your career in addition to leaving work on time, sign up for this webinar. You will benefit professionally as you use Microsoft Outlook features to:Finish projects on timeRemember all assignmentsNever miss a deadlineNever miss a meetingYou will be recognized for your individual responsibility and accountability, ..
Excel-10 Must-Know Functions to Boost Your Productivity
Microsoft Excel contains almost 500 built-in worksheet functions. Strip away the ones nobody uses. Discount the ones that have a specialized use-case and you’re left with a small set of functions that all Excel users should know, regardless of their job function, industry or business sector. This webinar covers ten of Excel’s most popular productivity-boosting functions.Areas coveredIF: Automate data entry,..
Crazy Chaos In Your Inbox? Calm The Chaos Today!
Studies show most people spend about 50% of their work time writing and answering emails, substantiating the fact that email is an indispensable part of the workday. Processing email can be tedious, boring, and often mind-numbing yet writing and responding to emails with speed and acumen is pivotal to your success.In this day we spend together, you will learn how to:Survive the email avalanche that dumps in..
Mastering Chart and Graph Essentials in Excel
Imagine impressing your team, executives and clients with your new skills, presenting data visually in engaging professional charts!Effective charting is a strongly “in-demand” and valuable skill to possess in government, private and education sectors.Charts (graphs) can present information for decision makers and researchers in appealingpresentations, making it easier to interpret data.A visually-oriented ..
Email and Calendar Essentials with Power-User Skills in Outlook
This course effectively demonstrates and teaches the key elements of Outlook from introductory to beyond the basics, including power-user techniques, shortcuts, tips and tricks. Microsoft Outlook is the powerhouse in managing email, appointments, tasks and contacts. It aims to provide the knowledge you need to understand and use the outstanding capabilities of this powerful application. The expert tuition a..
Excel - Automation Beyond the Macro Recorder - VBA 101
VBA is Microsoft’s programming and automation language that is built into all the MS Office applications. Although Excel’s Macro Recorder allows you to automate a task by recording a series of keystrokes and mouse clicks, that’s where its functionality and power ends. To be able to do anything more, you need to harness the power of VBA.VBA is a fully-featured programming language that includes functionality..
Excel - Power Pivot – Pivot Tables For 21st Century Data Analysis
Power Pivot removes many of the limitations and frustrations that users find with creating Pivot Tables in Excel. For example, using Power Pivot you can.Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye LOOKUP and all the issues that it brings)Create Pivot Tables from large datasets without worrying about file size, performance, or needing more..
Excel: Data Visualization Crash Course
How data is presented can affect decision-making, and “Yes” it is your responsibility to present data in the best manner possible. Q: Are you serious about your data… or are you decorating? A: Find out in this webinar. This course will introduce the theory of looking at data with a new eye and mindset. It challenges the old-fashioned styles and rules. Data presentation will no longer look drab or regular, b..
Excel: Power Query Crash Course
Power Query is a somewhat new feature, it first made its entrance in Excel 2010, and now is a standard part of Excel 2016 and 2019.Power Query is a tool designed for Excel to handle repetitious steps specifically tied to data prep. We all know the drudgery of removing columns, shifting rows, correcting data formats, all before we can actually do the work with the data!The old alternative was to use macros f..