K2’s Excel Essentials For Staff Accountants Course Information 8 CPE Credits 8-Hour Course Computer Software and Applications (8 Credits) Fundamental Knowledge of Excel Prerequisites Intermediate Program Level No Preparation Shop…
Tag: Excel
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…
Excel's Ideas Feature - A Great Way To Summarize And Analyze Data
Excel’s Ideas feature offers tremendous opportunities for you to summarize and analyze data automatically. In this tip, you will learn how you can take advantage of Ideas.
Rethinking Sorting And Filtering in Excel
When sorting or filtering data in Excel, most users instinctively click the drop-down arrows at the top of a column to initiate the process. In this tip, you will learn…
Solve Formatting Issues in Excel with Center Across Selection
Many Excel users struggle with formatting their spreadsheets to give them a polished and professional appearance. Among the challenges these users face is how to center text over multiple columns.…
Five New Excel Features to Boost Productivity in 2020
As you are no doubt aware, Microsoft added many new features with the release of Excel 2019 and continues to update the venerable spreadsheet application through updates to Office 365.…