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.
1683277200
24606
Inserting Images in Excel Worksheets
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 […]
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.
1695904309
26764
Merge and Manipulate Multiple Excel Sheets like a Pro
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 […]
1691142375
25974
Data Cleansing in Excel: Streamlining Your Analysis Workflow
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 […]
1682672400
24273
VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 3: XLOOKUP Formula
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 […]
1682067600
24270
VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 2: HLOOKUP Formula
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 […]
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 […]
1685005200
24845
Automatically Adding Serial Numbers in Excel
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 […]
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 […]
1681465348
24182
VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 1: VLOOKUP Formula
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]