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.
Placing images into your Excel worksheets can be beneficial for several reasons. For one, doing so can help pair product photos with their inventory descriptions or add employee profile images to their spreadsheet data. Finally, if you want to insert your company’s branding to your worksheets, you can add a level of professionalism to the […]
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.
Working with multiple Excel sheets is common for many spreadsheet users. However, managing and consolidating data across worksheets and workbooks can be tedious and time-consuming without the right techniques. Master these tricks to merge and manipulate Excel sheets like an expert. View Sheets Side-by-Side Rather than constantly switching between tabs, view multiple sheets side-by-side in […]
Data is the foundation of any analysis, decision-making process, or business strategy. However, raw data seldom comes perfectly organized and error-free. That’s where data cleaning and preparation play a crucial role in transforming messy data into valuable insights. Excel, being one of the most widely used tools for data management, offers a host of powerful […]
The XLOOKUP function is relatively new, and it was introduced to provide solutions for some of the issues that commonly occur when using the VLOOKUP and HLOOKUP functions. XLOOKUP serves as a sort of replacement for the other two functions mentioned, so if you can master using the XLOOKUP function, you’re all set when it […]
HLOOKUP is a function that Excel users can key in to look up and retrieve data from a specific row in a table. This function searches for values in the table’s first row, then returns a value in the same column from that row if the listed conditions are met. Read on to discover the […]
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 […]
Serial numbers are an essential part of many datasets because you can use them to identify specific entries in your sheet. Adding them manually can take time and result in errors, but there are several ways you can add these numbers automatically. Save yourself some time at work by learning how to add serial numbers […]
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 […]
VLOOKUP is a relatively common Excel function that aims to simplify locating a specific piece of information located within a spreadsheet. For example, if you have a series of insurance policy numbers and the insured individual’s name listed in various cells, VLOOKUP can help you locate information in a specific column instead of scouring through […]
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 […]
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 […]
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 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 […]
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 […]
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 […]