Description
In this course, I will show you how to use Microsoft Excel formulas to analyze financial data. QuickBooks Online has the ability to export reports into Microsoft Excel. The course will include a basic discussion on the features of QuickBooks Online and demonstrate how data can be extracted from QuickBooks Online into Microsoft Excel. Once this data is exported into Microsoft Excel, it can be manipulated (analyzed) to assist in the business decision making process. The Excel topics covered in this course will include:
Sorting and Grouping
Autosum
Sumif Function
Sumifs Function
Count Function
Countifs Function
Concatenate Function
Pivot Tables
V-Lookups
Conditional Formatting
Data Validation
Charting (Pie and Bar Charts)
This course includes downloads that supplement the lectures. It is best to use these downloads in conjunction with the lectures.
Requrirements
Requirements
Students should have some familiarity with Microsoft Excel as this course will focus on formulas and functions
Students should be familiar with how to save documents in Microsoft Excel.