Excel - Part 1

Name: Excel - Part 1
Price: 295.00 USD
Availability: InStock
Rating: 4.5 (1200 reviews)

Price
$295.00 USD

Duration
1 Day

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

Course Overview

Ready to start building your Excel skills from the ground up? This beginner Excel training course provides the foundation you need to grow your knowledge and become an expert in data manipulation over time. You'll learn how to create and format worksheets, perform basic calculation operations, work with charts and tables, and organize data efficiently.

This course also covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201.

Master the basics—and open the door to more advanced skills in data analysis, reporting, data visualization, and spreadsheet management.

Course Objectives

In this Excel for beginners course, you’ll learn how to create and format spreadsheets, apply Excel formulas and Excel functions, design and modify Excel charts, and organize information into structured tables and worksheets. You’ll develop the confidence to use Excel like a pro, streamline everyday tasks, and set a strong foundation for advanced tips and future certifications.

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What skills will I learn in Excel Part 1 training?

In Excel Part 1 training, you’ll learn to create and format spreadsheets, build basic Excel formulas and functions, organize data into tables, design simple graphs and charts, manage worksheets, and automate basic processes using templates—all while building the fundamental skills you need for long-term success.

What version of Excel does Excel Part 1 cover?

Excel Part 1 focuses on skills that are consistent across most modern versions of Microsoft Excel, including Excel 2016, Microsoft 365, and beyond. If your team needs a class tailored to a specific version like Excel 2007, we can customize a private training—contact us to learn more.

Is Excel Part 1 suitable for complete beginners?

Yes! This is a true course for beginners, perfect for students with little to no previous experience. You’ll start with the basics and build toward skills that support further learning in pivot tables, dashboards, and data analytics.

Can Excel Part 1 training be customized for my team?

Absolutely! We can tailor the training to match your organization's files, Excel templates, and workflows. We’ll help your team streamline processes, increase productivity, and create professional reports. Reach out here to learn more about private group training options.

How can learning Excel basics impact my career?

Mastering Excel basics can dramatically boost your confidence and open up opportunities in administration, project management, finance, and more. Being skilled in data visualization, spreadsheets, and dashboards is increasingly critical in today’s data-driven economy.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

Basic computer literacy
Basic PC operating system navigation skills
Basic Internet usage skills

Agenda

1 – Getting Started with Excel

Navigate the Excel user interface and organize your workspace efficiently
Use Excel commands and features, and locate tools with shortcut keys
Create and save a basic workbook
Access and use Excel Online for cloud-based collaboration
Enter and edit data entry efficiently in worksheets
Find help and support through built-in tools and Microsoft Support resources

2 – Performing Calculations

Build Excel formulas to perform calculations quickly
Insert and manage Excel functions like SUM, AVERAGE, and logical operators
Reuse and copy formulas and functions using step-by-step techniques

3 – Modifying a Worksheet

Insert, delete, and adjust cells, columns, and rows
Search for and replace data, and use filter tools for data management
Use proofing and research tools to ensure accuracy

4 – Formatting a Worksheet

Apply text and number formatting, including borders and shading for visual emphasis
Align, arrange, and organize worksheet content
Apply colors, borders, and predefined styles for professional spreadsheets
Apply basic conditional formatting to highlight trends
Create and use templates to streamline repetitive tasks

5 – Printing Workbooks

Preview and print worksheets with correct page layout settings
Configure headers and footers to provide context in printed sheets
Customize your sheet layout for clean presentation

6 – Managing Workbooks

Manage multiple sheets and workbooks efficiently
Update workbook properties to maintain organized files
Manage workbook and worksheet views for better navigation