Microsoft Excel
In Excel, use the Power Query Editor (Get and Transform data) to unpivot columns and transform your data. If your data is set up cross tabular, you can't sort, filter, subtotal, or create PivotTables. To transform your data, use Power Query Editor. It changes your columns into rows.
Microsoft Excel
The SORTBY Function is one of six new dynamic array functions in Microsoft Excel. SORTBY function allows you to sort one range, based on another range. Example: You have a list of employees with the following fields: Name, Department, and Salary. You want to sort it on a separate workbook
Microsoft Excel
XLOOKUP is the latest function for Microsoft Excel. It came out on **August 28, 2019**. If you like VLOOKUP and Index/Match, you are going to love the XLOOKUP function. There are over 450 functions in Excel. Rarely does a new function come out that is a game-changer. XLOOKUP
Microsoft Excel
The SumIfs Function is an awesome Excel function. It came out with Excel 2007. It is superior to the Sumif function. The Sumif function only allows one criterion. The Sumifs function allows 29 criteria. In this video I look at referencing cells with Sumifs, using operators with sumifs. Examples of
Microsoft Excel
You can find the lowest or highest values for rows or columns in Excel using Conditional Formatting. You will need to use eihter the MIN Function, which finds the lowest value, or the MAX function, which finds the highest value. To find the lowest value by Rows 1. Select your
Microsoft Excel
The break-even point is when a company has Net Income of zero ($0.00). The revenues generated covered the expenses. There are two types of costs: - fixed - variable To find the break-even point, you need to know the **Contribution Margin**. The contribution margin can be shown as either
Google Maps allows you to share your location. You can set how long you want to share, you can stop sharing, and even request that someone shares their location with you. Why would you want to share your location? 1. You teenage kid is driving and you want to see
Gmail allows you to send confidential emails. The receipent cannot forward, print, or download attachements. You can even set an expiration date on your confidential emails. This feature allows you to protect sensitive information. To send a confidential email with Gmail 1. Open Gmail 2. Click **Compose** 3. Type your
Microsoft PowerPoint
Death in PowerPoint is often contributed to the overuse of bullets. Bullets can easily be converted to SmartArt graphics. SmartArt makes a visual representation of your bullets. SmartArt is an effective method of communicating your agenda or ideas. SmartArt works in Word, Excel, and PowerPoint. SmartArt layouts include many different
Microsoft Excel
The IF function is one of the most popular and powerful functions in Excel. The IF function has three arguments. Two of the arguments are optional. The IF function is **=IF(logical test, value if true, value if false)** Examples of the IF function - I want to give a bonus
Microsoft Word
Steps to combine multiple Word documents: 1. Have one Word document open. 2. Insert a Section break next page by clicking the **Layout** tab - Breaks - and selecting **Section Break Next Page**. 3. Add or combine the next Word document by selecting the **Insert** tab - clicking the **drop-down arrow** in
Zoom
Posted on: 04/02/2019 Steps to use a virtual background 1. Open the Zoom application and click on **Settings**. 2. Select **Virtual Background**. 3. **Choose a Virtual Background** or **Add Image**. * * * YouTube video using a virtual background with Zoom Meetings Use a virtual background with Zoom Meetings or RingCentral