Microsoft Excel allows you to concatenate text by using operators and functions. What does the word concatenate mean? Concatenation is the process of joining character strings end to end and has a wide variety of uses. There are four different ways to concatenate text in Microsoft Excel each with its advantages and disadvantages: The & Operator Concatenation() – Deprecated replaced by the Concat() function Concat() Textjoin() – Available in Excel[…]
READ MORE about Microsoft Excel Concatenation Functions – Textjoin, Concat, Ampersand Operator, ConcatenationMicrosoft Excel
Creating Accessible Excel Documents
Microsoft Excel contains helpful tools you can use to create barrier-free spreadsheets with accessibility features. Spending only an extra minute or two, you can use Excel’s ‘Check Accessibility’ feature to review and help make your work more user friendly for someone using adaptive technologies such as a screen reader. To begin, click the Check Availability icon on the Review tab, The Accessibility Checker will highlight any potential errors[…]
READ MORE about Creating Accessible Excel DocumentsExcel Tip: How to Prepare Excel Data for PivotTables
The PivotTables feature within Microsoft Excel can be a powerful ally in analyzing large amounts of data. However, to reduce the chance of errors, be sure to prepare Excel data for PivotTables analysis by following these 8 data clean up tasks first. Fail-Proof Tips to Get Excel Data in Shape for PivotTables Analysis You already know Excel is popular program for analyzing data, and PivotTables is one of the[…]
READ MORE about Excel Tip: How to Prepare Excel Data for PivotTablesExcel 2013 Tip: Creating a Macro
New Class Announcement Excel Mastery: Advanced Auditing Techniques for Error-Free Spreadsheets Coming in Q2 2023 – Learn about our new Excel class Create an Excel Macro to Speed Up Your Repetitive Tasks! Macros—you’ve probably heard the word before, and you may have even heard people talk about how great they are. But what’s the hype all about? When it comes to working with spreadsheets in Excel 2013, some processes[…]
READ MORE about Excel 2013 Tip: Creating a MacroCreate a Custom List to Use with Excel’s AutoFill Tool
Day of the Week? Month of the Year? A Custom Series? Use Excel’s AutoFill Tool to Populate Cells Quickly AutoFill Magic You can use Excel’s AutoFill Tool for any number of known series. For days of the week, for instance, simply start with a day, then click and drag the dark square (the fill handle) at the bottom right of the bordered cells. In our example, we’ll put “Sunday” in[…]
READ MORE about Create a Custom List to Use with Excel’s AutoFill ToolMicrosoft Excel Tip: Inserting Comments
A picture says a thousand words, but numbers sometimes need more explanation. Have you ever looked at a spreadsheet of data and had some questions about the numbers you see? On the other hand, have you ever wanted to clarify something about the data you’re providing to someone else? Give your data context by adding notes to individual cells. This tip shows you how simple it is to insert comments[…]
READ MORE about Microsoft Excel Tip: Inserting CommentsExcel Tip: Selecting the Entire Worksheet
Many users learn early on the “click + hold + drag” method for selecting a range of data using Microsoft Excel. If you have hundreds of rows of data, this method can be very tedious when needing to select all of the data within a worksheet. Selecting the Entire Excel Worksheet 3 Different Keyboard Shortcuts to Select “All” Data within a Worksheet A much easier method to select an entire Excel worksheet[…]
READ MORE about Excel Tip: Selecting the Entire WorksheetHow to Add and Remove Tabs from the Microsoft Office Ribbon
How to Customize the Office Ribbon When Microsoft introduced the ribbon in 2007, there were mixed reviews. Some users found it convenient and easier to navigate while others found it cumbersome and confusing. In either case, ribbon customization allows users to make the ribbon work for their particular needs and workflow. It’s relatively simple to customize the Office 2013 Ribbon, adding, removing, and even creating unique tabs for the ribbon. The example below[…]
READ MORE about How to Add and Remove Tabs from the Microsoft Office RibbonMicroast Excel Tip: Removing Duplicate Data
It’s not unusual to have duplicate occurrences of data in a spreadsheet, and there are numerous reasons why they might need to be removed. More importantly, you want them removed quickly so you can start analyzing the data. Luckily, there are various methods of locating and removing duplicate data in Microsoft Excel. Note: Because you are permanently deleting data, it’s a good idea to copy the original range of cells[…]
READ MORE about Microast Excel Tip: Removing Duplicate DataExcel Tip: Speed up Excel Data Entry by Changing Enter Key Behavior
Adjusting the behavior of the Enter key can be greatly beneficial when inputting data into Excel. Hitting the Enter key to move to the next cell in Excel is a movement we really don’t have to think about anymore – that is, until we are not moved to the desired cell. Luckily, Excel has an option to change the behavior of the Enter key. To access this option, click File[…]
READ MORE about Excel Tip: Speed up Excel Data Entry by Changing Enter Key Behavior