Microsoft Excel

Microsoft Excel Concatenation Functions – Textjoin, Concat, Ampersand Operator, Concatenation

By Sanjay Nasta | January 9, 2021 | | 3

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[…]

Creating Accessible Excel Documents

By Dallas Richard | August 5, 2019 | | 2

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[…]

Excel 2013 Tip: How to Prepare Excel Data for PivotTables

By Brandy Faulk | July 10, 2017 | | 4

The PivotTables feature within Microsoft Excel 2013 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 2013 Data in Shape for PivotTables Analysis You already know Excel is popular program for analyzing data, and PivotTables is one of the many[…]

Excel 2013 Tip: Creating a Macro

By Karen Williams | June 20, 2017 | | 39

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 can be repetitive (and dare I say, boring). One example is formatting a report. While editing text styles and adjusting cells may feel like[…]

Create a Custom List to Use with Excel’s AutoFill Tool

By Karen Williams | February 28, 2017 | | 3

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[…]

Excel 2013 Tip: Inserting Comments

By Karen Williams | February 21, 2017 | | 7

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[…]

Excel Tip: Selecting the Entire Worksheet

By Karen Williams | January 17, 2017 | | 14

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[…]

How to Add and Remove Tabs from the Office 2013 Ribbon

By Karen Williams | September 27, 2016 | | 6

How to Customize the Office 2013 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[…]

Excel 2010 Tip: Removing Duplicate Data

By Karen Williams | June 24, 2014 | | 4

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 2010. Note: Because you are permanently deleting data, it’s a good idea to copy the original range of[…]

Excel Tip: Speed up Excel Data Entry by Changing Enter Key Behavior

By Karen Williams | December 6, 2013 | | 3

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[…]

Menu Responsive

Search