Microsoft Excel
Excel has a lot of Financial Functions. We will look at several functions for a home or car purchase. The functions include - PMT - IPMT - PPMT - CUMPRINC - CUMIPMT. These are great functions for personal finance and business. Excel Financial Functions YouTube Video Excel - Financial Functions
Microsoft Excel
Excel has many print options. We will look at setting the Print Area, Print Selection, working with Margins, Printing Gridlines, and Printing Row and Column headings. Excel Print Area Set the Print Area in Excel If you frequently need to print a particular section of a worksheet, for example, A1
Microsoft Excel
Excel has three views in the status bar. 1. Normal 2. Page Layout 3. Page Break Preview We will look at using **Page Break Preview** to move and lose page breaks and use the Insert Tab to Insert Page Breaks and Reset All Page Breaks. In Page Break Preview, dashed
Microsoft Excel
Cut and Copy are two must know features in Excel. A cut moves the data from one place to another. A copy leave it in its original place and allows you to copy it to the same worksheet, another worksheet, or even a new workbook. Keyboard Shortcuts - CUT -
Microsoft Excel
Excel filters are great for seeing just a subset of your data. You can use filters for text, numbers, and dates, but also by color. You can use font color or fill color (the paint can). You can also use Advanced Filters. You Advanced Filters when you are looking at
Microsoft Excel
Using AutoFill in Excel is one of Excel's most used features. To be proficient in Excel, you need to master AutoFill. In this video, we will look at using Autofill with Series, Columns, Number Patterns, Dates, and Text. Topics covered in the video - Quick navigation around the
Microsoft Excel
All users need certain essential Excel skills. Some of the most popular essential skills include autofit, autosum, inserting and deleting rows and columns. Another needed skill is absolute reference. AutoFill in Excel Topics covered in this post - Autofit - Absolute reference - Autosum - Manual cell width - Merge
Microsoft Excel
A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination. Excel 3D reference You can use multiple functions when creating a 3D reference. Functions such as Sum, Average, Count,
Microsoft Excel
What is the middle class and are you in the middle class? To figure out if you are in the middle class, we need to know the median household income, how many people are in your household, and where you live. Middle class calculator The starting point is the median
Microsoft Excel
**Cost-Volume-Profit (CVP)** analysis provides insights into how variations in both variable and fixed costs impact a company’s profitability. By examining the relationships between sales volume, costs, and revenue, CVP analysis helps organizations make informed decisions about pricing, production levels, and overall financial performance. The **Contribution Margin** is a company&
Microsoft Excel
We frequently need to extract part of a text string in Microsoft Excel. We are going to extract the first part of a text string. Examples of text string parts you would extract include product numbers, employee IDs, and accounting numbers. **Excel Left and Find Function** For example, the product
Microsoft Excel
Excel has three cell references - Relative, Absolute, and Mixed. It is critical to understand when to use each reference in Excel. Excel References - Relative, Absolute, and Mixed The default reference is relative is used frequently in Excel. The next highly used reference is absolute. Finally, we have two