Getting Started With Data Analytics Many business professionals use the term data analytics. However, few truly understand what the term really means and how to take advantage of various analytics…
Tag: Excel
Manage Links In Excel Workbooks
Linking data from one Excel workbook to another is one of Excel’s best features. In this article, you will learn the best ways to manage linked workbooks.
Excel's STOCKHISTORY Function Is Now Available
Recently added to Excel is the new STOCKHISTORY function. You can use STOCKHISTORY to retrieve historical prices for stocks as of a given date or range of dates. Read on,…
K2's Next Generation Excel Reporting
K2’s Next Generation Excel Reporting Course Description New Course For 2021! New features added to Excel beginning with the 2016 release offer tremendous opportunities to improve Excel-based reporting, for both…
K2's Excel Essentials For Staff Accountants
K2’s Excel Essentials For Staff Accountants Course Description Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief…
Artificial Intelligence Meets Microsoft Office
Many have written about the future of Artificial Intelligence (AI) and its potential in our personal and professional lives. So far, most of the literature describes the impacts as “futuristic”…
How To Format Excel PivotTables For Even Greater Effect
One of the unfortunate misperceptions regarding PivotTables in Excel is that you cannot format them to meet your specific reporting needs. Read on, and in this article, you will learn…
Excel's New "LET" Function Can Simplify Your Formulas
Excel’s new LET function can really help you to simplify and streamline your formulas. With LET, you can declare variables within a formula and then use those variables to shorten…
Converting And Importing PDF Data Into Excel
Did you know that you now have the option of converting and importing PDF data into Excel? In this tip, you will learn just how easy it is to import…
Comparing Excel's Merge Cells and Center Across Selection Features
Merge Cells and Center Across Selection are long-standing features in Excel. You can use both these features to change the appearance of data in a spreadsheet. In this tip, you…