2020-05-06 17:07
Using multiple worksheets in an Excel workbook is an easy way to keep your data organized. For example, you can have different sheets for different regions, or for different months/year, or… Read More
Blog Directory > Business Blogs > TrumpExcel.com business Blog >
Trumpexcel.com Blog
trumpexcel.com
Tags:
excel
rename
sumifs
columns
error
average annual
print multiple sheets
print excel sheet
worksheets
print multiple
TrumpExcel provides online training on Microsoft Excel. Here you can find easy how-to tutorials and videos on various topics such as Dashboard, Pivot Table, Formulas, Data analysis, Charting, and VBA.
2020-05-05 22:09
If you often print your data/work in Excel, I am sure you have faced the issue where it prints multiple pages instead of one single page. Sometimes, it’s so frustrating that a new page… Read More
2020-05-05 17:16
Apart from using Excel with numeric data, a lot of people also use it with text data. It could as simple as keeping a record of names to something more complex. When working with text data… Read More
2020-04-27 17:40
If you have worked with formulas in Excel for some time, I am sure you have already met the #REF! Error (reference error). Since this is quite common, I thought of writing a tutorial just to… Read More
2020-04-26 20:05
Comments are quite useful when you want to add some information about a cell/data point without changing the content of the cell. I often use these when I am using formulas and I need to spe… Read More
2020-04-18 08:39
When working with multiple worksheets in Excel, sometimes you may have a need to edit the same cell in all the worksheets (or apply certain formatting the same cell/range in all the sheets)… Read More
2020-04-12 13:20
With financial data, you would often see the use of two metrics – Average Annual Growth Rate (AAGR) and Compound Annual Growth Rate (CAGR). While there are some existing formulas in Ex… Read More
2020-04-01 01:55
When you’re working with datasets that have dates, you would often find yourself trying to do calculations based on the dates. For example, if you have the sales data for a month, you… Read More
2020-03-27 12:18
Excel gives you a lot of options when you’re trying to print your work. You can choose to print the entire worksheet, a specific area in the worksheet, print multiple sheets, or all sh… Read More
2020-03-25 12:14
Adding or removing columns in Excel in a common task when you’re working with data in Excel. And just like every other thing in Excel, there are multiple ways to insert columns as well… Read More
2020-03-11 10:58
When you represent data in a chart, there can be cases when there is a level of variability with a data point. For example, you can not (with 100% certainty) predict the temperature of the n… Read More
2020-02-24 13:08
If you work with data that is imported from databases or salesforce, you’ve probably already dealt with line breaks. A line break is something that allows you to have multiple lines in… Read More
2020-02-18 14:04
While Excel has been continuously improved with each new version, there are still times when you may find it crashing once in a while (especially if you’re working with a large dataset… Read More
2020-02-17 10:52
Adding and deleting rows is part of everyday common tasks when working with Excel. While you can do this easily from the worksheet itself, sometimes you may want to use the VBA route to dele… Read More
2020-02-12 09:12
Office 365 brings with some awesome functions – such as XLOOKUP, SORT, and FILTER. When it comes to filtering data in Excel, in the pre-Office 365 world, we were mostly dependent on Ex… Read More
2020-02-10 12:35
Watch video – Save Excel Charts as Images/Pictures Excel has a lot of useful in-built charts and you can also combine and create some amazing combination charts as well. Excel charts a… Read More
2020-02-06 14:15
Excel XLOOKUP function has finally arrived. If you have been using VLOOKUP or INDEX/MATCH, I am sure you’ll love the flexibility that the XLOOKUP function provides. In this tutorial, I… Read More
2020-02-01 03:53
Excel Table is an amazing feature that makes working with data a lot easier. And as more advanced tools such as Powe Query and Power Pivot now rely on Excel tables to be the data source, Exc… Read More
2020-01-23 11:30
Comparing two Excel files (or comparing two sheets in the same file) can be tricky as an Excel workbook only shows one sheet at a time. This becomes more difficult and error-prone when you h… Read More
2020-01-14 10:23
If you manage multiple projects, you would have a need to know how many months have passed between two dates. Or, if you’re in the planning phase, you may need to know the same for the… Read More
2020-01-11 13:44
If you work with names datasets, sorting it is one of the common tasks you would have to do often. It’s quite easy to sort data alphabetically based on the full name, where Excel uses… Read More
2020-01-01 17:41
Excel has some really smart features that can be really useful in many cases (and sometimes it could be frustrating). One such area is when you enter numbers in Excel. Sometimes, Excel autom… Read More
2019-12-17 17:29
Most of the people who work with Excel spreadsheets deal with numbers in large/small datasets. And when you work with numbers, you will have all types of it (positive, negative, decimals, da… Read More
2019-12-16 05:33
In Excel, you can easily remove cell formatting with a few clicks (or a keyboard shortcut). You can also copy-paste formatting from one cell/range to the other. Or, you can choose to clear t… Read More
2019-12-05 10:05
It’s amazing how you can find multiple ways to do the same thing in Excel. After all, there are so many awesome functionalities and functions. A really simple and often needed task is… Read More
2019-12-04 17:17
By default, date and time are saved as numbers/decimals in Excel. But you often see it in different formats because of the way the cells have been formatted. For example, in the below exampl… Read More
2019-11-28 09:12
Excel allows you to display data in many different formats. And there are way too many to choose from when it comes to dates and time data in Excel. And since there are so many formats, ther… Read More
2019-11-26 09:56
While there are many different ways to run a macro in Excel, none of those methods can be as easy and user-friendly as clicking on a button. And for that to work, you need to assign a macro… Read More
2019-11-21 06:47
Working with text data would often require slicing and dicing it. And one such common thing people often have to do is to remove the first characters from a string in Excel. Suppose you have… Read More
2019-11-12 05:06
To be able to reference cells and ranges is what makes any spreadsheet tool work. And Excel is the best and most powerful one out there. In this tutorial, I will cover all that you need to k… Read More
2019-11-08 14:48
Watch Video – How to Split Each Excel Sheet Into Separate Files If you have an Excel workbook with many worksheets, there is no easy way to split each of these sheets into separate Exc… Read More
2019-11-02 02:53
To get the sum of an entire column is something most of us have to do quite often. For example, if you have the sales data to date, you may want to quickly know the total sum in the column t… Read More
2019-10-19 14:40
Watch Video – Insert Blank Row After Every Row in Excel People who work with large data sets often need simple things such as inserting/deleting rows or columns. While there are alread… Read More
2019-10-03 10:57
Like many of my Excel tutorials, this one is also inspired by one of the queries I got from a friend. She wanted to calculate the moving average in Excel, and I asked her to search for it on… Read More
2019-09-26 11:02
‘Immediate window’ can be a useful tool to use when working with VBA in Excel. The Immediate window allows you to quickly do things such as: Get information about Excel files (su… Read More
2019-09-21 07:51
Excel is an amazing tool when it comes to slicing and dicing text data. There are so many useful formulas as well as functionalities you can use to work with text data in Excel. One of the v… Read More
2019-09-14 08:45
Watch Video – How to Unhide All Sheets In Excel In case you prefer reading a tutorial over watching a video, below is a detailed written tutorial on unhiding sheets in Excel. When you… Read More
2019-08-26 17:13
Watch Video – How to Hide Zero Values in Excel + How to Remove Zero Values In case you prefer reading over watching a video, below is the complete written tutorial. Sometimes in Excel… Read More
2019-08-19 02:16
Sometimes you may have a need to delete every other row (i.e., alternate rows), or every third/fourth/fifth row in Excel. One use-case of this could be when you have weekly data and you only… Read More
2019-08-04 00:37
When you enter a text string in Excel which exceeds the width of the cell, you can see the text overflowing to the adjacent cell(s). Below is an example where I have some address in column A… Read More
2019-07-30 17:23
When working with large data sets, you may have the need to quickly delete rows based on the cell values in it (or based on a condition). For example, consider the following examples: You ha… Read More
2019-07-03 09:52
Want some Excel files to open automatically when you start Excel? These could be files the that you open every day in the morning (such as tracking sheet or timesheet), or some project relat… Read More
2019-06-27 08:48
Sorting data in Excel has been made quite easy with all the in-built options. You can easily sort your data alphabetically, based on the value in the cells, or by cell and font color. You ca… Read More
2019-05-29 10:33
Excel has a variety of in-built charts that can be used to visualize data. And creating these charts in Excel only takes a few clicks. Among all these Excel chart types, there has been one t… Read More
2019-05-20 09:22
Excel Pivot Tables are amazing (I know I mention this every time I write about Pivot Tables, but it’s true). With a basic understanding and a little drag and drop, you can get a bucket… Read More
2019-04-13 08:33
Pivot Table is one of the best features in Excel. You don’t need to know any formula or coding to quickly crunch thousands of rows of data and create quick summaries out of it. All you… Read More
2019-04-08 10:58
Excel has a lot of options when it comes to sorting data. And one of those options allows you to sort your data based on the color of the cell. For example, in the below dataset, you can sor… Read More
2019-03-27 09:02
Excel charts allow you to do a lot of customizations that help in representing the data in the best possible way. And one such example of customization is the ease with which you can add a s… Read More
2019-03-18 15:11
Excel allows having hyperlinks in cells which you can use to directly go to that URL. For example, below is a list where I have company names which are hyperlinked to the company website&rsq&hell…Read More
2019-03-07 08:52
Hidden rows and columns can be quite irritating at times. Especially if someone else has hidden these and you forget to unhide it (or even worse, you don’t know how to unhide these). W… Read More
2019-03-06 09:01
Excel has a lot of functions – about 450+ of them. And many of these are simply awesome. The amount of work you can get done with a few formulas still surprises me (even after having u… Read More
2019-02-22 14:21
Looking to recover unsaved Excel file, click here to jump to all the possible options you have to get the file back. Let me tell you the shortest horror story ever. Excel Crashed! Imagine wo… Read More
2019-02-01 14:16
In Excel, there are two kinds of tick marks (✓) that you can insert – a check mark and a checkbox. And no… these are not the same. Let me explain. Check Mark Vs Check Box… Read More
2019-01-21 08:49
No matter how experienced you’re with VBA coding, errors are always going to be a part of it. The difference between a novice and an expert VBA programmer is that the expert programmer… Read More
2019-01-09 18:05
A trendline, as the name suggests, is a line that shows the trend. You’ll find it in many charts where the overall intent is to see the trend that emerges from the existing data. For e… Read More
2018-11-15 10:47
The first step to working with VBA in Excel is to get yourself familiarized with the Visual Basic Editor (also called the VBA Editor or VB Editor). In this tutorial, I will cover all there i… Read More
2018-10-27 16:46
When we use VBA in Excel, most of it is to automate our tasks. This also means that most of the time, we work with cells and ranges, worksheets, workbooks, and other objects which are a part… Read More
2018-10-25 09:16
What happens when you type the word ‘Drnik’ instead of ‘Drink’ in Excel? You would notice that Excel will autocorrect that misspelled word to Drink (as shown bel… Read More
2018-10-20 07:09
VBA has some useful functions that can take your automation in Excel to the next level. One such function is the VBA DIR function. While by itself, it may seem like a simple function that do… Read More
2018-10-17 09:54
If you work with a lot of worksheets in Excel, you would know the management of it can become an issue. Once you have more than a couple of worksheets, you need to manually arrange these. Ho… Read More
2018-10-16 08:54
When it comes to inserting symbols in Excel, things can get a bit complicated. You either need to know the keyboard shortcut, or use the methods that are not very straightforward. And there… Read More
2018-10-12 09:40
Excel VBA has the IF Then Else construct that you can use to analyze multiple conditions and execute codes based on these conditions. Another similar construct that allows you to check for m… Read More
2018-10-09 10:35
In Excel VBA, you would often be required to use variables and constants. When working with VBA, a variable is a location in your computer’s memory where you can store data. The type o… Read More
2018-09-18 09:03
Excel workbooks have been known to become painfully slow and heavy as more data/formulas/images are added to it. Sometimes, it’s easy to get rid of the extra flab and keep the excel fi… Read More
2018-09-05 10:22
In Excel worksheet, the UPPER function converts all the lowercase characters of a text string into uppercase. There is a similar function in that also does the same – the&nbs&hell…Read More
2018-09-05 09:01
In Excel worksheet, there is a LOWER function that converts a text string into lower case. Just like the LOWER function, there is a similar inbuilt function in Excel VBA – LCASE The VB… Read More
2018-09-04 08:32
Sometimes when working with data in Excel, you may have a need to move rows and columns in the dataset. For example, in the below dataset, I want to quickly move the highlighted row to the t… Read More
2018-09-04 04:31
Excel already has a TRIM worksheet function that you can use to get rid of leading, trailing, and extra spaces in between words/strings. There is a TRIM function in VBA as well (and it does… Read More
2018-08-30 06:11
An area chart is similar to a line chart with one difference – the area below the line is filled with a color. Both – a line chart and an area chart – show a trend over tim… Read More
2018-08-28 10:16
A lot of Excel functionalities are also available to be used in VBA – and the Autofilter method is one such functionality. If you have a dataset and you want to filter it usi… Read More
2018-08-20 11:18
Video – Search and Highlight Data Using Conditional Formatting If you work with large datasets, there can be a need to create a search functionality that allows you to quickly highligh… Read More
2018-08-20 05:04
Conditional Formatting allows you to format a cell (or a range of cells) based on the value in it. But sometimes, instead of just getting the cell highlighted, you may want to high… Read More
2018-08-18 08:25
A histogram is a common data analysis tool in the business world. It’s a column chart that shows the frequency of the occurrence of a variable in the specified range. According to Inve… Read More
2018-08-13 04:35
The one query that I get a lot is – ‘how to compare two columns in Excel?'. This can be done in many different ways, and the method to use will depend on the data structure and w… Read More
2018-08-06 08:44
Excel has many useful features when it comes to data entry. And one such feature is Data Entry Form. Why Do You Need to Know About Data Entry Forms? Maybe you don't! But if data entry is a p… Read More
2018-07-27 12:26
In Excel VBA, you can use the MsgBox function to display a message box (as shown below): A MsgBox is nothing but a dialog box that you can use to inform your users by showing a custom messag… Read More
2018-07-25 11:00
With Power Query, working with data dispersed across worksheets or even workbooks has become easier. One of the things where Power Query can save you a lot of time is when you have to merge… Read More
2018-07-13 10:45
While Excel is mostly used for data entry and analysis, it also has some great chart types that you can use to make your reports/dashboards better. Apart from the default charts that are ava… Read More
2018-06-30 18:28
I recently got a question from a reader about combining multiple worksheets in the same workbook into one single worksheet. I asked him to use Power Query to combine different sheets, but th… Read More
2018-06-06 11:41
Sparklines feature was introduced in Excel 2010. In this article, you'll learn all about Excel Sparklines and see some useful examples of it. What are Sparklines? Sparklines are tiny charts… Read More
2018-05-17 19:42
When working with VBA in Excel, you may have a need to split a string into different parts based on a delimiter. For example, if you have an address, you can use the VBA Split function to ge… Read More
2018-05-12 08:38
In this tutorial, you'll learn how to find the last occurrence of an item in a list using Excel formulas. Recently, I was working on setting the agenda for a meeting. I had a list in Excel w… Read More
2018-05-11 05:29
Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs. For someth… Read More
2018-05-11 05:29
Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs. For someth… Read More
2018-04-27 07:40
When you create or record a macro in Excel, you need to run the macro to execute the steps in the code. A few ways of running a macro includes using the macro dialog box, assigning the… Read More
2018-04-25 02:50
I recently had to get myself a Goods and Services Tax (GST) registration so that I can tax on my earnings. Once you have a GST number, you need to file your tax return every month. So every… Read More
2018-04-13 10:27
With VBA, you can create a custom Function (also called a User Defined Function) that can be used in the worksheets just like regular functions. These are helpful when the existing Excel fun… Read More
2018-04-05 06:27
In this tutorial, I will cover the how to work with workbooks in Excel using VBA. In Excel, a ‘Workbook' is an object that is a part of the ‘Workbooks' collection. Within a workb… Read More
2018-04-03 03:05
Apart from cells and ranges, working with worksheets is another area you should know about to use VBA efficiently in Excel. Just like any object in VBA, worksheets have different p… Read More
2018-03-23 04:30
When working with Excel, most of your time is spent in the worksheet area – dealing with cells and ranges. And if you want to automate your work in Excel using VBA, you need to know ho… Read More
2018-03-16 18:47
A few days ago, I was working on a project where I had to extract some tables/data from PDF to Excel. Now, this is not the first time I have been stuck in such a situation. In the past, I ha… Read More
2018-03-12 07:43
Even if you're a complete newbie to the world of Excel VBA, you can easily record a macro and automate some of your work. In this detailed guide, I will cover all that you need to know to ge… Read More
2018-02-26 09:57
In Excel VBA, IF Then Else statement allows you to check for a condition, and perform an action accordingly. This is extremely valuable in many situations as we will see in the examples late… Read More
2018-02-19 10:52
To get the most out of Excel and VBA, you need to know how to use loops efficiently. In VBA, loops allow you to go through a set of objects/values and analyze it one by one. You can also per… Read More
2018-02-15 06:09
Pivot Tables are great when you want to analyze a huge amount of data in seconds. It also allows you to quickly create different views of data by simply dragging and dropping. And to create… Read More
2018-01-30 08:57
One of my friends works in a healthcare analytics company. He often connects with me on some of the real-life issues he faces while working with data in Excel. A lot of times, I convert his… Read More
2018-01-15 07:33
Power Query can be of great help when you want to combine multiple workbooks into one single workbook. For example, suppose you have the sales data for different regions (East, West, North… Read More
2018-01-04 09:16
Last few weeks have been really hectic for me at work. Weekdays are crazy and the weekends are never enough. Early this week, I was going through our annual holiday calendar to check fo… Read More
2017-12-20 07:53
A few days ago I was working with a dataset where I had multiple sheets full of data. I had to select the first 500 cells at one go from each worksheet and copy it. I then had to p… Read More
2017-12-15 04:36
Some time ago I wrote an Excel Tutorial about getting a list of file names from a folder in Excel. In that tutorial, I showed various ways to get the list of file names from a fold… Read More
Subscribe to Trumpexcel.com
Get updates delivered right to your inbox!