Excel: Skills Development & Training Course

Learn Excel Skills for Business. Master Excel to add a highly valuable asset to your employability portfolio.

Purchase Course

Full lifetime access
Access on mobile and TV
Accredited certification

37,872 students already enrolled

View course reviews and ratings:
4.7/5 • 24,498 Reviews • Teaching since 2009

95%

Got a tangible career benefit from this course.
98%

Got a job, internship, or promotion after this course.
89%

Started a new career after completing this specialization.

OFFERED BY

Have a look at the course: Excel training course, which is also offered by Aspire Group of Colleges and the ATHE

Learn more about the college

97% Job Success & Satisfaction after taking UPI Courses 👏

Reviewed by 30K+ students ✨

Our students work at

Meet with professionals and get job referrals at Oracle, Amazon and more.

Talk to other students taking this or similar course 🎙

A community of 80K+ students✨

JOIN THE COMMUNITY

Course curriculum

1. Introduction
1. What Is a Workbook?
2. Why Use a Blank Workbook?
3. How to Set Up a Blank Workbook
4. Why Use a Template?
5. How to Set Up a Template
6. Lesson Summary
7. Quiz 1.1
1. Excel
2. Opening Files
3. Importing Files
4. Lesson Summary
5. Quiz 1.2
1. Worksheets in Excel
2. Add, Copy, Move
3. Combining Documents
4. Lesson Summary
5. Lesson at a Glance
6. Learning Outcomes
7. Quiz 1.3
1. Microsoft Excel
2. Workbooks vs. Worksheets
3. Multiple Workbooks
4. Lesson Summary
5. Crucial Parts of an Excel Workbook
6. Lesson Outcome
7. Quiz 1.4
1. Introduction
1. Workbook vs. Worksheet
2. Excel Worksheets
3. Adding, Deleting and Naming Worksheet Tabs
4. Adding Color and Modifying the Text
5. Lesson Summary
6. Learning Outcomes
7. Quiz 2.1
1. Page Layout / Page Setup
2. Margins
3. Orientation
4. Print Titles
5. Lesson Summary
6. Learning Outcomes
7. Quiz 2.2
1. Add or Remove a Row or Column
2. Ribbon or Right-Click?
3. Using the Ribbon Commands
4. Using the Right Click Method
5. Short-Cut Keyboard Commands
6. Lesson Summary
7. Learning Outcome
8. Quiz 2.3
1. Themes
2. Theme Choices
3. Theme Colors and Fonts
4. Theme Effects
5. Lesson Summary
6. Learning Outcomes
7. Quiz 2.4
1. Row Height & Column Width
2. Basic Rules
3. Column Width
4. Row Height
5. Lesson Summary
6. Learning Outcomes
7. Quiz 2.5
1. Watermarks
2. Using WordArt
3. Adding an Image to the Header
4. Lesson Summary
5. Learning Outcomes
6. Quiz 2.6
1. Background on Headers and Footers
2. The Page Layout View
3. Adding a Header
4. Adding a Footer
5. Lesson Summary
6. Learning Outcomes
7. Quiz 2.7
1. What Is Data Validation?
2. Whole Numbers within Limits
3. Text of a Specified Length
4. Types of Alert Messages
5. Lesson Summary
6. Learning Outcomes
7. Quiz 2.8
1. Introduction
1. Printing Only What You Need
2. Setting a Print Area
3. Clearing Your Set Print Area
4. Lesson Summary
5. Learning Outcomes
6. Quiz 3.1
1. Saving in Excel
2. How to Save Your Excel Workbook
3. Naming Your File
4. Save vs. Save As
5. Optional File Formats
6. Lesson Summary
7. Learning Outcomes
8. Quiz 3.2
1. Printing from Excel
2. Printing One Worksheet
3. Printing Multiple Worksheets
4. Lesson Summary
5. Learning Outcomes
6. Quiz 3.3
1. Scale to Fit Print Options
2. Using the Print Settings
3. Using the Page Layout Menu
4. Scaling Using Percentages
5. Lesson Summary
6. Learning Outcomes
7. Quiz 3.4
1. Backwards Compatibility
2. Check Compatibility Feature
3. How to Run a Compatibility Check
4. Lesson Summary
5. Learning Outcomes
6. Quiz 3.5
1. Printing Excel Documents
2. Workbook vs. Worksheet
3. How to Print an Excel Workbook
4. Tips to Printing Excel Documents
5. Lesson Summary
6. Learning Outcomes
7. Quiz 3.6
1. Printing Excel Spreadsheets
2. The Print Preview
3. Print Settings and Options
4. Wrap Up
5. Lesson Summary
6. Learning Outcomes
7. Quiz 3.7
1. File Formats
2. PDF, CSV and Older Versions of Excel
3. The Save As Function
4. Lesson Summary
5. Learning Outcomes
6. Quiz 3.8
1. Sharing Excel Files
2. Send as Attachment
3. Send as PDF
4. Lesson Summary
5. Learning Outcomes
6. Quiz 3.9
1. Introduction
1. Merge vs. Combine
2. Merge and Center
3. Combine
4. Lesson Summary
5. Learning Outcomes
6. Quiz 4.1
1. Cell Alignment
2. Vertical Alignment
3. Horizontal Alignment
4. Lesson Summary
5. Learning Outcomes
6. Quiz 4.2
1. Fonts in Excel
2. Changing the Font Type or Size
3. Changing the Default Font
4. Lesson Summary
5. Learning Outcomes
6. Quiz 4.3
1. The Format Painter Tool
2. Format Painter with Adjacent Cells
3. Format Painter with Non-Adjacent Cells
4. Lesson Summary
5. Learning Outcomes
6. Quiz 4.4
1. Wrapping Text
2. The Format Cells Command
3. Formatting to Wrap Text
4. Lesson Summary
5. Learning Outcomes
6. Quiz 4.5
1. Formatting Numbers
2. Format Cells Dialogue Box
3. Number
4. Currency
5. Date
6. Lesson Summary
7. Learning Outcomes
8. Quiz 4.6
1. The Highlight Term
2. Highlighting to Select
3. Highlighting to Draw Attention
4. Lesson Summary
5. Learning Outcomes
6. Quiz 4.7
1. Cell Styles
2. Applying Cell Styles
3. Modifying Cell Styles with Accents
4. Lesson Summary
5. Learning Outcomes
6. Quiz 4.8
1. WordArt
2. How to Add WordArt
3. How to Modify WordArt
4. Lesson Summary
5. Learning Outcomes
6. Quiz 4.9
1. Introduction
1. Append and Consolidate
2. The Consolidate Command
3. After You Consolidate
4. Consolidating Multiple Excel Files
5. Lesson Summary
6. Learning Outcomes
7. Quiz 5.1
1. Find & Select Tool
2. Finding Information
3. Find and Replace
4. Using the Find Options
5. Lesson Summary
6. Learning Outcomes
7. Quiz 5.2
1. Copy and Paste
2. The Clipboard
3. The Copy & Paste Commands
4. Paste Value & Formatting
5. Paste Formula & Formatting
6. Lesson Summary
7. Learning Outcomes
8. Quiz 5.3
1. The Autofill Feature
2. Filling Data Down a Column
3. Using the Autofill to Copy Data
4. Filling Data Across a Row
5. Lesson Summary
6. Learning Outcomes
7. Quiz 5.4
1. Adding and Removing Cells
2. Using the Ribbon Commands
3. Using the Right-Click
4. Lesson Summary
5. Learning Outcome
6. Quiz 5.5
1. What Is the 'AND' Function?
2. Example
3. Results
4. Lesson Summary
5. Quiz 5.6
1. Introduction
1. The Filter Tool
2. You Need a Header Row
3. How to Run a Filter
4. Running Multiple Filters
5. Lesson Summary
6. Learning Outcomes
7. Quiz 6.1
1. Sorting in Excel
2. Sort Using One Column
3. Sort Using Multiple Columns
4. Lesson Summary
5. Learning Outcomes
6. Quiz 6.2
1. Duplicate Records
2. Hide or Remove
3. Using the Advanced Filter
4. Using the Remove Duplicates Command
5. Lesson Summary
6. Learning Outcomes
7. Quiz 6.3
1. Introduction
1. Conditional Formatting
2. Highlight Cells Rule
3. Conditional Formatting Menu
4. Clearing Conditional Formatting
5. Lesson Summary
6. Learning Outcomes
7. Quiz 7.1
1. What Are Sparklines?
2. Lines and Columns
3. Win/Loss
4. Sparkline Design Options
5. Lesson Summary
6. Learning Outcomes
7. Quiz 7.2
1. Flip Flop Data in Excel
2. Transpose Using the Right-Click
3. Transpose Using the Ribbon Commands
4. Lesson Summary
5. Learning Outcomes
6. Quiz 7.3
1. What Are Named Ranges?
2. How to Create a Named Range
3. How to Use Named Ranges in Formulas
4. Lesson Summary
5. Learning Outcomes
6. Quiz 7.4
1. Excel Outline Feature
2. Auto Outline
3. Manual Outline
4. Lesson Summary
5. Learning Outcomes
6. Quiz 7.5
1. Outlines in Excel Worksheets
2. Quick Review
3. Hierarchy or Level Buttons
4. Expand and Collapse Controls
5. Lesson Summary
6. Learning Outcomes
7. Quiz 7.6
1. The Subtotal Feature
2. Sort Your Data First
3. How to Insert Subtotals
4. Summary, Outline and Totals
5. Beyond Sum
6. Lesson Summary
7. Learning Outcome
8. Quiz 7.7
1. Introduction
1. Tables in Excel
2. Benefits to Creating a Table
3. How to Create a Table in a Worksheet
4. Table Style Design Options
5. Lesson Summary
6. Learning Outcomes
7. Quiz 8.1
1. Working With Tables in Excel
2. Quick Review
3. Adding Data
4. Deleting Rows and Columns
5. Resizing Tables
6. Lesson Summary
7. Learning Outcomes
8. Quiz 8.2
1. Introduction
1. Tables in Excel
2. Quick Review - How To Insert a Table
3. Table Style Gallery
4. Lesson Summary
5. Learning Outcomes
6. Quiz 9.1
1. Color Banding
2. Using Tables to Band Rows
3. Using Conditional Formatting to Band Rows
4. Lesson Summary
5. Quiz 9.2
1. Introduction
1. Formulas
2. Benefits
3. The Basics of Formulas
4. More on Functions
5. Lesson Summary
6. Learning Outcomes
7. Quiz 10.1
1. Relative, Absolute and Mixed
2. Understanding Cell References
3. Relative
4. Absolute
5. Mixed
6. Lesson Summary
7. Learning Outcomes
8. Quiz 10.2
1. Mathematical Calculations
2. Defining Order of Operations
3. Complex Calculations
4. Using Parentheses to Change the Order
5. Applying Order to Cell References
6. Lesson Summary
7. Learning Outcomes
8. Quiz 10.3
1. Cell References
2. Numbers and Letters, Columns and Rows
3. Cell Ranges
4. Referencing a Cell in Another Worksheet
5. Lesson Summary
6. Learning Outcomes
7. Quiz 10.4
1. Introduction
1. The SUM Function
2. Adding Numbers Together
3. Using SUM to Subtract
4. Performing More than One Calculation
5. Other Examples
6. Lesson Summary
7. Learning Outcome
8. Quiz 11.1
1. MIN and MAX Functions
2. Using MIN and MAX in Formulas
3. Using Single Cells References and Numbers
4. Combining with the IF Function
5. Lesson Summary
6. Learning Outcomes
7. Quiz 11.2
1. The COUNT Group of Functions
2. Counting Numbers
3. COUNTA
4. COUNTBLANK
5. Lesson Summary
6. Learning Outcomes
7. Quiz 11.3
1. Finding the Average
2. The AVERAGE Function
3. Using AVERAGE in a Formula
4. More Complex Formulas
5. Lesson Summary
6. Learning Outcomes
7. Quiz 11.4
1. Introduction
1. SUMIF
2. SUMIF in a Formula
3. Adding Values That Are Greater or Less Than
4. Adding Values Where the Criteria Is Text
5. More Example Formulas
6. Lesson Summary
7. Learning Outcomes
8. Quiz 12.1
1. Average When Conditions Are Met
2. Review of the Average Function
3. The AVERAGEIF Function
4. Step by Step
5. Lesson Summary
6. Learning Outcomes
7. Quiz 12.2
1. The COUNTIF Function
2. The Basics
3. Where the Criteria Is Text
4. Where the Criteria Is Numbers
5. More Formula Examples
6. Lesson Summary
7. Learning Outcomes
8. Quiz 12.3
1. Introduction
1. Extracting Data
2. Left Function
3. Mid Function
4. Right Function
5. Lesson Summary
6. Learning Outcomes
7. Quiz 13.1
1. Dealing With Messy Data
2. The TRIM Function
3. The CLEAN Function
4. TRIM and CLEAN Used Together
5. Lesson Summary
6. Learning Outcomes
7. Quiz 13.2
1. Text Functions
2. The Upper Function
3. The Lower Function
4. The Proper Function
5. Lesson Summary
6. Learning Outcomes
7. Quiz 13.3
1. To Concatenate
2. Using Concatenate in Formulas
3. Example Worksheet
4. Example Formulas
5. Lesson Summary
6. Learning Outcomes
7. 13.4 quiz
1. Visual Data
2. Chart or Graph
3. Chart Types
4. Inserting a Chart
5. Lesson Summary
6. Learning Outcomes
7. Quiz 14.1
1. Charts in Excel
2. Quick Review: Inserting a Chart
3. Chart Tools
4. Changing the Chart Type
5. Lesson Summary
6. Learning Outcomes
7. Quiz 14.2
1. Making the Switch
2. Excel Charts - Refresher
3. The Switch Row/Column Command
4. Lesson Summary
5. Learning Outcomes
6. Quiz 14.3
1. The Quick Analysis Tool
2. Accessing the Quick Analysis Tool
3. Numbers, Numbers, Numbers!
4. How to Select an Analytical Element
5. Lesson Summary
6. Learning Outcomes
7. Quiz 14.4
1. Introduction
1. Working in Excel
2. Excel Scenarios
3. Lesson Reflection
1. Excel Formatting
2. Formatting in Excel Scenarios
1. Excel Cell Formatting
2. Cell Formatting Scenarios
3. Lesson Reflection
1. Table Talk
2. Excel Table Scenarios
1. Chart Smarts
2. Hands-On Scenarios with Excel Charts
3. Lesson Reflection
4. Final Exam

About this course

$74.00
495 lessons
Skill growth guaranteed

Explore More Courses

We promise top learning experience 🏆

Get answers to your questions👋

FREQUENTLY ASKED QUESTIONS

What will I get if I purchase the Certificate?

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Will I receive a transcript from a college for completing this course?

Yes. Completion of a UPI course does earn you academic credit from colleges; therefore, colleges is able to provide you with a university transcript. Also, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
When will I have access to the lectures and assignments?

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you see the free preview option: The course may offer 'Some Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get an idea about the course.

Full lifetime access

Access on mobile and TV

Accredited certification

95%

98%

89%

CHAPTER 1 - Creating Worksheets & Workbooks in Excel

Ch 1.1 - Creating Workbooks in Excel: Blank Workbooks and Templates

Ch 1.2 - How to Import and Open Files Directly in Excel

Ch 1.3 - How to Add, Copy, and Move Worksheets Within Excel Workbooks

Ch 1.4 - What is a Workbook in Excel? - Characteristics and Options

Ch 2 - Formatting Worksheets & Workbooks in Excel

Ch 2.1 - How to Modify the Worksheet Tab in Excel

Ch 2.2 - Modifying Page Setup Properties in Excel

Ch 2.3 - How to Insert & Delete Columns & Rows in Excel

Ch 2.4 - Workbook Themes: Applying & Changing Themes in Excel

Ch 2.5 - Adjusting Column Width & Row Height in Excel

Ch 2.6 - How to Insert Watermarks in Your Excel Worksheet

Ch 2.7 - How to Insert Headers & Footers in Excel

Ch 2.8 - Using Data Validation in Excel

CHAPTER 3 - Configure to Print & Save in Excel

Ch 3.1 - Setting a Print Area in Excel

Ch 3.2 - Saving an Excel Workbook: File Formats & Options

Ch 3.3 - How to Print Individual Worksheets in Excel

Ch 3.4 - How to Set Print Scaling in Excel

Ch 3.5 - Ensuring Your Excel Workbook is Backwards Compatible

Ch 3.6 - Printing in Excel: How to Configure Workbooks to Print

Ch 3.7 - How to Modify Print Settings in Excel

Ch 3.8 - How to Save Excel Workbook Files in Different Formats

Ch 3.9 - How to Share Your Excel Workbook

CHAPTER 4 - Format Cells & Ranges in Excel

Ch 4.1 - How to Merge Cells in Excel

Ch 4.2 - How to Modify Cell Alignment & Indentation in Excel

Ch 4.3 - Fonts and Font Styles in Excel

Ch 4.4 - How to Use the Format Painter in Excel

Ch 4.5 - Wrapping Text in Excel: How to Wrap Text within Cells

Ch 4.6 - The Number Format in Excel: Options & Properties

Ch 4.7 - How to Highlight Cells in Excel

Ch 4.8 - Cell Styles in Excel: Applying & Modifying Styles

Ch 4.9 - How to Change Text to WordArt in Excel

CHAPTER 5 - Insert Data in Cells and Ranges in Excel

Ch 5.1 - How to Append Multiple Worksheets

Ch 5.2 - How to Find and Replace Data in Excel

Ch 5.3 - How to Copy and Paste Data in Excel

Ch 5.4 - Using the AutoFill Tool in Excel

Ch 5.5 - Cells in Excel: How to Insert and Delete Cells

Ch 5.6 - Using the AND function in Excel

CHAPTER 6 - Filter and Sort a Table in Excel

Ch 6.1 - How to Filter Records and Data in Excel

Ch 6.2 - How to Sort Data in Excel

Ch 6.3 - Removing Duplicate Data in Excel

CHAPTER 7 - Order & Group Cells & Ranges in Excel

Ch 7.1 - Conditional Formatting in Excel: Applying & Modifying Formatting

Ch 7.2 - Sparklines in Excel: How to Insert & Modify a Sparkline

Ch 7.3 - How to Transpose Columns & Rows in Excel

Ch 7.4 - Creating & Modifying Named Ranges in Excel

Ch 7.5 - Outlines in Excel: How to Create an Outline

Ch 7.6 - Outlines in Excel: How to Collapse Groups of Data in an Outline

Ch 7.7 - How to Insert a Subtotal in an Excel Worksheet

CHAPTER 8 - Create a Table in Excel

Ch 8.1 - How to Create a Table in an Excel Worksheet

Ch 8.2 - How to Add & Remove Columns & Rows in an Excel Table

CHAPTER 9 - Modify a Table in Excel

Ch 9.1 - How to Apply a Style to an Excel Table

Ch 9.2 - How to Band Rows & Columns in an Excel Table

CHAPTER 10 - Use Cell Ranges & References for Formulas & Functions in Excel

Ch 10.1 - How to Use Formulas & Functions in Excel

Ch 10.2 - Cell References in Excel: Relative, Absolute & Mixed

Ch 10.3 - Defining Order of Operations in Excel

Ch 10.4- Referencing Cell Ranges and Other Worksheets in Formulas

CHAPTER 11 - Summarize Data with Functions in Excel

Ch 11.1 - Using the SUM Function in Excel

Ch 11.2 - Using the MIN and MAX Functions in Excel

Ch 11.3 - Using the COUNT Function in Excel

Ch 11.4 - Using the AVERAGE Function in Excel

CHAPTER 12 - Functions with Conditional Logic in Excel

Ch 12.1 - How to Use the SUMIF Function in Excel

Ch 12.2 - How to Use the AVERAGEIF Function in Excel

Ch 12.3 - How to Use the COUNTIF Function in Excel

CHAPTER 13 - Format & Modify Text with Functions in Excel