For many years, the MAX and the MIN functions have overshadowed Excel’s LARGE and SMALL functions. However, as you will see in this tip, the LARGE and the SMALL functions…
Tag: Excel
Using Power Query To Combine Excel Workbooks
The more we dig into Excel’s Power Query feature, the more we find out just what a powerful tool it really is. For example, Power Query includes tools to ease…
Does Your Version of Excel Contain Power Pivot?
Over the years, knowing whether you have access to the Power Pivot feature in Excel has been challenging at times to say the least. First introduced as an add-in for…
K2's Advanced Excel Data Magic - Managing, Analyzing, and Reporting
K2’s Advanced Excel Data Magic – Managing, Analyzing, and Reporting New Course for 2020! Course Description With tools such as Data Models, Power Query, and Power Pivot, today’s versions of…
Snap a Picture to Import Data into Excel
Last fall, Microsoft announced forthcoming capabilities to take a picture of a data set using your Android-based or iOS-based device and import that data in Excel. That feature has now…
Automating Your Reports With Excel's Power Query Feature
Automating Your Reports With Excel’s Power Query Feature Excel’s Power Query provides fantastic opportunities for business professionals to automate many reporting processes and practices. Ranging from simple queries to sophisticated…
Using Excel's Transorm Data by Example Add-in
Using Excel’s Transform Data by Example Add-in Dating back to Excel 2010, Microsoft has been adding features to Excel to assist us in transforming our data so that it is…
The Top Five New Features In Excel 2019
Now that Excel 2019 has been available for approximately six months, many companies have begun the process of upgrading their team members to the new version of Microsoft’s market-leading spreadsheet…
Power Query - One-Stop Data Shopping
Power Query: One-Stop Data Shopping Thomas g. stephens, Jr., Cpa, CGMA, CITP Like any good CPA, you want to harness the tools at your disposal to maximize your value. One…
Working with Stock and Geography Data Types in Excel
Working with Stock and Geography Data Types in Excel Microsoft recently added two new data types to Excel – 1) Stock and 2) Geography. If you use Excel 2019 obtained…