Course Outline
Adjustment of the Working Environment for Government
- Keyboard shortcuts and facilities
- Create and modify toolbars
- Excel Options (autosave, input settings, etc.)
- Paste special options (transpose)
- Formatting tools (styles, format painter)
- Navigate with the Go To tool
Organization of Information for Government
- Manage sheets (naming, copying, color changes)
- Assign and manage cell and range names
- Protect worksheets and workbooks
- Secure and encrypt files
- Collaborate with track changes and comments
- Inspect sheets for errors
- Create custom templates, charts, worksheets, and workbooks
Data Analysis for Government
- Logical functions
- Basic functions
- Advanced functions
- Scenario analysis
- Data search tools
- Solver for optimization problems
- Create and customize charts
- Graphics support (shadows, AutoShapes)
Database Management (Lists) for Government
- Data consolidation techniques
- Grouping and outlining data
- Sorting data across multiple columns
- Advanced data filtering methods
- Database functions
- Calculate subtotals (partial sums)
- Create and manage tables and Pivot Charts
Cooperation with Other Applications for Government
- Import external data (CSV, TXT files)
- Use OLE (static and linked objects)
- Web queries for data extraction
- Publish sheets on websites (static and dynamic)
- Publish PivotTables online
Automation of Work for Government
- Conditional formatting rules
- Create custom formats
- Check data correctness
- Record and edit macros
Visual Basic for Applications (VBA) for Government
- Create custom functions in VBA
- Implement results using VBA
- Design and use VBA forms
Requirements
Testimonials (5)
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course - Access VBA
I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Tamil was held up helping other people, I could crack on with the next parts.
Luke Pontin
Course - Data and Analytics - from the ground up
I generally enjoyed the practical examples.
