Skip to content

Easy Simple Smart

Digital Products

  • Home
  • Latest Blog Posts
    • Excel
    • Travel
    • Tech Tips
    • WordPress Blogs
    • Power BI
    • Streaming Hardware
    • Google Sheets
    • Books
    • Social Media
    • TV Streaming News
  • Disclosure Policy
  • iOS Apps
    • Alphabet Flash Cards App
    • Numbers Flash Cards App
    • Sight Words Flash Cards App
    • Color Flash Cards App
    • Math Practice Flash Cards App
    • Flash Cards Fun App
    • iOS Apps Privacy Policy
  • Digital Products
    • Excel Task Planner
  • My Favorite Books
  • About Me

Category: Excel

Want to learn Excel in the shortest time possible? Focus just on the essentials. Learn the most effective formulas and features. Fully illustrated Excel tutorials.

5 simple Excel XLOOKUP examples

Posted on February 11, 2020 by Paul
Let's put the new XLOOKUP in Excel to the test with these 5 simple examples. The data below represents a list of serial numbers shipped in boxes to various companies in several countries. For simplicity,...read more
Posted in Excel

How to update Excel 365

Posted on February 11, 2020 by Paul
If you think you may not be running the latest version of Excel as part of the Office 365 subscription, follow he steps below to check and update your desktop version. Note: If you are...read more
Posted in Excel

XLOOKUP Release Date

Posted on February 4, 2020 by Paul
XLOOKUP was announced as a replacement for the iconic VLOOKUP formula in August of 2019. As of February 2020, XLOOKUP is now available to some Office 365 users (see below) but even if you don't...read more
Posted in Excel

How to use multiple conditions in the Excel IF function

Posted on January 19, 2020 by Paul
If you want to use multiple conditions in an IF function in Excel, you have to use the AND or the OR function to evaluate all the conditions (two or more conditions). All conditions evaluated...read more
Posted in ExcelTagged excel, if

COUNT functions in Excel

Posted on December 17, 2019 by Paul
There are a number of COUNT functions in Excel that you can use to count your records. Here are the most used ones: COUNT - count the number of cells in a range that contain...read more
Posted in ExcelTagged count, counta, countblank, countif, countifs

Top 10 Excel websites

Posted on December 4, 2019January 6, 2023 by Paul
Are you looking to improve your Excel skills and become a spreadsheet pro? Look no further! In this blog post, we've compiled a list of the best Excel websites that offer a variety of resources...read more
Posted in ExcelTagged excel websites, top 10

Convert grams to grains

Posted on November 24, 2019 by Paul
Learn how to convert in Excel from grams to grains and vice-versa and how to incorporate the conversion in your spreadsheets. 1 gram = 15.4324 grains and 1 grain = 0.0647989 grams The CONVERT function...read more
Posted in ExcelTagged grams to grains, grans to grams

How to create a dynamic Excel drop down

Posted on November 15, 2019 by Paul
Learn how to create an Excel drop down list the right way. Yes, there is a wrong way and I will show you below. The right way to create a drop down list is to...read more
Posted in Excel

How to get data from web in Excel

Posted on November 13, 2019 by Paul
Did you know that you can get data stored on websites directly into Excel and refresh it with a click of a button? Here's how you do it Before you get into the method, it's...read more
Posted in Excel

How to convert text to date in Excel

Posted on November 5, 2019 by Paul
There are many cases when the data you have in Excel appears to contain dates but when you look closer, the dates are not in a date format. This can be problematic if you need...read more
Posted in Excel
  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • 5
  • Next Page »

Popular Blog Posts

  • How to add numbers in a column in Excel 16.3k views
  • How to use XLOOKUP in Google Sheets 13.7k views
  • How to use VLOOKUP in Excel 12.9k views
  • What is xlookup in Excel 10.8k views
  • How to copy files from WD My Cloud to the attached USB Hard Drive – the fastest way 10.2k views
  • XLOOKUP Release Date 8.8k views
  • 5 simple Excel XLOOKUP examples 8.1k views
  • 10 BEST Excel YouTube Channels 6.2k views
  • 3 easy steps to install Windows 11 on unsupported CPUs 5.1k views
  • 3 ways to take a screenshot on a PC with Windows 10 5k views
@EasySimpleSmart
Disclosure Policy
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
SettingsAccept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT
%d bloggers like this: