Description
Duration: 1 day
About the Course
Sharpen your skill set for the most popular spreadsheet software used in business all over the world. You will be receiving hands-on training in calculation, analysis, and visual data representation. The lessons taught in this course will allow you to confidently present budgets, analyze financial statements, and prepare sales invoices for decision-makers in your organization.
Audience Profile
This course is intended for those who wish to be proficient in Excel 2019.
Learning Objectives
- Manage worksheets and workbooks
- Perform operations by using formulas and functions
- Manage data cells and ranges
- Calculate and transform data
- Filter and sort table data
This course prepares you for the following certification exam:
Exam MO-200: Microsoft Excel (Excel and Excel 2019)
Prerequisites
There are no prerequisites for this course.
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
Training Solutions
With several convenient training delivery methods offered, The Academy makes getting the IT training you need easy. Whether you prefer to learn in a classroom or online live learning virtual environment. Our training videos are hosted online and private group classes hosted at your site are also available. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum while sharing their expertise and insights with trainees. No matter how you prefer to receive training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor-Led (the best training format we offer)
- Live Online Classroom – Online Instructor-Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/25/2023 | 12/25/2023 | ||||
| 1/15/2024 | 1/15/2024 | ||||
| 2/5/2024 | 2/5/2024 | ||||
| 2/26/2024 | 2/26/2024 | ||||
| 3/18/2024 | 3/18/2024 | ||||
| 4/8/2024 | 4/8/2024 | ||||
| 4/29/2024 | 4/29/2024 | ||||
| 5/20/2024 | 5/20/2024 | ||||
| 6/10/2024 | 6/10/2024 | ||||
| 7/1/2024 | 7/1/2024 | ||||
| 7/22/2024 | 7/22/2024 | ||||
| 8/12/2024 | 8/12/2024 | ||||
| 9/2/2024 | 9/2/2024 | ||||
| 9/23/2024 | 9/23/2024 | ||||
| 10/14/2024 | 10/14/2024 | ||||
| 11/4/2024 | 11/4/2024 | ||||
| 11/25/2024 | 11/25/2024 | ||||
| 12/16/2024 | 12/16/2024 | ||||
| 1/6/2025 | 1/6/2025 |
Curriculum
1. Getting Started with Excel 2019
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Enter Cell Data
- Topic E: Use Excel Help
2. Performing Calculations
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
3. Modifying a Worksheet
- Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
4. Formatting a Worksheet
- Topic A: Apply Text Formats
- Topic B: Apply Number Formats
- Topic C: Align Cell Contents
- Topic D: Apply Styles and Themes
- Topic E: Apply Basic Conditional Formatting
- Topic F: Create and Use Templates
5. Printing Workbooks
- Topic A: Preview and Print a Workbook
- Topic B: Set Up the Page Layout
- Topic C: Configure Headers and Footers
6. Managing Workbooks
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
