Skip to content
Your business training experts!     Email AdvantEdge | (303) 900-8963
AdvantEdge Training & Consulting
  • Contact Us
  • Microsoft Office
  • Professional Development
  • Just Tips Blog
  • Register for a Class
  • 0
0 Menu Close
  • Contact Us
  • Microsoft Office
  • Professional Development
  • Just Tips Blog
  • Register for a Class
  • 0

Excel

Home » Microsoft Office » Excel
Read more about the article Two Unique Ways to Use Excel

Two Unique Ways to Use Excel

  • Post author:Admin
  • Post published:October 26, 2020
  • Post category:Excel/Microsoft Office

When you think of Microsoft Excel what comes to mind? Accounting spreadsheets? Using formulas to calculate numbers? Generally, we think of Excel only as a system to manage our numbers,…

Continue ReadingTwo Unique Ways to Use Excel
Read more about the article Automate Excel Without Macros

Automate Excel Without Macros

  • Post author:Admin
  • Post published:October 26, 2020
  • Post category:Excel/Microsoft Office

Many students come to us wanting to learn how to create macros in Excel to automate their spreadsheets.  However, they often don’t realize that formulas can be used to create…

Continue ReadingAutomate Excel Without Macros
Read more about the article Keep Decimals Out of the Equation with Data Validations in Excel

Keep Decimals Out of the Equation with Data Validations in Excel

  • Post author:Admin
  • Post published:October 22, 2020
  • Post category:Excel/Microsoft Office

Using Data Validations in Excel can be very helpful, as validations make sure the data is entered correctly, and ensures all the intended functionality works according to plan. One possible…

Continue ReadingKeep Decimals Out of the Equation with Data Validations in Excel
Read more about the article Recorded vs Coded Macros

Recorded vs Coded Macros

  • Post author:Admin
  • Post published:September 15, 2020
  • Post category:Excel/Microsoft Office

In the world of Microsoft, macros are the way many users automate various steps of their daily processes. There are two basic types of macros, recorded and coded. Recorded macros…

Continue ReadingRecorded vs Coded Macros
Read more about the article Removing Duplicates in Excel

Removing Duplicates in Excel

  • Post author:Admin
  • Post published:August 14, 2020
  • Post category:Excel/Microsoft Office

 Removing duplicate information can be both helpful and intimidating when working with many line items in Excel. Follow these steps to make the process easy : Ensure your data has…

Continue ReadingRemoving Duplicates in Excel
Read more about the article Filter Data with Header Drop-Down Filters in Excel

Filter Data with Header Drop-Down Filters in Excel

  • Post author:Admin
  • Post published:August 13, 2020
  • Post category:Excel/Microsoft Office

All too often, when we are sent data from other, it is not presented in the view we would like. Changing the way our data looks, and being able to…

Continue ReadingFilter Data with Header Drop-Down Filters in Excel
Read more about the article New Excel 2019 Function: MROUND

New Excel 2019 Function: MROUND

  • Post author:Admin
  • Post published:July 7, 2020
  • Post category:Excel

Every new version of Microsoft Excel comes with new or updated functions. The 2019 version of Excel is no exception. One of the new functions is MROUND. MROUND is a…

Continue ReadingNew Excel 2019 Function: MROUND
Read more about the article Sorting by Multiple Columns in Excel

Sorting by Multiple Columns in Excel

  • Post author:Admin
  • Post published:June 8, 2020
  • Post category:Excel/Microsoft Office

When working with large chunks of data, we sometimes need to sort the data to figure out where we need to focus our attention. This could mean that we need…

Continue ReadingSorting by Multiple Columns in Excel

Creating Excel Templates

  • Post author:Admin
  • Post published:June 4, 2020
  • Post category:Excel

Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to recreate the wheel every time, nor continuously to clean out old…

Continue ReadingCreating Excel Templates
Read more about the article Grouping Rows in Excel

Grouping Rows in Excel

  • Post author:AdvantEdgeAdmin
  • Post published:April 6, 2020
  • Post category:Excel/Microsoft Office

Hiding certain rows or columns in Excel can make viewing complex, detailed information easier to read. Grouping Rows in Excel allows you to quickly collapse and expand similar data to…

Continue ReadingGrouping Rows in Excel

Just Tips

  • New Year’s Resolutions
    New Year’s Resolutions
    January 5, 2023/
    0 Comments
  • Creating Activities that Help your Virtual Team Feel Like a Team
    November 1, 2022/
    0 Comments
  • Remote Workforce – Is a Transition Back to In-Office Necessary?
    January 5, 2022/
    0 Comments
  • Contact Us
  • Microsoft Office
  • Professional Development
  • Just Tips Blog
  • Register for a Class

Subscribe

AdvantEdge Training & Consulting

Your business training experts!


XML Sitemap


Looking for Mission Critical Systems IT technical services? Click Here.

  • Contact Us
  • Microsoft Office
  • Professional Development
  • Just Tips Blog
  • Register for a Class
Copyright 2023 -AdvantEdge Training & Consulting
×
×

Cart