Wouldn’t it be great if you could identify the subtotals in your worksheets so that you can find them easily? With the technique in this section, you can.
Author: BrainBell
Categories
Insert Subtotals For a Range of Data
In this tutorial, we will use Excel’s subtotal capability to create subtotal values for the sorted categories. You can quickly create subtotals by using the Subtotal command on the Data tab. This command inserts subtotals for each group of data in your worksheet, based on a column that you specify.
Categories
Cannot Save or Export XML Data
If you are working with XML data in Excel, you might encounter a situation where you cannot save or export your data as an XML file. This can happen if the XML maps in your workbook are not exportable. In this tutorial, we will explain what causes this issue and how to fix it.
Categories
Save or Export Data as an XML File
Excel supports importing and exporting data as XML files, which can be useful for sharing data with other applications. In this tutorial, we will show you how to export data as an XML file in Excel using the following steps:
In PowerPoint, you can easily format the background for a single slide. This allows you to customize the background of that specific slide without affecting the rest of the presentation.
A network is a collection of devices that can communicate with each other using a common protocol (e.g. TCP/IP). A network can be classified as public or private depending on who can access it and how it is managed. In this tutorial, we will also explain the difference between public and private IP addresses, and why they are important for networking.
Categories
Create Custom Number Formats
Excel comes with built-in number formats, but sometimes you need to use a number format that is not built into Excel. The term number does not refer exclusively to custom formats for numeric data. You can also use number formats for text data.
Using advanced filter you can filter a range of data based on complex criteria. It provides more powerful filtering options than the regular filter (Autofilter) feature. Here’s how to use Advanced Filter:
Categories
Filter (AutoFilter) Data
When you want to view only those records that have specific data in certain cells, you should filter the data range.
Categories
Random Sort using Rand() Function
The RAND function is a volatile function, you can use this volatility to your benefit and record a macro that sorts data immediately after you recalculate and force the RAND function to return another set of random numbers. You then can attach this macro to a button so that each time you want to shuffle (random sort) data, all you need to do is click the button.