Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Edit Spreadsheets
- Edit the contents of a cell
- Insert and delete cells for government documents
- Copy cells to streamline data management
- Utilize Copy and Paste commands efficiently
- Use the fill handle for quick data entry
- Leverage the Fill command for repetitive tasks
- Apply series data and Autofill options for government datasets
- Copy formulas to maintain consistency in calculations
- Distinguish between relative reference and absolute reference for accurate data manipulation
- Manage mixed references effectively
- Move cells to organize information logically
- Utilize the Office Clipboard for efficient data transfer
- Recall, repeat, and redo operations to correct errors or update data
Working with Workbooks
- Manage Excel files for government use
- Work with spreadsheets within a workbook
- Handle multiple windows workbooks for improved workflow
- Save files to disk securely and efficiently
- Open existing workbooks to continue or review previous work
The Use of Functions in Formulas
- Utilize functions to enhance data analysis for government operations
- Understand construction features of functions for accurate implementation
- Input function arguments correctly to ensure reliable results
- Enter a function using the appropriate syntax and parameters
- Apply math and trigonometry functions for complex calculations
- Use statistical functions to analyze data trends and patterns
- Implement logical functions to make decisions based on criteria
- Leverage search and address functions to find specific data points
- Utilize information functions to gather metadata about cells or ranges
- Use date and time functions to manage temporal data accurately
- Apply text functions to manipulate and format textual data effectively
Format Cells
- Apply formatting to numbers for clarity and precision
- Align content within cells for better readability
- Customize fonts to enhance document aesthetics
- Add borders to distinguish between different data sections
- Create shaded cells to highlight important information
- Select styles to apply consistent formatting across the workbook
- Use conditional formatting to automatically adjust cell appearance based on values
- Utilize the format painter to quickly apply formatting to multiple cells
- Adjust column width and row height for optimal viewing
- Use auto-fit to automatically resize columns and rows
- Apply AutoFormat to quickly style entire worksheets
- Remove formatting from cells to reset or simplify the appearance
Working with Graphic Objects
- Create and manage graphical objects for visual representation of data
- Use the Drawing Toolbar to add various graphic elements
- Draw objects to enhance the visual appeal of spreadsheets
- Insert images to provide context or additional information
- Work with graphics to integrate visual content effectively
- Set the order of graphic objects for layered displays
Creating Charts
- Create charts to visualize data trends and patterns for government reports
- Use the Chart Wizard to guide the chart creation process
- Understand the relationship between the data sheet and the graph
- Manage data series and points to represent data accurately
- Identify and use various chart elements for clarity and detail
- Select appropriate chart types based on data characteristics
- Customize chart options to meet specific reporting needs
- Add titles to charts for clear identification
- Configure axes to display data ranges accurately
- Use grid lines to enhance readability of the chart
- Include a legend to explain different data series
- Label data points for precise information
- Display a data table within the chart for additional context
Printing
- Print documents and reports accurately and efficiently for government use
- Use the Page Setup dialog to configure print settings
- Preview prints to ensure correctness before final output
- Utilize the printing dialog box to manage print jobs effectively
Using Lists
- Create and manage lists for organized data handling in government applications
- Transform ranges into lists to improve data management
- Apply forms to input and edit list data efficiently
- Use AutoFilter to quickly filter and view specific data entries
- Implement advanced filters for complex data selection criteria
- Sort data within lists to organize information logically
- Calculate subtotals to summarize data effectively
- Utilize database functions to perform operations on list data
Pivot Tables
- Create and modify PivotTables for dynamic data analysis in government reports
- Use calculated fields and calculated members to derive additional insights from data
Requirements
Understanding of Windows for Government Use
The proficiency in Microsoft Windows is essential for government employees to effectively manage and secure information technology systems. This knowledge encompasses a range of skills, from basic operations to advanced system configurations and troubleshooting. Familiarity with the latest versions of Windows, including their security features and compliance requirements, ensures that government agencies can maintain robust IT infrastructures that support efficient public service delivery and uphold high standards of data protection.
14 Hours
Testimonials (5)
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
active interaction between trainer and participants
DEEWEELYN DE LUNA - TRACTEBEL RED INC.
Course - Financial Analysis in Excel
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
examples and looking for solutions
Monika Lesniewska - Takenaka Europe GmbH Sp. z o.o. Oddzial w Polsce
Course - Excel Data Analysis
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
