Advanced Excel

Excel Shapes

Excel Shapes: Knowledge Hub Inert Shape in Excel Align Shapes in Excel Excel VBA Shape Position << Go Back to Learn Excel

Data Entry in Excel (Basic, Form Creation & Error Handling)

In this article, we are going to learn about data entry in Excel. We will learn about the basics of data entry, form creation, and error handling. ...

Text Box in Excel – A Complete Overview

The sample dataset contains sales of different accessories in different locations. The text box below showcases a summary of the dataset, displaying ...

Mail Merge in Excel – Purposes, Procedure, Uses & Limitations

Mail Merge is a powerful feature in Microsoft Word that allows you to personalize and send the same document (such as emails or letters) to multiple ...

Excel Drop-Down Lists: Create, Edit, Remove, Filter, Protect

  The dataset showcases online shopping information: ‘Order ID’, ‘Customer Name’, ‘Device’, ‘Order Date’, ‘Delivery date’, and ‘Payment ...

Database in Excel: Definition, Types, Creation, Free Templates

Database in Excel means gathering and arranging information on individuals, products, demands, transactions, etc. In this Excel tutorial, you will ...

Progress Bar in Excel

Progress Bar in Excel: Knowledge Hub Create a Progress Bar in Excel Show Percentage Progress Bar in Excel Progress Bar Based on Another ...

Data Validation in Excel: A Complete Guideline

In this tutorial, you will learn everything about Data Validation from its purpose to how to apply it in your Excel worksheet. In the image ...

How to Copy Conditional Formatting in Excel

Copy Conditional Formatting in Excel: Knowledge Hub Copy Conditional Formatting to Another Cell Copy Conditional Formatting Color to Another ...

WordArt in Excel

WordArt in Excel: Knowledge Hub How to Insert WordArt in Excel << Go Back to Learn Excel

Advanced Excel Topics

1. Advanced Excel Formulas SUMIFS SUMPRODUCT VLOOKUP & XLOOKUP INDEX + MATCH Handling Excel Formula Errors Dynamic Array Formulas ...

How to Export Data from Excel to Doc, PDF, CSV, XML, vCard

This is an overview.   1. Using the “Save As” Command to Export Excel Data to Text or CSV File This is the sample dataset. To ...

How to Make Periodic Table in Excel: 2 Easy Ways

Method 1 - Manual Periodic Table 1.1. Insert Data in Properties Table Each element of a periodic table has a unique set of properties. These ...

How to Insert the Excel Tooltip on Hover – 3 Examples

The image below showcases the Excel tooltip on hover. Using the Excel Tooltip You can use the tooltip to: Input Data Explain Data ...

How to Statistically Analyze Data in Excel (5 Ways)

  Method 1 - Calculating Central Tendency and Variability The above dataset marks of 7th-grade students are given based on Math, History, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo