Welcome to Learn Excel Now's library containing our how-to articles, guides, video tutorials and more.
Filter by Topic:
1472035758
826
Excel Formatting Essentials: Hiding Extra Rows & Columns
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 […]
1459335567
488
Excel Charts: Quick Tips for Getting Started
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 […]
1447243210
133
Creating 3-D Formulas in Excels for Multiple Worksheets
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.
1449662401
150
Excel Conditional Formatting: Quick Tips to Get Started
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.
1457521252
455
Sorting Data with Excel Pivot Tables
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 […]
1456921186
432
Excel Dashboards: Your Guide to Getting Started
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. […]
1456308526
412
Converting Numbers into Accounting in Excel
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, […]
1455117407
390
Converting Numbers to Percentage in Excel
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 […]
1453291256
313
Getting Starting with Excel Formatting
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 […]
1450267239
30
Auto Expand Multiple Columns in Excel
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.
1452632145
282
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 […]
1454500858
360
Excel Analytics: Creating Tables for Your data
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 […]
1451476830
278
Excel Database Tips: Keys to Organizing Your Data
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 […]
1447848013
188
Using Auto Calculations for Multiple Tasks – Video
In Excel, there are multiple ways to Auto Sum a range of data.
1459939697
502
Excel Essentials: How to Remove Duplicates in Excel – Video
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 […]
1450908729
153
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.
1446638439
135
Tips and Tricks for Using Visual Tools 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.
1455710432
395
Basic Calculations in Excel: How to Quickly Find the Answers You Need – Video
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 […]
1452706658
300
Excel Time-Saving Formulas: Quick & Easy Tricks to Work More Efficiently
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 […]
1446033646
139
Excel Financial Formulas Quick Guide
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.
1678438800
23032
10 Reasons to Use Excel Tables
Excel tables come with a variety of features that make data recording and management a breeze. Instead of handling your data processes manually, save time and take steps to ensure accuracy by using Excel to your advantage. Read on to learn about 10 beneficial features that make Excel worth a try. Excel is designed to […]
1485949213
1022
Excel Pivot Table Tips: Refreshing the Table After Source Data Changes
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 […]
1481714468
994
Excel Date Calculations Part 1: Finding the Difference Between Two Dates
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 […]
1481127290
988
Excel Data Validation: An Introduction
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 […]
1475662221
916
Excel Essentials: Running Spell Check in Excel
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 […]
1473243912
859
Excel Find & Replace: Building Fundamental Skills
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 […]
1475059213
901
Excel Essentials: Adding Images to a Spreadsheet
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 […]
1471421182
814
Essential Excel Skills: Protecting an Excel Worksheet
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 […]
1466601905
672
Removing Duplicates in Excel: Quick How-to Guide
This 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 our […]
1465987718
659
Creating Excel Tables: Quick Tip to Get Up-to-Speed
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 […]
1677747600
22978
Reviewing Formulas and Functions Part 3: COUNT in Excel
Most working professionals want to save time when writing reports and copying data into spreadsheets, yet worrying about making mistakes can slow progress to a crawl. If you want to save time and make sure you’re recording accurate data, mastering a few Excel formulas is worth your effort. Read on to learn about the COUNT […]
1677142800
22749
Reviewing Formulas and Functions Part 2: AVERAGE in Excel
Learning a selection of Excel formulas can take your reports to the next level. Mastering a few tips and tricks can not only save time for working professionals but using Excel formulas can help double-check the values listed on a spreadsheet. To simplify your work and make sure you’re presenting accurate data, take a look […]
1676538000
22365
Reviewing Formulas and Functions Part 1: SUM in Excel
Mastering Excel formulas can make a world of difference for working professionals. Not only does using formulas save time, but it also ensures that the figures you’re calculating are correct based on the data in your spreadsheet. Read on and we’ll show you how to use the SUM formula correctly. SUM in Excel The SUM […]
1675871401
22328
Creating Basic Formulas Part 3: Division
Excel formulas can simplify the essential mathematical operations of addition, subtraction, multiplication, and division. In Part 2 of this series, we covered creating basic multiplication formulas in Excel. To finish this series, we’ll tackle how to divide with the program. Division Formula Division has the same capabilities as addition and multiplication. To divide cells, you […]
1671789141
21259
Creating Basic Formulas Part 2: Multiplication
Addition, subtraction, multiplication, and division are essential mathematical functions that can be made easy by using Excel formulas. In Part 1 of this series, we covered creating basic addition and subtraction formulas in Excel. This week we’ll tackle how to multiply with the program. Multiplication Formula Like adding and subtracting, multiplying cells can be done by […]
1671105752
21134
Creating Basic Formulas Part 1: Addition and Subtraction
Excel can be intimidating for people who have just been introduced to the program, but basic mathematical functions are relatively easy through Excel when you know the right formulas. To begin, we’ll just cover the basic formulas for now: Addition, Subtraction, Multiplication, and Division. Let’s begin with Addition and Subtraction. Addition Formula The basic way […]
1453896017
342
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 […]
1661169123
19352
Excel Basics: How To Separate Text Into Columns
Do you have a list of data that you need to separate into columns in Excel? Maybe you have an address list with the city, state, and zip code all in one column. Or maybe you have a list of product SKUs and want to separate them into individual columns. Well, before you can start […]
1664463871
20105
Excel UNIQUE Function: Explained in 4 Minutes
The Excel UNIQUE function returns a list of unique values in a list or range. Note: This function is currently available only to Microsoft 365 subscribers. To follow along, and for future reference or practice, the file Mike is working from can be found here. The formula in this video: =UNIQUE(B2:B19) The tutorial in this video […]
1480507647
973
Excel Rank Function: What is It & How to Use It
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 […]
1478690152
964
How to Use the Excel MEDIAN Function
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 […]
1472639602
841
Excel Basics: Adding, Editing & Formatting Comments
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 […]