April 19, 20264 min read
Filtering Data in Excel
Discover the various ways to filter data in Excel and utilize this feature to efficiently organize and analyze your datasets.
Bob Umlas
Bob Umlas
26 articles
Bob Umlas is an instructor who has been using Microsoft Excel since version 0.99 in 1986. Bob has been awarded a Microsoft MVP Award for 25 years running. He is the author of 5 Excel books and has been the Technical Editor for many of Bill Jelen's ("Mr. Excel") books. Bob is an Excel and VBA instructor at NYC Career Centers, a Noble Desktop partner company. He conducts online Excel training and consulting and writing articles on Excel tips & tricks and techniques.
Articles
April 19, 20262 min read
Using the JUSTIFY Command: Reflow Text in Microsoft Excel
Learn how to use the built-in Justify command in Excel to reflow and arrange your text, with examples and step by step instructions.
Bob Umlas
April 19, 20263 min read
Creating Grand Totals in Excel
Explore various formulas to calculate the grand total in an Excel worksheet, discussing alternative methods, the potential for errors, and...
Bob Umlas
April 19, 20268 min read
Number Formatting in Excel
Explore the different ways to effectively format numbers in Excel, including shortcuts, custom categories, and understanding the use of...
Bob Umlas
April 19, 20266 min read
Demystifying VLOOKUP, XLOOKUP
Learn about the unique properties and uses of an Excel table, which offers additional functionalities that can significantly enhance data...
Bob Umlas
April 19, 20264 min read
Cell Styles in Excel: How to Style Cells for Quick & Easy Modification
Discover the time-saving capabilities of cell styles in spreadsheet software, allowing easy formatting adjustments across thousands of...
Bob Umlas
April 19, 20268 min read
Conditional Formatting in Excel
Explore the wide-ranging capabilities of Excel's conditional formatting, including the ability to format cells based on specific...
Bob Umlas
April 19, 20264 min read
Working with Rows & Columns in Excel: How to Hide Them, Show Them, & Change the Height or Width
Discover the various methods to hide, show, and change the dimensions of rows and columns in Excel. This inclusive guide primarily focuses...
Bob Umlas
April 19, 20266 min read
Get Started with UserForms: Create Simple Forms with VBA in Excel
Learn step-by-step how to create a simple UserForm in Excel using VBA coding which allows users to input information into a form that can...
Bob Umlas
April 19, 20266 min read
Using Excel Tables
Learn how to manage and utilize Excel Tables more effectively with this comprehensive guide, covering everything from creating tables and...
Bob Umlas
April 19, 20264 min read
How to Set a Picture as a Background in Excel: Using the Page Layout Tab to Add Graphics to Your Sheets
Continue your understanding of Excel's Page Layout tab with insights into the "Background" and "Print Titles" commands, where you can...
Bob Umlas
April 19, 20265 min read
How to Add Headers & Footers in Excel: More Fun with Excel's Page Layout Tab
Explore the detailed guide to understanding the Page Layout tab and other features in Excel, along with a step-by-step explanation on...
Bob Umlas
April 19, 20263 min read
Collection of Excel Tips and Tricks, Part 1
Explore this comprehensive guide for insightful Excel tips and tricks to enhance your productivity, ranging from simple shortcut keys to...
Bob Umlas
April 19, 20265 min read
Data Validation in Excel
Explore how to use data validation to set restrictions on cell entries, alert users, and prevent incorrect values from entering your data...
Bob Umlas
April 19, 20264 min read
Cell Referencing
Improve your understanding of Excel's cell referencing system, including the use and implications of absolute and mixed cell references and...
Bob Umlas
April 19, 20264 min read
Using Shortcut Keys in Excel
Enhance your proficiency with practical key combinations that facilitate various operations such as opening, closing, saving workbooks,...
Bob Umlas
April 19, 20263 min read
Combining & Filtering Data from Multiple Worksheets
Learn how to combine data from two different sources with varying column arrangements and use formulas to filter and manipulate the data to...
Bob Umlas
April 19, 20264 min read
Working with Shapes in Excel
Dive into the intricacies of shape manipulation in digital drawing, from rotating and formatting shapes to working with Z-order and...
Bob Umlas
April 19, 20265 min read
Advanced Filtering in Excel
Learn how to use Excel's Advanced Filter to handle more complex filtering operations such as filtering based on relationships between...
Bob Umlas
April 19, 20264 min read
Introduction to Excel’s Page Layout Tab: Setting Margins, Page Orientation, Size, Print Area, & Breaks in Excel
Explore an in-depth guide on how to navigate the Page Layout tab in Microsoft Excel, covering commands such as Margins, Orientation, Size,...
Bob Umlas
April 19, 20264 min read
Collection of Excel Tips and Tricks, Part 2
Discover various tips and tricks for Excel that can enhance your efficiency, including how to put totals in certain cells, best formulas...
Bob Umlas
April 19, 20265 min read
Making Magic Dynamic Arrays
Unveil the power of Excel's new feature, the dynamic array functions, which includes SORT, FILTER, UNIQUE, SORTBY, and RANDARRAY, to create...
Bob Umlas
April 19, 20265 min read
How to Separate First & Last Names in Excel: Move Names to Individual Cells
Explore four methods to separate first and last names in Excel including using formulas, Text-to-Columns, Flash Fill, and new functions...
Bob Umlas
April 19, 20263 min read
Rearranging Data with New Functions in Excel
In this article, we’ll explore these new functions: TOCOL, TOROW, WRAPCOLS, WRAPROWS, CHOOSECOLS, and CHOOSEROWS.
Bob Umlas