Advanced Excel

Difference Between Protect Sheet and Protect Workbook in MS Excel

  What Are Protect Sheet and Protect Workbook in Excel? In Microsoft Excel, the feature that prevents other users from accidentally or ...

3D Referencing & External Reference in Excel

What Is 3D Referencing in Excel? In Excel, you can use the 3D reference feature to select the same cell from multiple worksheets. By simply ...

How to Reference Excel Tables Using VBA (20 Examples)

Reference a Table with ListObject Property When writing VBA code, ListObjects are essential for referring to Excel tables. These tables can be ...

How to Make Excel Tables Look Good (8 Effective Tips)

How to Create an Excel Table Steps: Select a cell from the data set. Go to the Insert tab and choose Table. Excel will ...

How to Modify Theme Color, Font, & Effects & Create Custom Excel Theme

Excel has themes, which have different default colors, auto shape effects, SmartArt effects, and fonts. When utilizing themes one can quickly change ...

How to Use Different Types of COUNT Functions in Excel?

Method 1 -Using COUNT Function to Count Cell Numbers The syntax for the COUNT function is: Steps: To count only the number of jobs in ...

Creating Email Addresses from a Single Column with Flash Fill, TEXT Formulas & Commentator’s Text Formula Suggestions

Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. ...

Navigating Excel Table (7 Simple Techniques)

Navigating an Excel table is just like navigating within a worksheet. You can use a mouse or you can use the keyboard to navigate within a table. In ...

How to Insert or Delete Rows and Columns from Excel Table

The Table is a wonderful feature of Excel. A table contains a group of data and we can use those data combinedly and perform any operation on the ...

How to Remove Duplicate Rows in Excel Table

This post will deal with imposters! No, I mean table duplicate entries. We will be able to manage them, remove them, tame them according to our ...

How to Use Sort and Filter with Excel Table (4 Suitable Ways)

When you have a large table as a dataset then most of the time, you may need to Sort and Filter in Excel. In this post, I will discuss how you can ...

How to Use Wildcards in Excel (4 Easy Methods)

In this article, we will demonstrate how to use wildcards in Excel. Wildcard characters such as the asterisk "*", question mark "?" and tilde "~" ...

How to Get Unique Values in Excel (5 Easy Ways)

The sample dataset contains 200 rows of data with 5 columns. Method 1 - Using Advanced Filter Excel Advanced filter helps you to extract ...

How to Convert Text to Columns in Excel (3 Cases)

In this article, we will demonstrate 3 practical uses of Excel's Text to Columns feature: splitting the columns of a table in various ways, ...

How to Enter Date and Time in Excel: 8 Quick Methods

Method 1 - Keyboard Shortcuts to Enter Current Date & Time in Excel Steps: Enter the date, and select cell B5. Hold the Ctrl (control) ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo