BlogHide Resteemstheexcelclub (65)in hive-102332 • 1 hour agoExcel Knowledge Sharing week ending Fri. 20 DecIts Excel knowledge sharing time peeps :-) Have you published an Excel resource this week? Or maybe you found a…theexcelclub (65)in excel • 11 days agoExcel Power Trick - Save Time Without VBAIn the video below you will learn an Excel Power Trick, using Excels Power Query, to transform standard Excel data.…theexcelclub (65)in excel • 12 days agoExcel Dynamic Conditional Formatting TricksConditional Formatting in Excel allows you to format cells based on the value of the cell. So, most conditional…theexcelclub (65)in excel • 15 days agoHow to find the Nth Largest in ExcelBoth MIN and MAX in Excel will return the Minimum or Maximum value from a list. But what if you want to return a…theexcelclub (65)in excel • 20 days agoExcel Superstars you need to be followingWhy you need more Excel Superstars!! For a long time now, I have been helping you become an awesome Excel user. Here…theexcelclub (65)in excel • 29 days ago10+ Excel Learn and Earn Activities YOU can do TodayThe Excel Club blog is the first Excel blog in the world where you can Earn while you Learn Excel. We launched this…theexcelclub (65)in excel • last month5 Reasons Spreadsheet Users should be using Excel 365Do you use Excel 365? We are all very accustom to Microsoft releasing a new version of Excel every 3 years. Excel…theexcelclub (65)in excel • last monthShare Collaborate and Co-Author in ExcelShare Collaborate and Co-Author in Excel With improvements in Cloud Computing it is now easier than ever to…theexcelclub (65)in excel • 2 months agoExcel Dynamic Arrays – A new way to model your Excel SpreadsheetsExcel Dynamic Arrays – changing how Excel works Many years ago, I heard Excel referred to as ‘Hell in a Cell’. I…theexcelclub (65)in excel • 2 months agoHow to use SUMIF and SUMIFS in ExcelThe SUM function in Excel is probably the most widely used function available. In fact it is the only formula that…theexcelclub (65)in excel • 2 months agoStop! Do Not Merge Cells in Excel - Heres why with fixesOver the years I have seen many things in Excel that have made me go “wow, I won’t do that again in a hurry”.…theexcelclub (65)in excel • 2 months agoHow to Reconcile Accounts using Power QueryHow to Reconcile Accounts using Power Query! What? Did I hear you right? Reconciling accounts is a common task…theexcelclub (65)in excel • 2 months agoLooking up and Combining text using TEXTJOIN and Array IF Statements.Looking at the table of data below, how would you go about looking up the order number and pulling the name of all…theexcelclub (65)in excel • 2 months agoExcel's Map ChartsMap charts can be used to visually display values and category’s across the geographical area. These charts can be…theexcelclub (65)in excel • 2 months agoTips for Analyzing Categorical Data in ExcelIt is often necessary to analyze different data types in Excel, including analyzing categorical data in Excel. Having…theexcelclub (65)in excel • 2 months agoExcel Power Tools - The Future of ExcelFor years now Accountants and bookkeepers around the globe have used Excel as their Spreadsheet tool of choice. It…theexcelclub (65)in excel • 2 months agoBusiness Intelligence for the Excel User and AccountantOver the last few posts, we looked at Business Intelligence and an example of how it can be used in a small business.…theexcelclub (65)in excel • 2 months agoBusiness Intelligence Case Study - The Small BusinessIn my last post, I gave you a brief explanation of Business Intelligence (if you missed the post you can read it…theexcelclub (65)in excel • 2 months agoWhat is Business Intelligence?Business Intelligence Business Intelligence (BI) plays a key role in the strategic planning of a business. BI Tools…theexcelclub (65)in excel • 2 months agoMove over VLOOKUP, here comes XLOOKUPXLOOKUP Excel 365 (insider edition) VLOOKUP is one of those functions’ users tend to use over and over. At the…