No matter what business you are in, a dashboard is a critical tool in your communication armoury 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, it’s flexibility and the fact that most people have it installed on their computer. This training focuses on what you need to know to crea..
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..
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..
More and more, your company is asking you to do some things with Excel spreadsheets that may leave you challenged or even overwhelmed.Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars.Maybe ther..
This course will show you many ways to be more efficient in Microsoft Excel.Areas CoveredKeyboard ShortcutsFormatted TablesCreate a quick data Entry formVlookupSort / FilterSubtotalsIntro to Pivot tablesCourse Level- Beginner/ IntermediateWho Should Attend Business owners CEO’s / CFO’s / CTO’sManagers of all levelsAnybody who uses Excel on a regular basis, and want to be more efficient and..
Few people learn or use Excel for fun. In fact, many people see it as a necessary evil. So if you have to use it, why not learn to use it faster and more effectively? How often have you found yourself in Excel thinking, “There must be a better and faster way to do this?”In this session, you’ll learn a handful of powerful productivity-boosting tips and secrets that will speed up your work in Excel, save you ..
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,..
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..
This webinar will raise your level of Excel competence and knowledge. In the 20+ years of training students in Excel classes, Andy has always included this set of skills to all levels of Excel users. It doesn’t matter how long you’ve been using Excel, you will probably learn something new, or at least get an idea of a new process by attending this webinar.You will learn how to skip through the spreadsheet t..
Excel Formulas and Functions are different from each other in one way: by who designs them. Formulas are created by you, the end-user, whereas Functions are pre-designed by Microsoft Excel programmers. This class is designed to remove the mystery from the language, or syntax, of the formula process. You will view multiple functions and their 2 separate help boxes. You will also see how to reverse-engineer e..
Life is a series of actions, in some we succeed and in some we fail. There is no guarantee of the result in any of the actions that we take. We act today in hope that its result will give us a better future. But sometimes, that is not the case. It doesn't mean that we stop aspiring for a better future! Failure was not our destination and we should never allow it to become one.We were all born as very resour..
This webinar will help you understand in detail the application of FDA’s guidance on the use of social media in presenting and promoting information about drug products and medical devices subject to FDA regulation. This is critical in order to develop the appropriate strategy, policies and procedures to ensure compliance.Areas CoveredPros and cons of using social media venuesCompliant use of Social Media i..
One of the most basic analytical and underwriting tools a banker must have is the ability to determine whether a borrower can repay its loans based on the financial information available. Financial organizations extend credit to borrowers when the borrowers show the ability to repay the loans extended. Ideally, a request for a five-year loan should be supported by a 5-year cash flow projection. Learn key as..
This webinar delves into how and why the brain and central nervous system respond in emotionally charged moments. According to the CDC, 85% of your thought and behavior patterns were in place by the time you were seven years old. Think about that for a moment. This webinar is intended to build understanding of the natural reactions and responses that are driven by the oldest part of your brain. As you learn..
This webinar starts with a discussion of Form W-4. This form seems simple, but that’s a deceptive simpleness — it can get quite complex. We discuss the form from both the employee and employer sides. Then we move on to other payroll topics, including the latest version of Form 941, W-2 updates, the employee retention credit, 1099 changes, and any other topics that are “breaking” as of the date of the webina..