Excel

Power Query Tip for Transforming Columns

Excel Tips Learn how to transform columns in power query using commands not found in the ribbon with this tip.[…]

Excel Tips This excel video tutorial provides a basic introduction into roman numerals. Credit The Organic Chemistry Tutor

Excel Tips This excel video tutorial provides a basic introduction into the forecast function which can be used to predict[…]

Excel Tips This video provides a basic introduction into the top 10 most important formulas used in excel Credit The[…]

Excel Tips This video tutorial provides a basic introduction into the linear regression of a data set within excel. Credit[…]

Excel Tips This excel video tutorial explains how to convert decimals to fractions using simple number formating. Credit The Organic[…]

Excel Tips This excel tutorial video explains how to calculate percentages in excel. Credit The Organic Chemistry Tutor

Excel Tutorial 3D Maps in Excel is a data-visualization tool available in Excel 2016 and 2019. Excel 2013 users can[…]

Excel Tutorial Imagine the scenario. You have spent weeks putting together a complex spreadsheet ensuring that the formulas work, it’s[…]

Excel Tutorial The OFFSET function is part of the Lookup and Reference group of functions in Excel. Credit Simon Sez[…]

Excel Tutorial The OFFSET function is part of the Lookup and Reference group of functions in Excel. Credit Simon Sez[…]

Excel Tutorial The INDIRECT function is part of the Lookup and Reference group of functions in Excel. Credit Simon Sez[…]

Excel Function & Tips You would like to develop an excel formula, but you may don’t have experience in the[…]

Excel Function & Tips This tutorial shows you how to filter excel chart data, and chart type by using data[…]

Excel Function & Tips This tutorial shows you how to extract the first Numeric value position and the character from[…]