Welcome to Learn Excel Now's library containing our how-to articles, guides, video tutorials and more.
Filter by Topic:
Today’s Excel blog post comes directly from a Learn Excel Now customer who was having trouble formatting her spreadsheet. She wanted to hide the extra rows and columns of the spreadsheet grid after creating a chart. Here is what she wrote to Learn Excel Now: “I produce weekly reports for my boss. He likes them […]
Excel’s true power starts with storing and analyzing data but really begins to jump of the page with Charts. Excel charts allow users to graphically represent their data in a meaningful way. Users can easily create and customize charts. With the power of Charts, you can quickly summarize data, compare and track trends over time […]
Learn Excel Now brings you our tip of the week: easily combining Excel charts.
A 3-D formula in Excel can be used to calculate data using multiple worksheets in a workbook. Check out these tips to learn how to create and use 3-D formulas in Excel.
Using Excel in the workplace, or for personal needs, is made much simpler when you know who to use all of the tools and features effectively.
The Pivot Table is one of the most useful features in Excel. Sorting data with Excel Pivot Tables allows you to examine your data from multiple points of view for better summary and analysis. You can sort data, count totals, averages, percentages, etc. In addition to giving you the ability to organize your data, Pivot […]
Excel Dashboards empower you to display your data in interactive and dynamic ways. They give you a comprehensive snapshot of your data and save you the time and energy, because you don’t have to perform your own analysis. They are very customizable and allow you to help steer attention to key trends, comparisons, and exceptions. […]
If you’ve ever wondered why there is an accounting format in Excel when there is already a currency format than you are not alone. Creating excel spreadsheets that contain currency like an income statement or a balance sheet can be difficult to organize. Sometimes the numbers, decimal places and dollar signs do not line up, […]
Cell formatting in Excel allows you to represent your numbers in a variety of ways: as a date, as a percentage, as currency, and with custom formatting, even phone numbers. In today’s quick tip, we are going to show you how to quickly change a number to a percentage in Excel. After entering a number […]
When it come to Excel formatting, there are so many options and tools that it can be a little overwhelming trying to determine what to use and how to use it. Luckily, there are some beginning steps that can help you focus on where to begin. Special Paste In the following article, we will start […]
One of the most common fears of Excel is getting unruly data files and not knowing how to quickly and easily format it to look nice. Here we will go over when and how to auto expand multiple columns in Excel.
Today’s excel tip is very simple but can make a difference when staying organized in excel. If you have more than one worksheet in your workbook, it can get very confusing on which sheet is which when they are all labeled almost the same (sheet 1, sheet 2, sheet 3, etc). Special Paste If you […]
There are a variety of ways to sort and organize your data in Excel. These features allow you to quickly process data to get essential analytics, statistics, trends and other information to inform decision-making. One feature is using Excel tables. Excel Tables are great way to quickly and easily organize and display your data. The […]
An Excel database is a great way to organize your data. It includes a series of records in rows with fields of data entered in columns. Here are some tips to make using Excel as database easier. Organizing Your Data To use Excel as a database, your data has to be structured in a specific […]
In Excel, there are multiple ways to Auto Sum a range of data.
Clean, readable data makes Excel much easier to use. A common struggle is how to remove duplicates in Excel. Having too many duplicates causes inaccuracies in reporting and analyzing data. But scrolling through your data to hunt and peck duplicates is tedious and time-consuming – especially when you have hundreds of rows of data. Even […]
Excel is great for summarizing your data. You can create tables, charts, PivotTables, and more. The following tips are provided to give you the power to do easy data summary in Excel.
Excel has many visual tools built in to help you effectively display your data. With features like themes, tables, and SmartArt, you can easily make your data viewer-friendly. Check out these tips to help you effectively use Excel Visual Tools.
Excel has tons of formulas, functions and features to make calculations for your data. But you can also do basic calculations in Excel without using formulas. Basic calculations in Excel are great for quickly finding the results you need – be it addition, subtraction, multiplication or division – without having to enter any clunky formulas […]
As any user knows, Excel offers a huge variety of formulas and functions for processing calculations. However, searching and finding each one can be time-consuming. The following Excel time-saving formulas will help you quickly process the information you need so you can focus on your work. AutoSum The autosum feature is a great shortcut for […]
Excel financial formulas allows you to quickly and easily process accounting data. Here is a quick guide from Learn Excel Now for using Excel financial formulas.
The pivot table in Excel is one of the most vital and versatile tools available. It allows you to look at your data from a wide range of customizable views. In the following guide, we explore how to update the Pivot Table after the source data changes. There are a variety of reasons you might […]
Excel has several built-in date functions you can use to quickly find important information. These are known as Excel date calculations. Today, we will focus on how to find the difference, in number of days, between two different dates. We will also cover how to find a date based on number of days from a […]
Excel data validation allows you to set specific criteria for the type of data that can be entered into a cell or group of cells. In addition to creating that criteria, you can write a brief message on what can be entered into the cell and error message when the wrong information is entered. In […]
Excel offers many built-in tools to help you perfect your spreadsheets. Some of these tools, however, need to be activated rather than running automatically. Today, we explore one such tool: running spell check in Excel. When most people think Excel, the first thing that comes to mind is numbers. But text is often required in […]
Excel contains tons of built-in tools designed to help you do what you need to. This week we are talking about one of those tools, the robust Find and Replace tool. In the following guide, we will explore how to use this tool and situations where it could be needed. Simple Find Function To find […]
There are many built-in Excel tools to help with data management and the sorting and filtering features are among the best. The filter tool gives you the ability to filter a column of data within a table to isolate the key components you need. The sorting tool allows you to sort by date, number, alphabetic […]
Excel has many tools to help you master the look and feel of your spreadsheet. One feature it offers is the ability to add images to your spreadsheet. It can be an object from clip art, an original photo, downloaded images – as long as it’s in an image file, you can add it to […]
In Excel, you can add a comment to any cell. This could be a note to yourself, a reminder, a correction, a question – anything that is useful. Using Excel comments is particularly useful for workbooks that are used to share information and to collaborate on projects. At times though, you might want to go […]
There are various skills everyone should learn in Excel. One of those skills is protecting an Excel worksheet. Excel allows you to add protection to a worksheet or workbook to prevent other users from making changes to your worksheet. This is particularly useful when you have an Excel workbook that multiple people use at your […]
This week’s Excel tip from Learn Excel Now is on removing duplicates in Excel. The request is directly from a Learn Excel Now fan who asked us how to quickly remove duplicates. She told us: “I pulled a list of all company sales from our database. It exported in Excel. The list is all of […]
Excel provides you with many preset formatting options that you simply need to click to activate. One of the most common and most useful is to set your data as a table. There are many advantages to organizing your data in a table. It makes it easier to sort and filter important data, find totals […]
Excel offers a variety of ways to perform date calculations. In part 1 of this series, we showed you how to find the difference between dates. In this week’s post, we cover setting sequential dates in Excel. Sheryl is getting ready to perform her annual budget. Her job pays her every two weeks. As a […]
One of Excel’s advanced functions is the RANK function. This formula is used to rank numbers in a dataset by either ascending or descending order. Let’s say you were running a customer loyalty program based on earning points. You need to rank customers’ point totals to determine what rewards they receive. You could do a […]
In this week’s Excel tip, we cover how to use the Excel MEDIAN function. The MEDIAN function is used the return the median value within the defined range. For this demonstration, we will use the follow example: The task assigned for this spreadsheet was to find the median sale amount. To do this, we will […]
In this week’s blog post, we cover how to show formulas in Excel. This convenient feature is ideal for identifying which cells contain formulas and what those formulas are. John was recently hired in human resources for a large sales firm. His job is to manage the salaries for the sales, accounting and shipping departments. […]
In last week’s post, we covered how to use Trace Precedents to find and resolve formula errors. In this week’s follow up, we cover how to use trace dependents to see which formulas use the data contained in a particular cell. Donna was recently sent her company’s sales spreadsheet: The commission rate was set to […]
The power of Excel comes from the ability to do complicated calculations using formulas and functions. Sometimes, though, there are errors in formulas that give an error message or return the wrong value. In those instances, Excel also provides tools to resolve errors and check your work. One such tool is trace precedents. The trace […]
Printing with excel is always a challenge. Even excel experts have difficulties printing exactly what they want from their excel spreadsheets. If this is a daily fear or challenge at your workplace this post is for you! Special Paste To make printing excel spreadsheets quick and easy, you can define a print area that includes […]
In this week’s IF statement series, we are covering Nested IF Statements. This convenient formula allows you to return values based on multiple logic tests built into – or nested – in the formula itself. We will explore several uses of nested IF statements in demonstrations below. Syntax of Nested IF Statements When you write […]
IF Statements in Excel are some of the most useful functions you can use. There are a variety of IF functions and each one can be used for a variety of purposes. Over the next few weeks, we will explore the various IF functions, their uses and how to create them. This week, we are […]
There are far too many Excel functions for one person to learn, but there are essential functions every user should know. The MAX and MIN functions are two such functions. The MAX function allows you to find the highest number in given range. The MIN function does the opposite, providing you with the lowest number […]
Excel offers a variety of different formulas and functions for everyday use. This week, we will focus on the MID function. This function allows you to isolate a sub-string of data within a larger string in a new cell. The syntax is simple and straightforward, making it an ideal function for quick tasks. There are […]
In Part 2 (get Part 1 Here) of our IF Statement series, we are discussing simple IF statements. These are the basic formulas for returning a values based on your (the user’s) criteria. These functions can be used for a variety of purposes and the examples below explore some of the potential uses of IF […]