Microsoft Excel
Did you know that there are over 500 Functions in Excel? In this short video, part of my Excel Essentials Training Course, we look at the seven business functions I use all the time, and every Excel user should use these functions. Functions with one argument shown include SUM, AVERAGE,
Microsoft Excel
When you create a Table or PivotTable in Excel, you can work with Styles. There are three style groups - Light, Medium, and Dark. Within each group are multiple styles. This is both for Tables and PivotTables. With Styles comes Banded Rows and Banded Columns. **PivotTable Styles** YouTube Video Styles in
Microsoft Excel
Creating a Data Validation List is a great way to ensure you have "good" data. For example, I may type Human Resources as a department, but later in my data, I see HR. I know that HR and Human Resources are the same, but Excel doesn't.
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 for a House or a Car
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 - CTRL + X
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 sheet
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 and Center - Inserting and Deleting
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