In this interactive tutorial, learn how to create formulas to solve real-world problems.
Lessons include: (1) About This Tutorial. Learn more about using formulas and functions in Excel or another spreadsheet application.
Learn these Excel tips and tricks so you can do more with this popular spreadsheet program.
Lessons include: (1) Add the Current Date to a Cell. Learn how to add a date or time stamp to any cell with this Excel keyboard shortcut. (2) A Faster Way to Use the Fill Handle. Learn a faster way to use the fill handle in Excel. (3) Two Ways to Use the Format Painter. Learn how to use the Format Painter in Excel. (4) A Shortcut to AutoSum. Learn an Excel keyboard shortcut that makes the AutoSum function even faster. (5) Quick Access Toolbar Shortcuts. Learn how to add shortcuts to the Quick Access Toolbar in Excel. (6) How to Quickly Duplicate a Sheet. Learn a shortcut for making an exact copy of an existing worksheet. (7) Jump to Any Sheet with a Shortcut. Here's a shortcut for quickly jumping to any sheet within a workbook. (8) Select an Entire Row or Column. Learn these Excel shortcuts for selecting an entire row or column at one time. (9) Find a Sum Without Using a Formula. Here's how to find a sum without using a formula. (10) Why You Should Avoid Merging Cells. Use the Center Across Selection feature to easily merge cells in Excel. (11) Using the Quick Analysis Tool. Learn how to browse through different visualization options with the Quick Analysis tool. (12) How to Make Charts Auto Update. Learn how to use tables to keep charts up to date using this Excel feature. (13) Use Transpose to Flip Data on its Side. Here's how to use the Transpose feature to rearrange your data instantly. (14) Absolute References with the F4 Key. Learn how to convert a cell reference to an absolute reference with the F4 key. (15) Add a New Row with a Shortcut. Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet. (16) Use an Entire Column as a Cell Range. Learn how to use an entire column as a cell range in Excel. (17) What are Named Ranges?. Learn how to use named ranges to make your formulas easier to write and read. (18) A Trick for Finding Inconsistent Data. Here's a trick for quickly finding inconsistent data in a large spreadsheet.
Context Rich Problem using the concepts of excise tax incidence, elasticity of demand, and elasticity of supply. Students must determine which information is appropriate and which is extraneous to the problem.
Research an innovative person from history and create a project to communicate what you learned. Time to complete: 2-3 hours
Students make sense of dollars and cents when they study the importance of saving and budgeting in this lesson.
The Fair model web site includes a freely available United States macroeconomic econometric model and a multicounty econometric model. The models run on the Windows OS. Instructors can use the models to teach forecasting, run policy experiments, and evaluate historical episodes of macroeconomic behavior. The web site includes extensive documentation for both models. The simulation is for upper-division economics courses in macroeconomics or econometrics. The principle developer is Ray Fair at Yale University.
"Father Christmas" by The Kinks is used in conjunction with Joel Waldfogel's article "The Deadweight Loss of Christmas" to examine the relative value of cash versus inkind gifts. This can then be extended to an analysis of various public policies.
This 9-minute video lesson looks at 401(k)s (and how they compare to IRAs). [Core Finance playlist: Lesson 59 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
Tnis 4-minute video lesson provides an overview of what the Alternative Minimum Tax is and its purpose. [Core Finance playlist: Lesson 149 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 5-minute video lesson gives a simple example of accrual accounting. [Core Finance playlist: Lesson 106 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 4-minute video lesson explains the mechanics of a share-based acquisition. [Core Finance playlist: Lesson 144 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 3-minute video lesson discusses Actual Option Quotes. [Core Finance playlist: Lesson 86 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 4-minute video lessob sovers the basics of the alternative minimum tax. [Core Finance playlist: Lesson 121 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 4-minute video lesson looks at American call options. [Core Finance playlist: Lesson 70 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 15-minute video lesson explains why the Chinese buying of American debt leads to lower interest rates. [Core Finance playlist: Lesson 68 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 3-mintue video lesson discusses American Put Options. [Core Finance playlist: Lesson 72 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 4-minute video lesson compares depreciation and amortization. [Core Finance playlist: Lesson 114 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 3-minute video lesson looks at how annual Interest varyies with debt maturity. [Core Finance playlist: Lesson 135 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 7-minute video lesson looks at the difference between APR and effective APR. [Core Finance playlist: Lesson 53 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.
This 3-minute video lesson provides more information on quantitative easing. [Core Finance playlist: Lesson 151 of 184]
Khan Academy learning modules include a Community space where users can ask questions and seek help from community members. Educators should consult with their Technology administrators to determine the use of Khan Academy learning modules in their classroom. Please review materials from external sites before sharing with students.