Skip to content
K2 Enterprises
  • Articles
  • Blog
  • Newsletter
  • Tech Tips
  • Training
    • Upcoming Events
    • Conferences
    • Seminars
    • On-Demand/Self-Study Training
    • On-Site, Private, and Corporate Training
    • Webinars and Web-Based Training
    • ACPEN Learning Options
    • Western CPE Learning Options
    • K2 Enterprises’ Instructional Team
Search for:
Page 2
Welcome to K2 Enterprises’ Home Page
>
Excel
>
Excel
>
Page 2

Tag: Excel

February 23, 2020in Tech Tips0by Tommy Stephens

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.…

Read more
January 28, 2020in News, Tech Tips0by Tommy Stephens

Excel's New Dynamic Array Feature

Excel’s New Dynamic Array Feature Excel’s new dynamic array feature is one of the best enhancements Microsoft has added to Excel in years. With dynamic arrays, we now have the…

Read more
December 14, 2019in Tech Tips0by Tommy Stephens

Excel's XLOOKUP Feature Begins Arriving

Microsoft has begun rolling-out Excel’s anticipated XLOOKUP feature to some Office 365 subscribers. While not all Office 365 subscribers yet have access to this feature, if you are an Office…

Read more
November 7, 2019in Tech Tips0by Tommy Stephens

Use Power Query to Split Data Into Multiple Columns

Excel offers multiple ways to split data in a cell. Among these are the venerable Text to Columns tool, Flash Fill, and writing formulas that incorporate Excel functions such as…

Read more
October 20, 2019in Tech Tips0by Tommy Stephens

How to Link QuickBooks Data into Excel

As an accounting application designed for small businesses, QuickBooks and QuickBooks Online have relatively robust reporting options. In addition to numerous, standard reports, these tools offer customization options and the…

Read more
September 5, 2019in Tech Tips0by Tommy Stephens

Excel's Easy to Use LARGE and SMALL Functions

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…

Read more
August 8, 2019in Tech Tips0by Tommy Stephens

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…

Read more
August 1, 2019in News, Tech Tips0by Tommy Stephens

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…

Read more

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…

Read more
July 22, 2019in Tech Tips0by Tommy Stephens

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…

Read more

Posts navigation

1 2 3 … 5
About Us


K2's goal is to produce and deliver the highest quality technology seminars and conferences available to business professionals. We work cooperatively with professional organizations (such as state CPA societies and associations of Chartered Accountants) and vendors of technology products. K2 also provides consulting services and advice on technology.

We make every effort to maintain a high level of integrity, family values, and friendship among all involved.

Premier Learning Partners

Interested in a K2 class? Check out our offerings from one of our partners.





Professional Certifications

Other K2 Affiliated Sites
  • K2 Canada
  • Totally Paperless
  • Accounting Software World
  • CPA Firm Technology
Get In Touch With Us
Drop Us a Line

1905 W. Thomas Street, Ste D, #363
Hammond, LA 70401-2901

Give Us a Call

(985) 542-9390
Monday - Friday, 8AM - 5PM CT
Closed Most Holidays

Shoot Us an Email

info@k2e.com
© 2021 K2 Enterprises. All rights reserved.
  • Terms of Service & Privacy Policy
  • Site Map
  • Site Design by Devmatics