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..
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..
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..
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 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 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 ..
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, ..
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,..
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..
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 ..
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..
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..
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..
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..
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..