AutomateNow

Excel tips, tricks and tutorials for the intermediate to advanced user in recording macros, writing scripts in VBA, and creating user-defined functions while optimizing performance.

Popular Posts

The difference between recorded macros and VBA scripts
Wrapping text within a cell in Excel using VBA
Scroll Bars - Negatives & Decimals
VBA Programming in Excel 2010
Data Validation List based on another data validation list
Top-10-valentines-day-templates
John Walkenbach on Excel

Saturday, February 19, 2011

Multiple methods to use built in Functions from Excel in VBA

How to Use an Excel Formula from VBA by Yoav Eze

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Friday, February 18, 2011

Excel Date functions

Date Functions in Excel

Date Functions in VBA for Excel

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Thursday, February 17, 2011

Excel User: Excel Charts – Use an Image as Line Chart Markers

Excel User: Excel Charts – Use an Image as Line Chart Markers

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Wednesday, February 16, 2011

Quickly Compare Data using Row Differences

Quickly Compare Data using Row Differences

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Excel Array Formula Series 14.4: Stock Portfolio Analysis

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Tuesday, February 15, 2011

Excel Array Formula Series 14.3 Portfolio Standard Deviation

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Newer Posts Older Posts Home

Subscribe to: Posts (Atom)

LinkedIn Profile

About Me

saw1366: Seattle, WA, United States; With over 15 years in accounting for non-profit organizations to fortune 500 companies I have demonstrated the TRUE value of automating processes. Using Excel macros can speed up repetitive tasks but VBA unlocks entire processes to be fully automated by pulling data from Access, formatting data into clear and consistant reports and publishing results into Sharepoint. Reducing time to deliver means results can appear like dashboards with low upfront costs.
Find more on Facebook
Join the conversation on Yahoo! ExcelVBA Group
*Learn more about Excel here!

View my complete profile

Subscribe Feed

Subscribe in a reader

Blog Archive

► 2012 (2)
- ► 05/06 - 05/13 (1)
- ► 02/05 - 02/12 (1)

▼ 2011 (81)
- ► 05/01 - 05/08 (1)
- ► 02/27 - 03/06 (4)
- ► 02/20 - 02/27 (3)
- ▼ 02/13 - 02/20 (6)
- ► 02/06 - 02/13 (5)
- ► 01/30 - 02/06 (8)
- ► 01/23 - 01/30 (11)
- ► 01/16 - 01/23 (15)
- ► 01/09 - 01/16 (16)
- ► 01/02 - 01/09 (12)

► 2010 (4)
- ► 12/26 - 01/02 (4)

Ebates: Discounts on Shopping

Simple theme. Powered by Blogger.