Creating a Financial Report in Excel
by David Wang
Preview
|
Full size
Buy lesson
Buy lesson
(only $0.99) |
You Might Also Like
-
Simple & Compound Interest 180 -
Simple Interest Formula & Maturity Value Formula -
Create a simple macro in Excel 2007 -
Compare two lists in Excel 2007 with @VLOOKUP -
Calculating Payments in Excel -
Learn Excel Basics, Part 3 - Cell References -
Learn Excel Basics, Part 1 - Data Entry -
An Introduction to Excel -
Learn Excel Basics, Part 2 - Create Formulas -
Creating Invisible Buttons in Flash
-
Creating Invisible Buttons in Flash -
Learn Excel Basics, Part 2 - Create Formulas -
An Introduction to Excel -
Learn Excel Basics, Part 1 - Data Entry -
Learn Excel Basics, Part 3 - Cell References -
Calculating Payments in Excel -
Compare two lists in Excel 2007 with @VLOOKUP -
Create a simple macro in Excel 2007 -
Simple Interest Formula & Maturity Value Formula -
Simple & Compound Interest 180 -
Learn Accounting Basics -
How to Manage Employees -
Create a Poster in Photoshop(Part 2) -
Create a Poster in Photoshop(Part 1) -
Learn to Draw in Adobe ILLUSTRATOR -
Interior Design Basics - Add Style to Your Home -
Creating Invisible Buttons in Flash -
Deleting Background Using Photoshop -
How to Create Rounded Corners in Dreamweaver -
How To Manage Stress
-
How To Manage Stress -
How to Create Rounded Corners in Dreamweaver -
Deleting Background Using Photoshop -
Creating Invisible Buttons in Flash -
Interior Design Basics - Add Style to Your Home -
Learn to Draw in Adobe ILLUSTRATOR -
Create a Poster in Photoshop(Part 1) -
Create a Poster in Photoshop(Part 2) -
How to Manage Employees -
Learn Accounting Basics
About this Lesson
- Type: Video Tutorial
- Length: 9:30
- Media: Video/mp4
- Posted: 03/09/2009
- Use: Watch Online & Download
- Download: MP4
- Size: 15 MB
Knowledgeocity.com online training presents Microsoft Office training courses. This lesson covers an intermediate Excel topic, how to create a financial report in Excel. In this lesson, you will move beyond simple formulas to creating tables with those formulas. Eventually, you will learn to use an array formula, which combines the formulas from the first two tables to fill a third table, without worrying about all the relative cell references.
View Beginner Excel lessons:
Learn Excel Basics, Part 1 - Data Entry: http://www.mindbites.com/lessons/1965
Learn Excel Basics, Part 2 - Formulas: http://www.mindbites.com/lessons/1963
Learn Excel Basics, Part 3 - Cell References http://www.mindbites.com/lessons/1966
For this entire course and more, visit Knowledgeocity.com
About this Author
-
- David Wang
- 25 lessons
- Joined:
03/05/2009
Knowledgeocity offers convenient and affordable online video training in a wide variety of categories and topics from business skills, computer software, finance, to lifestyle and many more. All courses are taught by university professors and certified industry experts to ensure the highest quality training videos. We offer ALL YOU CAN LEARN unlimited access to ALL training courses to fit anyone’s schedule and budget.
Check out our new website at: www.Knowledgeocity.com
More..Recent Reviews
Recent Comments
-
- Useful
- 06/13/2009
-
The lesson is very useful especially for those who are new in Excel. Many small organization is looking a simple solution to create financial report and Excel is the best low cost solution.
-
- Useful
- 06/13/2009
-
The lesson is very useful especially for those who are new in Excel. Many small organization is looking a simple solution to create financial report and Excel is the best low cost solution.
-
- great Excel advice
- 03/13/2009
-
This lesson will walk you through some Excel features slightly more advanced than using a simple formula. This lesson includes setting up tables, using various sum and multiplication formulas, and creating array formulas. These are used to create a financial report that can track sales, pricing, revenue, and more. Excel is an extremely helpful tool, when you know how to use it properly!
-
- Useful
- 06/13/2009
-
The lesson is very useful especially for those who are new in Excel. Many small organization is looking a simple solution to create financial report and Excel is the best low cost solution.
-
- Useful
- 06/13/2009
-
The lesson is very useful especially for those who are new in Excel. Many small organization is looking a simple solution to create financial report and Excel is the best low cost solution.
Buy Now and Start Learning
CommunityMore
- Painting with Acrylics: Layering Te...
-
- I am taking a class from Polly right now, and this lesson is a great way for me to unde...
- Trigonometry: Trig Function Composi...
-
- great explanation of trig function composition and inverse trig functions.
- Flower painting 1-Water Color Pencils
-
- Excellent, easy to follow instruction.
- I want to learn how to build a slid...
-
- I want to learn how to build a slideboard
- compound subjects and predicates
-
- compound subjects and predicates
- I want to learn Trigonometry
-
- I want to learn Trigonometry
Embed this video on your site
Copy and paste the following snippet:
Link to this page
Copy and paste the following snippet:
This lesson will walk you through some Excel features slightly more advanced than using a simple formula. This lesson includes setting up tables, using various sum and multiplication formulas, and creating array formulas. These are used to create a financial report that can track sales, pricing, revenue, and more. Excel is an extremely helpful tool, when you know how to use it properly!