Excel - Level 1

Course Description

Excel - Level 1 is an introductory, instructor-led Microsoft course designed for individuals early in their careers, transitioning to a new role, or looking to strengthen their resume. Ideal for learners pursuing accounting, administration, data analytics, finance, marketing, project management, and related careers. This hands-on course builds foundational Microsoft Excel skills used in today’s workplace. This practical course covers:

• Navigating the Microsoft Excel interface
• Managing and organizing workbooks
• Entering and structuring data
• Performing calculations with formulas and functions
• Formatting worksheets and applying basic conditional formatting
• Creating and using templates
• Preparing spreadsheets for printing

Through live instruction and hands-on practice, participants gain introductory spreadsheet skills that boost Microsoft Office proficiency and enhance career growth in a data-driven world.

Participant Outcomes

Upon successful completion of this course, you will be able to:

• Make Calculations: Use Excel to add, subtract, and perform other calculations with data.
• Update Worksheets: Edit and adjust data quickly and easily.
• Format for Clarity: Make worksheets look organized and easy to read.
• Print Workbooks: Prepare spreadsheets for printing or sharing.
• Manage Multiple Workbooks: Keep files organized and work with several spreadsheets efficiently.

Course Content

Lesson 1: Getting Started with Excel

• Explore the Excel Interface: Learn your way around Excel’s layout and tools.
• Use Excel Commands: Access the features you need to work efficiently.
• Create and Save Workbooks: Start new spreadsheets and keep your work safe.
• Enter Data: Add information into cells with confidence.
• Get Help: Find guidance and tips using Excel’s built-in help tools.

Lesson 2: Performing Calculations

• Build Formulas: Use Excel to do calculations automatically.
• Insert Functions: Apply ready-made formulas to save time.
• Reuse Formulas: Copy and adapt formulas across your worksheets.

Lesson 3: Modifying a Worksheet

• Edit Cells, Columns, and Rows: Insert, delete, and adjust as needed.
• Search and Replace: Quickly find and update your data.
• Proof and Research Tools: Check your work and get extra info when needed.

Lesson 4: Formatting a Worksheet

• Format Text: Make your spreadsheet easier to read.
• Format Numbers: Display data clearly and accurately.
• Align Content: Organize your information neatly in cells.
• Apply Styles and Themes: Give your worksheets a polished, professional look.
• Use Conditional Formatting: Highlight important data automatically.
• Create Templates: Save time by reusing pre-designed layouts.

Lesson 5: Printing Workbooks

• Preview and Print: Make sure your worksheets look right on paper.
• Set Up Page Layouts: Control how your work appears when printed.
• Add Headers and Footers: Include titles, dates, and other info for clarity.

Lesson 6: Managing Workbooks

• Work with Multiple Worksheets: Organize and navigate your tabs.
• Adjust Views: Switch between different ways of seeing your data.
• Manage Workbook Properties: Keep your files organized and professional.