Microsoft Excel
Using Power Query in Excel to Manage Email Addresses If you have emails in Outlook and need to extract the email addresses, it can be daunting, especially when dealing with many emails. In this blog, we will explore how to use Power Query to efficiently break down email addresses from
Microsoft Excel
You can set up a relationship with two or more tables in Excel to create a PivotTable. XLOOKUP and VLOOOKUP also work, but you can skip those great functions and set up Relationships. For example, one Excel table contains the Employee ID and name. A second table contains the Employee
Microsoft Teams
NEW Teams was released in preview mode in March 2023. There are currently two versions of Teams, and depending on your settings, you can easily switch between them. Classic Teams and New Teams (aka Teams 2.0). At some point in 2024, Classic Teams will go away. Microsoft keeps launching
Microsoft Excel
In Excel, a PivotTable can be based on a Range or on a Table. I encourage you to base your PivotTable on a Table. Initially, both a range and table will be correct. The issue comes when you add data to the source and update or Refresh your PivotTable. If
Microsoft Excel
One of my favorite functions is the IF function. The IF function allows you to use true and false conditions. For example, if the value in cell B2 is over $5,000, give them a 2% discount. **IF Function in Excel** Another example is if the years of service for
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
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
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 -