NB: There are Video Tutorials supporting this eBook. Links to video tutorials are inclusive.
Automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code. This course will be showing you how to work more efficiently in this powerful and popular spreadsheet program. We will show 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
In this course we will show you how to use Visual Basic for applications to enhance the capabilities of Microsoft Excel. We will start by showing you how to filter your data. Next, we will show you how to manage your Excel workbooks by determining if a workbook exists, detecting if a workbook is open, and opening, closing, and saving your workbooks using VBA. Chapter Three shows you how to manage worksheets.
Chapter Four shows you how to take advantage of built-in worksheet functions in VBA, while Chapter Five shows you how to create charts. Finally, Chapter Six discusses UserForms. We are sure that you will find your time with Excel VBA: Managing Files and Data will be time well spent.
