TITLE: EXCEL VBA: MANAGING FILES AND DATA

PUBLISHER..........: LYNDA
LINK...............: http://is.gd/kQhUtD
AUTHOR.............: CURT FRYE

LANGUAGE...........: ENGLISH
RELEASE TYPE.......: RETAIL
RELEASE FORMAT.....: ISO
STORE DATE:........: 2014.12.23
RELEASE DATE.......: 2014.12.23
ISO SIZE...........: 330.801.152 B
ISO CHECKSUM.......: A6CDEB2A
DISKCOUNT..........: 07 X 50MB
SAVED MONEY........: YOU DID!
DISKNAME...........: keiso_levmfandd

Automate complex tasks and get more meaningful
insights from data in Excel using Visual Basic for
Applications (VBA) code. This course extends the
techniques taught in Up and Running with Excel VBA, showing
members how to work more efficiently in this powerful and
popular spreadsheet program. Curt Frye shows how to focus in
on important data, with filters; manage workbooks and
worksheets; access built-in functions; create charts; and
build UserForm interfaces for data entry.

Topics include:

* Creating filters

* Chaining and combining filter criteria

* Determining whether workbooks and worksheets exist, with
VBA

* Opening, closing, and saving workbooks

* Using VBA to calculate data via Excel's built-in functions

* Creating charts with sparklines

* Adding fields to UserForms

Huh? No news are good news!

BBL - DDU - EEn - iNTENSiTY - JGT - RBS

SHOUTOUTS

DVT - FONT - iRONiSO - LAXiTY - PARADOX - SO