Power Query Tip for Filtering Multiple Columns on Multiple Values
Excel Tips Learn how to create a more manageable filter when dealing with filters on multiple columns and multiple values[…]
Read moreTag: msexcel
☑️ Top 30 Advanced Excel Tips and Tricks
Excel Tips Learn the top 30 advanced Microsoft Excel features you need to know to go from beginner to advanced[…]
Read more
Power Query Tip for Greyed Out Actions
Excel Tips Learn how to combine numerical transformations on multiple columns into a single step in Power Query. Credit How[…]
Read more
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.[…]
Read more
Roman Numerals Using Excel
Excel Tips This excel video tutorial provides a basic introduction into roman numerals. Credit The Organic Chemistry Tutor
Read moreExcel Forecast Function Explained!
Excel Tips This excel video tutorial provides a basic introduction into the forecast function which can be used to predict[…]
Read moreTop 10 Most Important Excel Formulas – Made Easy!
Excel Tips This video provides a basic introduction into the top 10 most important formulas used in excel Credit The[…]
Read moreExcel Basics – Linear Regression – Finding Slope & Y Intercept
Excel Tips This video tutorial provides a basic introduction into the linear regression of a data set within excel. Credit[…]
Read moreConvert Decimals to Fractions Using Excel!
Excel Tips This excel video tutorial explains how to convert decimals to fractions using simple number formating. Credit The Organic[…]
Read moreExcel Tutorial – Calculating Percentages
Excel Tips This excel tutorial video explains how to calculate percentages in excel. Credit The Organic Chemistry Tutor
Read more
How to use the Excel Maps Function : Excel Maps Tutorial
Excel Tutorial 3D Maps in Excel is a data-visualization tool available in Excel 2016 and 2019. Excel 2013 users can[…]
Read moreProtecting Workbooks and Worksheets in Excel
Excel Tutorial Imagine the scenario. You have spent weeks putting together a complex spreadsheet ensuring that the formulas work, it’s[…]
Read moreExcel Tutorial : Using the WHAT-IF Analysis in Excel
Excel Tutorial The OFFSET function is part of the Lookup and Reference group of functions in Excel. Credit Simon Sez[…]
Read moreExcel Tutorial : Using the OFFSET Function in Excel
Excel Tutorial The OFFSET function is part of the Lookup and Reference group of functions in Excel. Credit Simon Sez[…]
Read more
Excel Tutorial : Using the INDIRECT Function in Excel
Excel Tutorial The INDIRECT function is part of the Lookup and Reference group of functions in Excel. Credit Simon Sez[…]
Read more