Use Range Methods ( Calculate, ClearContents, Copy)įocuses on the Language use to Manipulate Excel Objects, i.e. Get and Set Range Properties ( Count, Dependents, Name, Value, Formula, Text) Use Worksheet Methods (Activate, Calcilate, Delete) Get and Set Worksheet Properties (Index, Name, Used Range, Visible) Use Workbook Methods (Activate, Close, Protect, Save, Save Copy As) Get and Set Workbook Properties (Name, Path, Saved) Use Application Methods (Close, Calculate)

Get and Set Application Properties (Caption, Path, Window State, DisplayStatusBar, Display Formula Bar) Know what is Excel Objects (Application, Workbook, Worksheet, Range) Overview of the Excel Objective and how to use them to design applications. Used to design custom interfaces in Excel.Interactive lectures, PowerPoint presentation, discussions and practicalĪpplications with four commonly used Excel object : Application, Workbook, Able to perform SUM, AVERAGE, MAX, MIN, IF.Able to create a spreadsheet with simpleįormatting (Font, Font Size, Font Color, Fill Cell With Color, Border).Able to identify where is the Status Bar.Able to minimize, maximize and close Excel.Able to switch between task applications.(Foundation & Intermediate) is essential with the follow pre-requisites: To learn more in-depth knowledge and practical uses of Microsoft Excel VBA. Useful information leads to better decision making, which ultimately leads toīetter strategy in performing critical tasks to compete, survive and increaseĬlerks, Officers, Executives and Managers of all level and personnel who want The ability to rapidly convert raw data to This course is about using Microsoft ExcelĪs a development tool to design an information system – how to access it,Īnalyze it and give it meaning.

Excel visual basic classes