Click here to see more Tech Tips Cleaning Data using Excel’s TRIM Function When working in Excel, sometimes the data in a worksheet is “dirty” and contains leading or trailing…
Category: Tech Tips
Microsoft Adds IFS Function to Excel 2019
With the release of Excel 2019, Microsoft added the IFS function to its spreadsheet application. Although IFS appeared in 2016 for Office 365 subscribers, Microsoft did not include it with…
Using Excel's AutoCorrect Feature to Store and Insert Formulas
Many Excel users find themselves frequently entering the same formula and are seeking a method through which they could store the formula and recall it on demand in the future.…
Are You Keeping Up With Technology?
More than ever, to say that technology is changing how we conduct business would be one of the single biggest understatements of the century. However, to say that many are…
PivotTables are one of Excel’s most powerful features – if not THE most powerful feature – and are exceptionally useful at summarizing large volumes of data when preparing analytical reports.…
Block Ransomware with Controlled Folder Access in Windows 10
With the Fall 2017 update to Windows 10 (version 1709 or newer), Microsoft added a terrific new feature to the operating system that should prove to be very effective in…
Working with Date Tables in Power Pivot
Power Pivot is causing many business professionals to re-think how they create reports and analyses. However, for those that need to summarize data based on fiscal periods – instead of…
SETTING PIVOTTABLE OPTIONS IN EXCEL 2016
https://www.youtube.com/watch?v=XjgLBpehj1c&feature=youtu.beMany consider PivotTables to be Excel’s most powerful feature, yet some Excel users struggle with formatting their PivotTable reports to exude a polished and professional appearance. If you are running…
Use SUMIFS to Create Analytical Reports without PivotTables
Click here to see more Tech Tips Use SUMIFS to Create Analytical Reports without PivotTables PivotTables are one of Excel’s most powerful features – if not THE most powerful feature…
K2's Technology Tips
K2’s Technology Tips Are you looking for better ways to utilize the technology you already have at your disposal? If so, you’re not unlike many business professionals! In today’s ever-changing,…