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 update, and the types of connections that can be made
Creating 3D References between Workbooks in Excel Read Post »
Access allows users to connect to various data sources, such as SQL, other databases, XML files, and SharePoint, as well as Excel files. In order to ensure a proper importing and/or linking, the data needs to have headers for
Connecting to Excel In Access Read Post »
Do you remember the excitement that you felt when you got to go Back to School shopping? Buying new sneakers, lining up your freshly sharpened pencils, picking out just the right Trapper Keeper (either the one with the sweet gray
Got game? AdvantEdge Training & Consulting has upped its SharePoint game so you can up yours! For those just getting started building their skills in site development on the SharePoint platform, we offer SharePoint Level 1, which introduces basic concepts
Up your SharePoint Skills Read Post »
Marking tasks as completed is an important part of keeping up with progress during a project. More than likely, Project Managers are not on job sites 24 hours a day, seven days a week. Thus, the Project Manager may update
Three Ways to Mark Tasks as Completed – Project Read Post »
Draw a triangle. Put scope, time, and cost around the three sides. Now put Resources in the center. You have just fully captured the parameters of a Project! Customer satisfaction, quality, and risk are all about real or perceived variability
Why does a simple triangle fully define a Project? The Triple Constraint Read Post »
Making SharePoint easier to navigate and keeping navigation simple are two very important pieces to user buy-in. Getting these right ensures users will continue to return to the SharePoint site. Typically, when we add web parts to a page, the
Change a Web Part Link in SharePoint Read Post »
Are you struggling with employees who attend training, and then do not feel as though it was worth their time out of the office? At AdvantEdge Training & Consulting, we believe in delivering Training that is relevant to your
Customized Training for Your Company! Read Post »
Meanwhile, back at the Work Cave. . . “Holy laser printers, Workman! That deadline is approaching fast, and you are being distracted by incoming emails!” “They are coming in every couple of minutes, Bobbin! I can’t hold them off much
Be a Time Management with Outlook Superhero Read Post »
Have you ever wondered how to add the various professional symbols in Word? Symbols for copyright, trademark, and others are available, but they are not always easy to find. The good news is that once you find the symbols you
Professional Symbols – Word Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
