Civil Engineering Projects
Getting Acquaintedwith Excel
or most people, Microsoft Excel and financial modeling go hand in hand. Given the title of this book, it should ...
Introducing Financial Modeling
he demand for financial modeling skills has increased exponentially in recent years and many job listings for ...
Macro 101: Convert a Workbook into a PowerPoint Presentation
This macro takes the concept of using Excel data in PowerPoint to the extreme. Open ...
Macro 100: Sending All Excel Charts to a PowerPoint Presentation
It's not uncommon to see multiple charts on one worksheet. Many of us ...
Macro 99: Sending Excel Data to a PowerPoint Presentation
It's been said that up to 50 percent of PowerPoint presentations contain data that has ...
Macro 98: Simulating Mail Merge with a Word Document
One of the most requested forms of integration with Word is the mail merge. In most cases, ...
Macro 97: Sending Excel Data to a Word Document
If you find that you are constantly copying and pasting data into Microsoft Word, you can use a ...
Macro 96: Compacting an Access Database from Excel
During your integrated processes, you may routinely increase or decrease the number of records ...
Macro 95: Opening an Access Form from Excel
In some instances, you or your clients may need to switch focus to an Access form. This example
...
Macro 94: Opening an Access Report from Excel
Access reports allow you to build professional looking reports that have a clean PDF-style look and ...
Macro 93: Running an Access Macro from Excel
You can run Access macros from Excel, using automation to fire the macro without opening Access.
...
Macro 92: Running an Access Query from Excel
Here's a nifty macro for those of you who often copy and paste the results of your Microsoft Access ...
