We are soon going to be having a company wide roll out of the latest version of windows and office package and in anticipation of it coming I wanted to ask what the main differences are between the 2003 Version of Office and the latest distribution? (2010 I think)
Basically we want to make sure we test all of our key systems, macros etc on the 1 test system we have been given before the full roll out hits us.
What sort of changes should we expect that may prevent our VBA scripts etc running?
For the most part, vba is the same. However, you need to get used to the concept of Trusted Locations for your dbs in the A2010 environment - a folder designated (from within A2010) as Trusted. Otherwise,
This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…