Macro consolidating workbooks
Ed Tech Institute, LLC formerly known as The Sage Group, LLC, an NCCRS member since May 2003, has been providing workforce-training services for over 15 years.
In 1988, the company was founded as the Pace Group and established its reputation for excellent customer service and relationship building.
Course 1 and 2: The Microsoft Office Outlook - Basic and Intermediate courses are designed for participants to enhance their computer applications skills.
Each course covers the various level functions and features of Microsoft Office Outlook .
A companion article, Using Access or Excel to manage your data, discusses the benefits of each product and what they bring to the table. If you store your data in Access and connect to it from Excel, you gain the benefits of both.
Here are ten reasons why using Excel and Access together makes lots of sense.
The course focuses on the three basic structures of programming that apply to any programming language – Sequence, Selection, and Loop.
Concepts are reinforced through the use of business examples for understanding and application.
Course 3: Students will be able to: use the IF and SUMIF functions to calculate a value based on specified criteria; use a nested IF function to evaluate complex conditions; and use the ROUND function to round off numbers; use the PMT function to calculate periodic payments for a loan; use Date and Time function to calculate duration in years, months, and days or time; display, print, and hide formulas; create array formulas to perform multiple calculations on multiple sets of data at one time; and change calculation options and iteration limits; use the VLOOKUP and HLOOKUP functions to find values in worksheet data; use the MATCH function to find the relative position of a value in a range; use the INDEX function to find the value of a cell at a given position in a range; and use data tables to project values; use the Data Validation feature to validate data entered in cells; and use database functions to summarize data values that meet criteria you specify; export data from Excel to other formats, and import data from a text file into an Excel workbook; import XML data into a workbook, and export data from a workbook to an XML data file; and use Microsoft Query and the Web query feature to import data from external databases; Use the Goal Seek and Solver utilities to meet a target output for a formula by adjusting the values in the input cells; use the Analysis Tool Pak to perform statistical analysis; and create scenarios to save various sets of input values that produce different results; Run a macro to perform tasks automatically; recorded macros; assign a macro to a command button and a button in the worksheet; use a button to run the macro; create an Auto-Open macro; edit a macro by editing VBA code; and create a custom function to perform calculations when built-in functions are not available.
Instruction is offered in a traditional classroom format with instructor led demonstrations, hands-on practical exercises, individual assignments and final examinations.
Course 1: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications or Microsoft Office Excel - Introductory (1/13) (5/14 Administrative Review).
Course 1, 2, and 3: The Microsoft Office Excel - Introduction, Intermediate and Advanced courses are designed for participants to enhance their computer applications skills.
Each course covers the various level functions and features of Microsoft Office Excel.