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
1 - GETTING STARTED WITH EXCEL 2019
- Topic A: Navigate the Excel User Interface for government operations.
- Topic B: Use Excel Commands efficiently in a public sector environment.
- Topic C: Create and Save a Basic Workbook to support government tasks.
- Topic D: Enter Cell Data accurately for reliable data management for government.
- Topic E: Utilize Excel Help resources to enhance productivity for government users.
2 - PERFORMING CALCULATIONS
- Topic A: Create Worksheet Formulas to automate calculations for government projects.
- Topic B: Insert Functions to streamline data analysis for government reports.
- Topic C: Reuse Formulas and Functions to maintain consistency in government documents.
3 - MODIFYING A WORKSHEET
- Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows to manage data effectively for government use.
- Topic B: Search for and Replace Data to ensure accuracy in government records.
- Topic C: Use Proofing and Research Tools to enhance the integrity of government data.
4 - FORMATTING A WORKSHEET
- Topic A: Apply Text Formats to improve readability for government documents.
- Topic B: Apply Number Formats to ensure clarity in financial and statistical data for government reporting.
- Topic C: Align Cell Contents to maintain a professional appearance in government worksheets.
- Topic D: Apply Styles and Themes to enhance the visual appeal of government reports.
- Topic E: Apply Basic Conditional Formatting to highlight key information for government decision-making.
- Topic F: Create and Use Templates to standardize document creation for government processes.
5 - PRINTING WORKBOOKS
- Topic A: Preview and Print a Workbook to ensure accurate representation of data for government presentations.
- Topic B: Set Up the Page Layout to optimize printing for government documents.
- Topic C: Configure Headers and Footers to include essential information in government reports.
6 - MANAGING WORKBOOKS
- Topic A: Manage Worksheets to organize data efficiently for government projects.
- Topic B: Manage Workbook and Worksheet Views to enhance collaboration among government teams.
- Topic C: Manage Workbook Properties to maintain metadata and ensure compliance with government standards.
7 Hours
Testimonials (1)
I really appreciated that the excel spreadsheet with each module was shared with us to follow along and reference again for the formulas, etc. Lots of tips & tricks!
