Create a named group of cells to be used in formulas or to quickly navigate back to the group. To do so, first, select the group of cells to be named. In this case, we will use a list of
Excel: Create a named group of cells Read Post »
Project Management is proving attractive to many who formerly considered only traditional Functional Management. What is the difference, and what personality types are best suited to each? Project Management is purely Goal-oriented, whereas Functional Management is often oriented toward keeping
Career Paths: Project versus Functional Management Read Post »
How does you or your manager rate? Do you have what it takes to be a great manager and leader? Could you benefit from a management or leadership course? Take the following quiz to see how you rate. If you
Quickly disappearing are the days when all employees are based in one office. With the need to keep competitive in today’s business landscape, companies need faster speed to service for their clients, they need to cut travel cost to see
Ensuring Success with a team of Remote or dispersed employees Read Post »
Distributed workforce employees often struggle to feel included in the company and team. Many remote employees feel left out when they hear of their office or others have company events like ditch days, breakfast or lunch brought in, costume contests,
Building a team with remote employees Read Post »
If the DateValue Command doesn’t work, use text to columns to reformat text into dates. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Dates through Text to Columns Read Post »
Some data from other programs can come in as text instead of dates. Use the command DateValue to change text to a date. For more ways to make Excel work for you, take a training course from AdvantEdge Training &
Use these simple keystrokes to simply select multiple columns or rows of data in Microsoft Excel For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Select large amounts of data in Excel Read Post »
Change your X and Y axis in Microsoft Excel to turn your columns into rows and rows into columns. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Transpose data in Microsoft Excel Read Post »
Quickly clean duplicate data from data sets in Excel with the Remove Duplicates button. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!
Removing Duplicates in Excel – Video Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
