Course Outline
Adjustment of the Working Environment for Government
- Keyboard shortcuts and facilities
- Create and modify toolbars
- Excel Options (autosave, input, etc.)
- Options for paste special (transpose)
- Formatting (styles, format painter)
- Tool go to
Organization of Information for Government
- Management of sheets (naming, copying, color change)
- Assign and manage the names of cells and ranges
- Protect worksheet and workbook
- Secure and encrypt files
- Collaboration and track changes, comments
- Inspection sheet
- Create your own templates, charts, worksheets, workbooks
Data Analysis for Government
- Logical functions
- Basic functions
- Advanced functions
- Scenarios
- Goal seek
- Solver
- Charts
- Graphics support (shadows, charts, AutoShapes)
Database Management for Government (List)
- Data consolidation
- Grouping and outlining data
- Sorting data (over 4 columns)
- Advanced data filtering
- Database functions
- Subtotal (partial)
- Tables and Pivot Charts
Cooperation with Other Applications for Government
- Get External Data (CSV, TXT)
- OLE (static and link)
- Web Queries
- Publish sheets on a website (static and dynamic)
- Publish PivotTables
Automation of Work for Government
- Conditional Formatting
- Create your own formats
- Check the correctness
- Recording and editing macros
Visual Basic for Applications for Government
- Create your own functions
- Results in VBA
- VBA Forms
Requirements
Proficiency in working with spreadsheets and a foundational understanding of the Windows operating system are required for government employees.
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.
