• Skip to main content
  • Skip to primary sidebar
  • Skip to primary navigation
Federal Solutions
Contact Us:       [email protected]       (512) 794-8440

Microassist

Menu Responsive

Search

  • Accessibility Services
    • Accessibility Audits
    • VPAT Consulting Services
    • Accessibility Remediation
    • Accessible PDF and Document Remediation Services
    • Accessible Website and Application Development
    • Accessible Digital Learning
    • Compliance for Digital Learning
    • Accessibility Training
    • Accessibility in the News
    • VPAT Buyers Guide
  • Custom E-Learning
    • Accessible E-Learning
    • Managed Learning Services: Training Support for Business
    • Training Staff Augmentation Services
    • Learning Management System
    • Learning Translation and Localization
    • Examples of Our Work
    • The Learning Dispatch (Blog)
  • Classes
    • Course List
    • Course Schedule
    • Classroom Rental
    • Security Awareness Training
    • Classes FAQ
    • Software Tips (Blog)
  • About
    • Government Solutions
    • Newsletter Subscriptions
    • Career Opportunities
    • News and Media
    • Blogs
    • Team
  • Open Search Field

Microsoft Excel

Unlocking Collaboration: How to Protect and Unprotect Cells in Excel

By Karen Williams  |  May 25, 2023  |    |   

Excel isn’t just about crunching numbers; it’s also a powerful tool for data sharing. But with shared access comes the risk of accidental data modification. The solution? Learning how to protect and unprotect cells in Excel. Unlocking Editable Areas in Your Data To make certain data available for editing, follow these steps: Highlight the cells you want to leave unlocked. Head to the ‘Home’ tab, look for the ‘Cells’ group,[…]

READ MORE about Unlocking Collaboration: How to Protect and Unprotect Cells in Excel

Microsoft Excel: Text to Columns – Split Pasted Data Effortlessly

By Sanjay Nasta  |  May 8, 2023  |    |   

  Text to Columns is a powerful Excel feature that allows you to separate text or data in a single column into multiple columns.  This article covers the basics of using Text to Columns, focusing on the differences between delimited and fixed-width separation, treating consecutive delimiters as one, and using multiple delimiters. Common Use Cases for Excel Text to Columns Some common examples where Text to Columns is useful are::[…]

READ MORE about Microsoft Excel: Text to Columns – Split Pasted Data Effortlessly

Excel Tip: Highlight All Cells Referenced by a Formula

By Sanjay Nasta  |  April 24, 2023  |    |  4

In Excel, visualizing the relationship between the cells used in a formula can be a powerful tool for understanding the spreadsheet’s structure and for debugging purposes. Here’s a tip on how to highlight all cells referenced in a formula in Excel: Select the Cell Containing the Formula: Begin by selecting the cell that contains the formula you’re interested in. When a cell with a formula is selected, Excel provides a[…]

READ MORE about Excel Tip: Highlight All Cells Referenced by a Formula

Million Dollar Mistakes: Real-World Risks of Spreadsheet Errors

By Microassist Learning  |  February 7, 2023  |    |   

Have you ever spotted an error in a spreadsheet? Errors in spreadsheets are common, with more than 90% of spreadsheets containing errors. These errors remain undetected as spreadsheets are rarely tested. Research has shown that 50% of spreadsheet models used in large businesses have material defects. Organizations rely on spreadsheets for complex data management and decision-making. It is important to be aware of the risks associated with spreadsheet errors. Errors[…]

READ MORE about Million Dollar Mistakes: Real-World Risks of Spreadsheet Errors

Level Up Your Worksheets: Creating Dropdown Lists in Excel Without Macros

By Karen Williams  |  August 20, 2022  |    |  1

Want to give your Excel worksheets a professional edge while ensuring data accuracy? Create dropdown lists in Excel, a feature that doesn’t require any macros! For instance, let’s consider an input cell where the user needs to enter a month name. Setting Up Your Dropdown Items Start by entering your dropdown items into a column on your worksheet. Let’s consider the month names entered from cell E1 to E12. The[…]

READ MORE about Level Up Your Worksheets: Creating Dropdown Lists in Excel Without Macros

Efficient Math Operations in Excel without Formulas: The ‘Paste Special’ Trick

By Andy Weaver  |  August 7, 2022  |    |   

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’ Trick

Excel Tip: Selecting the Entire Worksheet

By Karen Williams  |  January 17, 2022  |    |  15

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 Worksheet

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

READ MORE about Microsoft Excel Concatenation Functions – Textjoin, Concat, Ampersand Operator, Concatenation

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

READ MORE about Creating Accessible Excel Documents

Excel Tip: How to Prepare Excel Data for PivotTables

By Brandy Faulk  |  July 10, 2017  |    |  4

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 PivotTables
  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar


Data Analysis and Visualization course
Click to Register for Data Analysis and Visualization Course

Subscribe to Monthly Training Updates

Receive monthly productivity and training insights, software tips, and notices of upcoming classes!

Name

Recent Posts

  • Unlocking Collaboration: How to Protect and Unprotect Cells in Excel
  • Microsoft Excel: Text to Columns – Split Pasted Data Effortlessly
  • Keys to PDF Accessibility: Setting and Fixing Bookmarks
  • Excel Tip: Highlight All Cells Referenced by a Formula
  • Keys to PDF Accessibility: Setting Document Properties in Adobe Acrobat Pro

Categories

  • Accessibility
    • Screen Reader
  • Adobe Acrobat
  • Crystal Reports
  • Microsoft Access
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Powerpoint
  • Microsoft Project
  • Microsoft Word
  • MS Office
  • Web
  • Windows 10

Footer

Microassist

As one of Central Texas’s most experienced software education centers, a primary training vendor for the State of Texas, and a Microsoft Certified Solution Partner, Microassist has successfully worked with clients in fields ranging from advertising, real estate, law and politics to state and government agencies.

Quick Links

Government Solutions

Classroom Course Schedule

Excel Classes near Austin, TX

Insights in Training (Blog)

Training Managers Guide to Accessible Learning

Digital Accessibility Blog

Accessibility in the News

Lexis-Nexis Mealey’s® Commentaries

What is VPAT?

Contact Us

Microassist, Inc.

8500 Shoal Creek
Building 4, Suite 225

Austin, Texas 78757

Tel: (512) 794-8440
Fax: (512) 794-8742

Email: [email protected] MORE

Back to Top
Copyright 2023 Microassist. All Rights Reserved.
  • Privacy
  • Accessibility Statement
  • Site Map
  • Contact Us
International Association of Accessibility Professionals (IAAP) Member
Microassist on Facebook
Microassist on Twitter
Microassist on Linked In
Microassist on Youtube
MENU
  • Accessibility Services
    • Accessibility Audits
    • VPAT Consulting Services
    • Accessibility Remediation
    • Accessible PDF and Document Remediation Services
    • Accessible Website and Application Development
    • Accessible Digital Learning
    • Compliance for Digital Learning
    • Accessibility Training
    • Accessibility in the News
    • VPAT Buyers Guide
  • Custom E-Learning
    • Accessible E-Learning
    • Managed Learning Services: Training Support for Business
    • Training Staff Augmentation Services
    • Learning Management System
    • Learning Translation and Localization
    • Examples of Our Work
    • The Learning Dispatch (Blog)
  • Classes
    • Course List
    • Course Schedule
    • Classroom Rental
    • Security Awareness Training
    • Classes FAQ
    • Software Tips (Blog)
  • About
    • Government Solutions
    • Newsletter Subscriptions
    • Career Opportunities
    • News and Media
    • Blogs
    • Team