Excel - Part 1

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

Duration
1 Hour

Delivery Method
Virtual Instructor Led

This class is part of a 12‑month Educate 360 Pro Subscription

$495

Buy Now

Request More Information

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.

Educate 360 Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your Educate 360 Pro subscription.

Unlimited enrollments into over 90 full-day and short-duration live training classes
Over 750 hours of on-demand video based content
A full library of digital quick reference cards for your favorite Office applications
Access to class recordings so you never have to worry about missing a scheduled class

Our Educate 360 Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

Ask questions and get immediate answers during our full-day and short-duration live classes
Learn how to perform specific tasks instead of wasting time learning things you already know
Collaborate with fellow students and gain insight into new ways to solve problems
View on-demand courses with instructors that never leave your screen
Utilize course assessments to validate new skills
Take full day training classes on your schedule by accessing our class recordings
Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about Educate 360 Pro.

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