Analyzing Data with QuickBooks Online and Microsoft Excel
- 5
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Understanding Your Business using Microsoft ExcelDescription
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.
Requirements
- 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.
Tymone Green
5 Raiting
The Ultimate Microsoft Project 2013 & 2016 Mastery Course
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Learn to use Microsoft Project and ensure your next project is successful. Get 4 courses, 37 hours, and over 200 videos....
Introduction to Microsoft Project 2016 for Beginners
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn the essentials of Microsoft Project 2016 in easy to follow steps During this introductory course on using Microsoft Project 2016, we'll teach the basics of using Microsoft Project 2016....
Learn Excel Conditional Formatting with 7 Practical Problems
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn Excel Conditional Formatting features (both common rules and formula based) to visualize the insight of your data. Teaching 11 Courses on Excel and Data Analysis!...
The Ultimate Microsoft Access 2013 & 2016 Mastery Course
- 0.0
-
![]()
![]()
![]()
![]()
![]()
37 Hours of Training. The Most Convenient Way to Boost Your Confidence And Learn Access Databases Inside And Out—Quickly Become a super star Access 2013 & 2016 user everyone...
