Think that Excel math operations always require complex formulas. It’s time to introduce you to a game-changing feature – Excel Paste Special math operations. This powerful tool allows you to perform basic calculations without writing a single formula. Let’s dive into an example: Imagine you have a list of product prices in Excel, and you’re tasked with increasing all these prices by 5%. The traditional way might involve creating formulas,[…]
READ MORE about Efficient Math Operations in Excel without Formulas: The ‘Paste Special’ TrickExcel Tip: Selecting the Entire Worksheet
How do you select all the data within your 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[…]
READ MORE about Excel Tip: Selecting the Entire WorksheetMicrosoft Excel Concatenation Functions – Textjoin, Concat, Ampersand Operator, Concatenation
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, ConcatenationCommon PDF Accessibility Mistakes to Avoid
How to make a PDF accessible There could be a whole book on common pitfalls and mistakes when testing PDF documents for accessibility and PDF remediation. Often issues that come up in PDF remediation are easily fixed. The challenge comes in locating the error and knowing how to fix it. Here are a few common issues known to cause challenges with PDF documents. Embedded Fonts Embedding fonts is one of[…]
READ MORE about Common PDF Accessibility Mistakes to AvoidCreating 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 DocumentsCreating a Subform in Microsoft Access
Microsoft Access Subforms: The Key to Displaying Access Data from More than One Table Want to take a deep dive into Microsoft Access? Consider enrolling in one of our virtual, full-day Access training classes. All classes are instructor-led, encourage interaction and questions, and provide hands-on exercises and learning aids. A frequent question asked in our Access classes concerns how to display the data in a form when the data is coming[…]
READ MORE about Creating a Subform in Microsoft AccessWindows 10 Tip: Customize Your Start Menu
Each of us has different needs when it comes to our computers. A great place to start customizing your computer experience is the Start menu. Windows 10 offers many personalization options to make the Start menu fit your workstyle and lifestyle. Personalizing Your Windows 10 Menu There are several ways to customize your Windows 10 Start menu, you have several options: Resizing Resize your Start menu by clicking, holding, and dragging[…]
READ MORE about Windows 10 Tip: Customize Your Start MenuMicrosoft PowerPoint Tip: Use the Selection Pane to Improve Accessibility
Improve Your PowerPoint Accessibility It’s imperative that you incorporate accessibility best practices into your presentations so everyone, including people with disabilities, has an equal opportunity to benefit from your work. For instance, many with visual impairments commonly use a screen reader. A screen reader will dictate the content you’ve created based on a slide’s reading order. In PowerPoint, the reading order does not necessarily go from the top–to–bottom, left–to–right as[…]
READ MORE about Microsoft PowerPoint Tip: Use the Selection Pane to Improve AccessibilityExcel 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
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[…]
READ MORE about Excel 2013 Tip: Creating a Macro