Reviews of our Excel class - Introduction
Excel class - Introduction - Introduction rating: 5 stars from 45 reviewers
"He was great! He is SOOO patient and had no problem answering questions if someone was stuck! Would definitely take another course from him! " - Noelle C
See all reviews for Excel classesAll Excel classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Excel class - Introduction
Introductory Excel Class
This Excel course teaches you the foundations of Excel including essential Excel formulas and how to work efficiently and effectively using Excel. You also learn techniques for working with and managing data in Excel, including how to use calculations, apply formatting to content, and how to create charts. The course includes multiple projects that help you practice and apply the skills you learn in this live, hand-on class. This one-day course provides a solid foundation for jobs that require Excel.
What you learn in this introductory Excel course
- Calculations and formulas: Discover how to use Excel for calculations including sum, average, and counts as well as how to calculate and tabulate data easily with built-in formulas.
- Efficient data entry: Learn how Excel can automatically complete text and numbers, reducing data entry work while improving accuracy.
- Text Functions: Find out how to use functions for formatting, standardizing and correcting text, including removing extra spaces and changing case to standardize input to lowercase, uppercase, or title case.
- Formatting text, numbers, and cells: Understand how to apply formatting and color to text and cells and set the alignment of text and numbers within cells vertically and horizontally.
- Format Painter: Discover how to copy formatting between cells in an Excel worksheet quickly.
- Conditional formatting: Learn to define cell formatting that changes depending upon criteria you define. For example, set all positive values to green with negative values set to red.
- Charts and graphs: Learn the basics of creating charts and graphs in Excel for data visualization. Find out how to create charts, including pie charts, line graphs, and bar charts.
- Quick access toolbar: Discover how to work more efficiently by saving commonly used functions and commands with the Quick Access Toolbar.
- Cell referencing: Learn to create references to cells, allowing you to keep formulas accurate even as cell content changes and making it possible to copy formulas to other cells.
- Lock values: Learn to lock the values in specific cells so they can be consistently referenced or used in formulas.
- Excel efficiency tips: Learn to work efficiently having Excel automate your work.
Who benefits from this introductory Excel class
- This is the perfect Excel class for beginners who have no previous Excel experience.
- Business professionals using Excel who have no formal training and want to be more productive.
- Anyone who need to enter, organize, filter, sort, calculate, analyze, or present data.
Why this introductory Excel course is the best option for you
- Hands-on learning: Learn Excel quickly with our proven teaching methods.
- Exceptional curriculum: AGI has delivered Excel training to thousands over 25 years.
- Expert instructors: Our instructors are Excel experts and skilled educators.
- Small class sizes: Receive personalized attention with 10 or fewer participants per class.
- Repeat for Free: If you need a refresher or miss a class day, retake the Excel class at no cost.
Ways to attend this Excel Course
- Live Online classes from your office or home as a regularly scheduled small group class.
- Live, in-person regularly scheduled Excel classes in Boston or Philadelphia with a live instructor in the same classroom.
- Private training customized to your specific needs delivered in-person or online. Call 781-376-6044 or complete the Private Excel Training form for more information.
- Corporate Excel Training for your group or team.
Excel class - Introduction - Course Dates
All classes are led by a live instructor. Class times listed are Eastern time.
Microsoft Excel class: Introduction - Key topics covered
- Calculations and formulas: Discover how to use calculations to accurately calculate averages, sums, and counts, and discover more advanced functions to enhance your data analysis.
- Formatting text, numbers, and cells: Understand formatting techniques to make spreadsheets more visually appealing. Learn how to efficiently change cell colors, borders, format text and numbers, and set alignment both vertically and horizontally to make your data more professional.
- Format Painter: Utilize the Format Painter tool to quickly copy formatting from one cell or range to another. This feature is essential for maintaining consistent styling throughout your worksheets without manually applying each format.
- Conditional formatting: Understand the art of conditional formatting to highlight important data trends and patterns. Set up rules to automatically format cells depending on criteria you define, such as coloring high sales figures in green and low ones in red, to make your data analysis more intuitive.
- Charts and graphs: Develop skills to create and customize various types of charts, including line, bar, and pie charts. Learn how to visually represent your data, making it easier to interpret and present your findings effectively to others.
- Faster and more accurate data entry: Utilize Excel's Autofill feature to effortlessly complete data patterns and sequences, saving time and reducing errors. Perfect for quickly filling in dates, numbers, and repetitive data entries.
- Text Functions: Learn powerful text functions to manipulate and format data efficiently. Find out how to change text case, remove unnecessary spaces, extract specific characters from cells, and more, ensuring your data is clean and well-organized.
- Cell referencing: Understand the importance of cell references to create dynamic and flexible formulas. Learn how to use absolute, relative, and mixed references to ensure your formulas adjust correctly when copied to other cells, making your calculations more efficient and error-free.
- Quick Access Toolbar: Customize the Quick Access Toolbar to keep your most-used commands at your fingertips. This feature allows you to speed up your workflow by having instant access to essential tools and functions.
- Lock values: Learn to specify the values in specific cells so they can be consistently referenced across your worksheet or even be used in formulas.
- Excel efficiency tips: Learn to work efficiently having Excel automate your work for you.
Introductory Excel class - complete topics covered:
Topics covered in the introductory Microsoft Excel course include the following:
Getting started with Excel
Understand various ways of entering data in Excel. Find out how to use multiple worksheets in Excel, and learn to organize data by creating, moving, copying, and managing Excel worksheets. Find out how to work more efficiently by using repeat actions in Excel to duplicate prior actions quickly. Find out how to save time using Excel Shortcuts as you discover keyboard shortcuts that save time and help you to work more efficiently.
Getting to know the workspace
- Understanding the Excel interface
- Data entry using Excel
- Moving around a worksheet using keyboard shortcuts
- Editing in the formula bar
- Using AutoFill
- Naming worksheets and saving the workbook
Creating a worksheet in Excel
Understand various ways of entering data in Excel and printing from Excel as you learn how to easily print or convert Excel content to PDF. Find out how to use multiple worksheets in Excel, and learn to organize data by creating, moving, copying, and managing Excel worksheets. Find out how to work more efficiently by using repeat actions in Excel to quickly duplicate prior actions. Find out how to save time using Excel Shortcuts as you discover keyboard shortcuts that save time and help you to work more efficiently.
- Creating a worksheet
- Selecting cells, ranges, collections, rows, and columns
- Inserting/deleting rows and columns
- Inserting, deleting, hiding, copying, and moving worksheets
Formatting in Excel
Learn about formatting Excel sheets and content. Learn to visually distinguish specific text and numbers by applying formatting. Learn how to use the Format Painter in Excel: Learn to duplicate formatting from any cell and apply it to others. Applying Conditional Formatting: Discover how to apply formatting depending upon rules relating to content.
- Formatting text, dates, and numbers
- Changing column width and row height
- Editing cell alignment
- Using cell styles
- Applying borders and using shading
- Using the Format Painter in Excel
- Applying conditional formatting
- Applying themes
- Using text functions
- Creating and using templates
Working with charts
Learn to create line charts and sparklines to represent data visually. Find out about various chart types, including creating Column Charts using Excel as you learn to create column charts for data visualization. Discover how to create pie charts, bar charts, and line graphs for data visualization.
- Understanding chart types
- Creating charts in Excel
- Customizing charts
- Printing a chart from a chart sheet or a sheet
- Using Sparklines
Working with formulas and functions
Learn to create Excel calculations, formulas, and functions, including using Excel formulas to perform mathematical expressions.
Use True / False in Excel to check for matching data. Find out how to use Excel Functions, including AutoSum and text functions that can modify text based on input values. Also, learn about multi-Input Functions, which require multiple inputs and Constant Cell References that can be used for calculations.
- Creating formulas
- Using the order of operations in formulas
- Using functions in Excel, including SUM, AVERAGE, MAX, MIN, COUNT and IF
- Understanding cell references
- Using formula auditing to edit formulas and functions
- Printing your spreadsheet
- Protecting your workbook
Custom and private Excel classes
This Excel course is available as a private class. Curriculum can be customized for your specific needs. Excel classes can be delivered at your location, online, or in our classrooms. For more information, call 781-376-6044 to speak with a training consultant or contact us.
Course prerequisites
If you are attending online, this is a live class led by an instructor, and you will want to have Microsoft Excel installed before the course so that you can follow along with the class exercises and projects that are part of the course.
If you are attending in person at one of our classrooms, a computer with Excel is provided.
You can attend this Excel class with a live instructor online or in-person. You can also schedule this as a corporate Excel training for your group or organization or as private Excel training.
Introductory Excel course materials
You will receive a comprehensive Excel course manual for this class.
Frequently Asked Questions for Excel class - Introduction
Which Excel course covers Pivot tables and V LOOKUP?
You will learn Pivottables and VLOOKUP in the intermediate Excel course. These topics are covered in-depth with hands-on projects, and the ability to ask questions from a live instructor.