• 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
    • 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
  • Custom Elearning
    • Elearning Philosophy
    • Accessible Elearning
    • 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)
  • Training
    • Course List
    • Course Schedule
    • Classroom Rental
    • Security Awareness Training
    • Training FAQ
    • Software Tips (Blog)
  • About
    • Government Solutions
    • Newsletter Subscriptions
    • Career Opportunities
    • News and Media
    • Blogs
    • Team
  • Open Search Field

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

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

Excel 2013 Tip: Creating a Macro

By Karen Williams  |  June 20, 2017  |    |  43

  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 Macro

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

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

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

READ MORE about Microsoft Excel Tip: Inserting Comments

Excel Tip: Selecting the Entire Worksheet

By Karen Williams  |  January 17, 2017  |    |  15

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 Worksheet

How to Add and Remove Tabs from the Microsoft Office Ribbon

By Karen Williams  |  September 27, 2016  |    |  6

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 Ribbon

Microast Excel 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. 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 Data

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

READ MORE about Excel Tip: Speed up Excel Data Entry by Changing Enter Key Behavior
  • 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 News Updates

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

Recent Posts

  • Training Resources for Veterans and Military Families
  • Six Keys to Building an Accessible PDF Document
  • Microsoft Excel Concatenation Functions – Textjoin, Concat, Ampersand Operator, Concatenation
  • Common PDF Accessibility Mistakes to Avoid
  • Creating Accessible Excel Documents

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

Accessibility in the News

Learning Dispatch (Blog)

Lexis-Nexis Mealey’s® Commentaries

Classroom Course Schedule

Digital Accessibility Blog

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 2021 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
    • 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
  • Custom Elearning
    • Elearning Philosophy
    • Accessible Elearning
    • 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)
  • Training
    • Course List
    • Course Schedule
    • Classroom Rental
    • Security Awareness Training
    • Training FAQ
    • Software Tips (Blog)
  • About
    • Government Solutions
    • Newsletter Subscriptions
    • Career Opportunities
    • News and Media
    • Blogs
    • Team