Welcome to Chandoo.org - Learn Excel, Charting Online
Dicuss your excel and spreadsheet problems in forums. Learn excel, charting, formulas, functions, dashboards, pivot tables & VBA using tutorials, downloadable example and online classes - by …
Learn SQL for Data Analysis in one hour - Chandoo.org
Jun 6, 2023 · SQL is an important skill to have for people working with Data. In this article and the companion video, learn how to use SQL to perform common data tasks in under one hour. …
How to calculate WEEKNUMBER in Month / Quarter / Year with …
Aug 20, 2024 · Excel formulas to calculate week number in a month or quarter using the WEEKNUM() function with a free sample workbook.
9 Box grid for talent mapping – HR for Excel - Chandoo.org
Nov 17, 2020 · 9 box grid is a popular method for talent mapping. Download this free excel template for tracking and visualizing your employee performance & potential data.
What is this type of char called? And how do I do it?
Jun 25, 2012 · At the moment I cant recall where i saw it, what it was called, or anything. Can any of you guys tell me what its called? Do you know how to make it in excel? Its a great way to …
Specify row number to use for a formula | Chandoo.org Excel …
Oct 5, 2021 · I have data for each person in rows. I create a display or a formula using the values in one row. How do I now create the same display with a different row. I Example: Name Start …
How to identify background color of a cell with a formula
Oct 3, 2012 · The Get.Cell function is an Old Excel 4 Macro function that, although has lots of useful uses, is not documented or guaranteed of being supported in future versions of Excel.
Christmas Gift List - Set your budget and track gifts using Excel
Free excel spreadsheet template to keep track of your christmas gift buying budgets and lists. The file automatically highlights items over budget and shows you information on how many more …
macro to copy paste data between 2 excel files
Jun 23, 2013 · I have 2 files in 2 different folders. I would like to know if there is a way to copy data from 1 of the files into another using only macros. I know it can be done using vba but I …
Make an Impressive Product Catalog [FREE templates]
Sep 17, 2019 · Learn how to create an excel based product catalog in this tutorial. Also, download product catalog spreadsheet templates and use it in your small business.