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 Tips

Home » Excel Tips

Adding Data Labels to Charts/Graphs in Excel

  • Post author:Author
  • Post published:April 11, 2019
  • Post category:Excel Tips

After adding a chart or graph to your Excel workbook, some items may need labeling, in order for management to see details about the data. This is different than a…

Continue ReadingAdding Data Labels to Charts/Graphs in Excel

Evaluating Formulas in Excel

  • Post author:Author
  • Post published:March 15, 2019
  • Post category:Excel Tips

If you build formulas with the help of the Function Library, a dialog box pops up, and helps you fill in the different areas with the correct information, then evaluates…

Continue ReadingEvaluating Formulas in Excel

Revolutionary Learning Experiences: Excel Automation

  • Post author:Author
  • Post published:February 10, 2019
  • Post category:Excel Tips

We have all had those “Aha” moments, when the blinders are removed, the light bulb goes on, and things become clear. These revolutionary learning experiences can radically change our entire…

Continue ReadingRevolutionary Learning Experiences: Excel Automation

Go Further than Advanced in Excel

  • Post author:Author
  • Post published:February 2, 2019
  • Post category:Excel Tips

You know your way around a spreadsheet. You know how to set up your columns; you use some swanky shortcuts to reduce the time it takes you to input data;…

Continue ReadingGo Further than Advanced in Excel

Finding Worksheets in Excel

  • Post author:Author
  • Post published:January 17, 2019
  • Post category:Excel Tips

When working with Excel, especially if you are trying to fully automate a workbook, you can create many worksheets to keep from recreating the wheel.  Doing so often means navigating…

Continue ReadingFinding Worksheets in Excel

Removing Duplicates in Excel

  • Post author:Author
  • Post published:December 21, 2018
  • Post category:Excel Tips

  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…

Continue ReadingRemoving Duplicates in Excel

Embedding Documents in Excel

  • Post author:Author
  • Post published:October 15, 2018
  • Post category:Excel Tips

Embedding documents in an Excel workbook is a technique that is not widely used, mostly because not many people know you can embed a document in a worksheet. There are…

Continue ReadingEmbedding Documents in Excel

Creating 3D References between Workbooks in Excel

  • Post author:Author
  • Post published:September 19, 2018
  • Post category:Excel Tips

  Using 3D References allows us to use Excel more like a database than a spreadsheet. As Excel functionality has increased, so has Excel’s capabilities, including the speed that connections…

Continue ReadingCreating 3D References between Workbooks in Excel

Show Formulas Shortcut – Excel

  • Post author:Author
  • Post published:July 17, 2018
  • Post category:Excel Tips

Have you inherited a spreadsheet and you need to figure out what is going on in it?  It can be a challenge to have to click on each cell to see where…

Continue ReadingShow Formulas Shortcut – Excel

Why do all that work when you can automate?

  • Post author:Author
  • Post published:June 28, 2018
  • Post category:Announcements/Excel Tips

Did you know that there are ways to reduce your workload by automating many of the tasks you do in Excel? Our Excel Functions and Formulas class will empower you…

Continue ReadingWhy do all that work when you can automate?
  • 1
  • 2
  • 3
  • 4
  • …
  • 12
  • Go to the next page

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