Skip to content

Easy Simple Smart

  • Excel
  • Books that will change your life
  • Tech Tips
  • Power BI
  • Google Sheets

Convert kg to lbs

Posted on September 20, 2019November 13, 2021 by Paul
Learn how to convert in Excel from kb to lbs and how to incorporate in your spreadsheets. You will learn two methods. By using a direct calculation or by using a formula. 1 kg =...read more
Posted in ExcelTagged kg to lbs, lbs to kg

Conditional Formatting Columns in SharePoint

Posted on September 19, 2019November 13, 2021 by Paul
When working with SharePoint lists there are cases when you need to create a better visualization of data by using Conditional Formatting. Some of these cases would be to make overdue items in red or...read more
Posted in Tech TipsTagged conditional formatting, sharepoint

How to use XLOOKUP in Google Sheets

Posted on September 18, 2019November 13, 2021 by Paul
XLOOKUP may be a new function to Excel but it is not new to spreadsheet software. Google Sheets already has the LOOKUP function that works exactly like Excel's XLOOKUP. What about Excel's XLOOKUP support for...read more
Posted in Excel, Google SheetsTagged vlookup, xlookup

What is xlookup in Excel

Posted on September 18, 2019November 13, 2021 by Paul
XLOOKUP is the newest addition to the lookup formulas in Excel. If VLOOKUP is a Vertical lookup function and HLOOKUP is a Horizontal lookup function, XLOOKUP is capable of replacing them both by performing the...read more
Posted in ExcelTagged excel, hlookup, vlookup, xlookup

How to Make a Word Search Puzzle in Excel (or Google Sheets)

Posted on September 18, 2019November 13, 2021 by Paul
In this tutorial you'll learn how to make a printable word search that you can use as activity for children. This is a very simple method that you can use for free and you can...read more
Posted in Excel, Google Sheets

Google Sheets edit history

Posted on September 17, 2019November 13, 2021 by Paul
How many times it happened that you deleted or modified something in a Google Sheet or you shared a Google Sheet for collaboration and other people modified it. How do you go back? There is...read more
Posted in Google SheetsTagged edit history, Google Sheets

Filter Pivot Table with Slicer in Google Sheets

Posted on September 16, 2019November 13, 2021 by Paul
Pivot Tables are the most powerful tools that you can use in your Google Sheets. A slicer is the feature that can filter out Pivot Tables easily. Very useful when you need to keep all...read more
Posted in Google SheetsTagged Google Sheets, pivot table, slicer

What is IFTTT and how does it work

Posted on September 16, 2019November 13, 2021 by Paul
IFTTT is an automation service. Many services in the technology world are API based. That means through functions called API's (Application Programming Interface) they can be asked to perform certain function. For example, when you...read more
Posted in Tech Tips

Multi-row and Multi-column Pivot Table

Posted on September 14, 2019November 13, 2021 by Paul
In the previous tutorials for Pivot Tables we looked at the simple Pivot tables with one row and one column, then we added a category to the data-set to create a multi-row pivot table. In...read more
Posted in ExcelTagged excel, pivot table

How to Use Pivot Tables in Google Sheets

Posted on September 13, 2019November 13, 2021 by Paul
Pivot Tables are one of the most powerful features that is mostly known in Excel. However, Google Sheets is becoming more and more popular. Google Sheets is very similar with Excel from many point of...read more
Posted in Google SheetsTagged Google Sheets, pivot table
  • « Previous Page
  • 1
  • ...
  • 5
  • 6
  • 7
  • 8
  • 9
  • Next Page »
Copyright @EasySimpleSmart 2022
Disclosure Policy
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More
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