Tag: Learn Excel

beginner excel lessons

Excel 101 – Getting Started with Excel 365

Everyone must start somewhere and getting started with Excel 365 will be made easy with this massive article.  Grab your coffee and get ready to learn Excel in a practical way. If you have every wondered how to use an Excel Spreadsheet and how you can learn to use Excel quickly then you have come […]

Learn to use VLOOKUP in Excel

The VLOOKUP and HLOOKUP formula in Excel allow you look up a value in one column or row and return a corresponding value from a different column or row. VLOOKUP is a vertical lookup and HLOOKUP is a horizontal lookup The table of data below contains 4 columns.  A Product Number, the Supplier, the quantity […]

Its rather simple to use the Outline feature in Excel

The Outline Feature in Excel Excel’s automatic outlining feature makes outlining a worksheet easy. Automatic outlining works best with numerical data organized into groups and sub groups by formulas or functions. For example, the sample image below contains monthly sales data, organized into quarterly and yearly totals using formulas: As you can see, it can […]

Find Hard coded values in Excel Formulas

Find Hard-coded values in Excel Formulas

Finding hard-coded values within Excel Formulas is something Excel users have struggled with for a long time. While I was researching this article, I am surprised that the solution I am about to offer you has not been widely covered so far. What exactly is a hard-coded value? It would be common to see a […]

Excels Rank Functions

Using Excels Rank functions

Excels Rank functions have evolved over time, and give you the ability to ranks values in a list or column based on their value compared to other values in the same list or column. In Excel 2007 and previous versions, the function you would use to rank value is Rank and the syntax is: =RANK(Number, […]

Excel pimped with power

Excel Pimped with Power Tools

Excel is one of those tools that you just can’t live without.  It is used to store information, run calculations, carry out analysis, prepare report, visualizations and much more.  What’s just as important is the flexibility it gives to its +750 millions of users. This flexibility allows users create their own calculations and analysis, in […]

Print Options in Excel

Fine Tune your Workbook with Print Options in Excel

There is nothing worse than receiving an Excel workbook that looks the part, but then when you print it, tables and charts are split into different pages. Do people know there are print options available in excel? This problem is a common spreadsheet problem.  People fail to use the page layout options and page set up […]