In three hours you will learn the simplicity of Pivot Tables along with the power that they hold. You will see first-hand what all the fuss is about and what PivotTables are and why everyone needs them. If you are using Excel and want to harness the power of the tools available to you in this program this class is for you. Learn, with ease, how to set up, calculate, summarize, and analyze your data. This is one tool many executives, Managers, supervisors, administrative assistants, marketers, or anyone and everyone using excel needs to learn.
Create a PivotTable to analyze worksheet data.
Arrange fields in a PivotTable.
Group and Ungroup Data in a PivotTable.
Filter data in a PivotTable.
Create PivotCharts.
How to use PivotTables in Interactive Dashboards.
Tips and Tricks for beginning to Advanced Users of PivotTables.
Anybody with basic knowledge of Microsoft Excel
Have some working knowledge of Microsoft Excel
With this Formulas and Functions made easy class you will learn to easily automate your data analysis in Microsoft Excel. Since working with Microsoft Excel is a daily requirement for so many employees and business professionals these days there is an urgent need to simplify things and make sense of it all. By attending this class you can make Excel work for you and get the most from your data! Come learn how to easily automate your data by learning how to use If, VLookups, PMT, Absolute Referencing and many more ways to analyze your data with our Microsoft Excel Formulas and Functions Made Easy class. This powerful class will provide you with the knowledge of how to write some of Excel’s everyday formulas, but also give you the in-depth knowledge you need to take your data analysis to a new level. With just a few key strokes and mouse clicks, you will be able to make sense of all those numbers and find out how powerful Excel really is. Enroll you and your team in this Excel Formulas and Functions class and discover the power of numbers in Excel!
Data and numbers are all around us. From basic sales figures, customer records, inventory tracking and payroll information. Working with Microsoft Excel is a daily task for many business professionals of all skill levels. Whether they are manipulating spreadsheets, updating forecasting numbers or deciphering data. With all of this information there is an urgent need to simplify your work and make sense of it all, in this class you will learn to make Excel work for you and get the most from your data using formulas and functions!
Streamline your work by applying functions to your everyday tasks
Utilize the power of date functions in your spreadsheets
Differentiate between relative and absolute reference formats
Implement named cells and ranges to make your formulas more understandable
Learn useful functions, Lookups, Index and Match, If’s, and Text and Dates and more
Learn the proper way to structure your arguments in a function.
And much more!
Managers
Supervisors
Financial professionals, administrative assistants, marketers
Anyone and everyone who uses Microsoft Excel and is looking for a way to add hours back into each day!
Only basics of Excel knowledge is required
Business analytics is all around and not going away. The question is how do we show that data to represent in a way that will help our team or stakeholders make decisions or just be informed quickly? This class will be show you the foundation for how to make your data shine and illustrate how to create your own professional looking dashboard. Learn the proper way to arrange your data to make it easier to read. We will start off by discussing the various charts available to you in Excel and the best practices for using them. Then we will take those skills and utilize the data or charts in dashboards without using any code and you don’t have to be a graphic designer to present your data to communicate value. Students will walk away with a strong knowledge of visualization concepts, as well as how to implement them to their fullest in Excel
Learn best practices for designing your charts
See examples of various types of charts available in Excel
Create an Interactive Dashboards using multiple charts
Create a Travel Costs Dashboard using a variety of techniques to communicate your data effectively
Create a Pivot Table and Pivot Chart from data and use the Pivot Chart in a dashboard
Create a combination chart to builds a gauge meter
Beginner, Intermediate and Advanced Excel users
Excel knowledge helps! Intermediate/Advanced level
This course begins with getting you familiar with the MS Excel interface, menu systems, and Ribbon and how to enter and organize, format data, how to create formulas using simple functions and learn how to use absolute and relative referencing with your functions in Excel. Then it progresses to more advanced features like building charts, conditional formatting, SmartArt, PivotTables and PivotCharts, working with multiple worksheets, using advanced functions like IF, VLookup, PMT. You will also learn to automate tasks using Macros and use data analysis tools like Goal Seek and the Scenario Manager.
Understand Excel’s Menu system and perform simple to advanced calculations easily
Get time saving tips and tricks to improve efficiency
Learn how to perform printing and charting capabilities in Excel
Learn to work with multiple worksheets and workbooks
Learn data management and analysis techniques with data validation, sorting, and using filter
Understand how to create PivotTables and Pivot Charts to make your spreadsheets more appealing and easier to read
Automate routine steps with Macros to save your valuable time.
Beginning MS Excel users
Basics of Excel
Versions: Microsoft Excel 2010, 2013, 2016, 2019, 0365
In Excel, you can view, add, or even edit the properties of an existing workbook. These properties can include information such as who authored the workbook, date information, and more. This type information is referred to as metadata, and it can very useful when managing multiple workbooks. Over the course of this topic you will learn all about workbook properties and how to work with them.
Due to the nature of Excel and how it is used, you may often find yourself repeating the same task over and over again. To help streamline your workflow, it is possible to automate those tasks by creating a macro. Macros are created using code in Visual Basic for Applications; however, you don’t need to know programming in order to create a macro. Over the course of this topic, you will learn how to create a macro using the Macro Recorder.
While Excel workbooks and worksheets can contain all sorts of important and enlightening data, those important bits can sometimes be lost in a sea of information. To help bring attention to patterns or outliers in your data, Excel allows you to apply conditional formatting. Conditional formatting is often used to highlight interesting and relevant data, but it can go much further. During this topic you will learn how conditional formatting works in Excel, as well as how to apply it.
By restricting the type of data that can be entered into your workbook, you can prevent data errors and have greater control over your data. For example, some data may need to be whole numbers while some may need to be a decimal value. Over the course of this topic, you will learn about data validation and how it is used in Excel.
To assist you in creating and troubleshooting formulas in a worksheet, the Trace Cells feature will graphically display where data is coming from and where it is going. For example, it can apply a colored outline to a range in a formula, as well as to where the solution of the formula is displayed. During this topic, you will learn about the Trace Cells feature and its related components.
While you already know how to use tracer arrows to identify the components of a formula and how they interact, sometimes that isn’t enough to figure out a formula problem. Invalid data can often be the root cause of formula errors and it can greatly affect the functionality of your worksheets. Over the course of this topic, you will learn how to find and troubleshoot invalid data and formula errors.
When working with complex formulas, you can ensure that they are operating correctly using the Watch Window. Additionally, by being able to evaluate formulas while you create them, you can ensure that they are operating as intended. During this topic you will learn how to watch and evaluate formulas in Microsoft Excel.
Update workbook properties
Create and edit a macro
Apply conditional formatting
Add data validation criteria to a workbook
Trace cells
Troubleshoot invalid data and formula errors
Watch and evaluate formulas
Any Professional who would like to save time by learning more about automating repetitive tasks, data validation and auditing workbooks
Foundational Excel knowledge would be helpful for this course.