Excel: Skills Development & Training Course
Learn Excel Skills for Business. Master Excel to add a highly valuable asset to your employability portfolio.
Learn Excel Skills for Business. Master Excel to add a highly valuable asset to your employability portfolio.
View course reviews and ratings:
4.7/5 • 24,498 Reviews • Teaching since 2009
Got a tangible career benefit from this course.
Got a job, internship, or promotion after this course.
Started a new career after completing this specialization.
Have a look at the course: Excel training course, which is also offered by Aspire Group of Colleges and the ATHE
Meet with professionals and get job referrals at Oracle, Amazon and more.
Introduction
What Is a Workbook?
Why Use a Blank Workbook?
How to Set Up a Blank Workbook
Why Use a Template?
How to Set Up a Template
Lesson Summary
Quiz 1.1
Excel
Opening Files
Importing Files
Lesson Summary
Quiz 1.2
Worksheets in Excel
Add, Copy, Move
Combining Documents
Lesson Summary
Lesson at a Glance
Learning Outcomes
Quiz 1.3
Microsoft Excel
Workbooks vs. Worksheets
Multiple Workbooks
Lesson Summary
Crucial Parts of an Excel Workbook
Lesson Outcome
Quiz 1.4
Introduction
Workbook vs. Worksheet
Excel Worksheets
Adding, Deleting and Naming Worksheet Tabs
Adding Color and Modifying the Text
Lesson Summary
Learning Outcomes
Quiz 2.1
Page Layout / Page Setup
Margins
Orientation
Print Titles
Lesson Summary
Learning Outcomes
Quiz 2.2
Add or Remove a Row or Column
Ribbon or Right-Click?
Using the Ribbon Commands
Using the Right Click Method
Short-Cut Keyboard Commands
Lesson Summary
Learning Outcome
Quiz 2.3
Themes
Theme Choices
Theme Colors and Fonts
Theme Effects
Lesson Summary
Learning Outcomes
Quiz 2.4
Row Height & Column Width
Basic Rules
Column Width
Row Height
Lesson Summary
Learning Outcomes
Quiz 2.5
Watermarks
Using WordArt
Adding an Image to the Header
Lesson Summary
Learning Outcomes
Quiz 2.6
Background on Headers and Footers
The Page Layout View
Adding a Header
Adding a Footer
Lesson Summary
Learning Outcomes
Quiz 2.7
What Is Data Validation?
Whole Numbers within Limits
Text of a Specified Length
Types of Alert Messages
Lesson Summary
Learning Outcomes
Quiz 2.8
Introduction
Printing Only What You Need
Setting a Print Area
Clearing Your Set Print Area
Lesson Summary
Learning Outcomes
Quiz 3.1
Saving in Excel
How to Save Your Excel Workbook
Naming Your File
Save vs. Save As
Optional File Formats
Lesson Summary
Learning Outcomes
Quiz 3.2
Printing from Excel
Printing One Worksheet
Printing Multiple Worksheets
Lesson Summary
Learning Outcomes
Quiz 3.3
Scale to Fit Print Options
Using the Print Settings
Using the Page Layout Menu
Scaling Using Percentages
Lesson Summary
Learning Outcomes
Quiz 3.4
Backwards Compatibility
Check Compatibility Feature
How to Run a Compatibility Check
Lesson Summary
Learning Outcomes
Quiz 3.5
Printing Excel Documents
Workbook vs. Worksheet
How to Print an Excel Workbook
Tips to Printing Excel Documents
Lesson Summary
Learning Outcomes
Quiz 3.6
Printing Excel Spreadsheets
The Print Preview
Print Settings and Options
Wrap Up
Lesson Summary
Learning Outcomes
Quiz 3.7
File Formats
PDF, CSV and Older Versions of Excel
The Save As Function
Lesson Summary
Learning Outcomes
Quiz 3.8
Sharing Excel Files
Send as Attachment
Send as PDF
Lesson Summary
Learning Outcomes
Quiz 3.9
Introduction
Merge vs. Combine
Merge and Center
Combine
Lesson Summary
Learning Outcomes
Quiz 4.1
Cell Alignment
Vertical Alignment
Horizontal Alignment
Lesson Summary
Learning Outcomes
Quiz 4.2
Fonts in Excel
Changing the Font Type or Size
Changing the Default Font
Lesson Summary
Learning Outcomes
Quiz 4.3
The Format Painter Tool
Format Painter with Adjacent Cells
Format Painter with Non-Adjacent Cells
Lesson Summary
Learning Outcomes
Quiz 4.4
Wrapping Text
The Format Cells Command
Formatting to Wrap Text
Lesson Summary
Learning Outcomes
Quiz 4.5
Formatting Numbers
Format Cells Dialogue Box
Number
Currency
Date
Lesson Summary
Learning Outcomes
Quiz 4.6
The Highlight Term
Highlighting to Select
Highlighting to Draw Attention
Lesson Summary
Learning Outcomes
Quiz 4.7
Cell Styles
Applying Cell Styles
Modifying Cell Styles with Accents
Lesson Summary
Learning Outcomes
Quiz 4.8
WordArt
How to Add WordArt
How to Modify WordArt
Lesson Summary
Learning Outcomes
Quiz 4.9
Introduction
Append and Consolidate
The Consolidate Command
After You Consolidate
Consolidating Multiple Excel Files
Lesson Summary
Learning Outcomes
Quiz 5.1
Find & Select Tool
Finding Information
Find and Replace
Using the Find Options
Lesson Summary
Learning Outcomes
Quiz 5.2
Copy and Paste
The Clipboard
The Copy & Paste Commands
Paste Value & Formatting
Paste Formula & Formatting
Lesson Summary
Learning Outcomes
Quiz 5.3
The Autofill Feature
Filling Data Down a Column
Using the Autofill to Copy Data
Filling Data Across a Row
Lesson Summary
Learning Outcomes
Quiz 5.4
Adding and Removing Cells
Using the Ribbon Commands
Using the Right-Click
Lesson Summary
Learning Outcome
Quiz 5.5
What Is the 'AND' Function?
Example
Results
Lesson Summary
Quiz 5.6
Introduction
The Filter Tool
You Need a Header Row
How to Run a Filter
Running Multiple Filters
Lesson Summary
Learning Outcomes
Quiz 6.1
Sorting in Excel
Sort Using One Column
Sort Using Multiple Columns
Lesson Summary
Learning Outcomes
Quiz 6.2
Duplicate Records
Hide or Remove
Using the Advanced Filter
Using the Remove Duplicates Command
Lesson Summary
Learning Outcomes
Quiz 6.3
Introduction
Conditional Formatting
Highlight Cells Rule
Conditional Formatting Menu
Clearing Conditional Formatting
Lesson Summary
Learning Outcomes
Quiz 7.1
What Are Sparklines?
Lines and Columns
Win/Loss
Sparkline Design Options
Lesson Summary
Learning Outcomes
Quiz 7.2
Flip Flop Data in Excel
Transpose Using the Right-Click
Transpose Using the Ribbon Commands
Lesson Summary
Learning Outcomes
Quiz 7.3
What Are Named Ranges?
How to Create a Named Range
How to Use Named Ranges in Formulas
Lesson Summary
Learning Outcomes
Quiz 7.4
Excel Outline Feature
Auto Outline
Manual Outline
Lesson Summary
Learning Outcomes
Quiz 7.5
Outlines in Excel Worksheets
Quick Review
Hierarchy or Level Buttons
Expand and Collapse Controls
Lesson Summary
Learning Outcomes
Quiz 7.6
The Subtotal Feature
Sort Your Data First
How to Insert Subtotals
Summary, Outline and Totals
Beyond Sum
Lesson Summary
Learning Outcome
Quiz 7.7
Introduction
Tables in Excel
Benefits to Creating a Table
How to Create a Table in a Worksheet
Table Style Design Options
Lesson Summary
Learning Outcomes
Quiz 8.1
Working With Tables in Excel
Quick Review
Adding Data
Deleting Rows and Columns
Resizing Tables
Lesson Summary
Learning Outcomes
Quiz 8.2
Introduction
Tables in Excel
Quick Review - How To Insert a Table
Table Style Gallery
Lesson Summary
Learning Outcomes
Quiz 9.1
Color Banding
Using Tables to Band Rows
Using Conditional Formatting to Band Rows
Lesson Summary
Quiz 9.2
Introduction
Formulas
Benefits
The Basics of Formulas
More on Functions
Lesson Summary
Learning Outcomes
Quiz 10.1
Relative, Absolute and Mixed
Understanding Cell References
Relative
Absolute
Mixed
Lesson Summary
Learning Outcomes
Quiz 10.2
Mathematical Calculations
Defining Order of Operations
Complex Calculations
Using Parentheses to Change the Order
Applying Order to Cell References
Lesson Summary
Learning Outcomes
Quiz 10.3
Cell References
Numbers and Letters, Columns and Rows
Cell Ranges
Referencing a Cell in Another Worksheet
Lesson Summary
Learning Outcomes
Quiz 10.4
Introduction
The SUM Function
Adding Numbers Together
Using SUM to Subtract
Performing More than One Calculation
Other Examples
Lesson Summary
Learning Outcome
Quiz 11.1
MIN and MAX Functions
Using MIN and MAX in Formulas
Using Single Cells References and Numbers
Combining with the IF Function
Lesson Summary
Learning Outcomes
Quiz 11.2
The COUNT Group of Functions
Counting Numbers
COUNTA
COUNTBLANK
Lesson Summary
Learning Outcomes
Quiz 11.3
Finding the Average
The AVERAGE Function
Using AVERAGE in a Formula
More Complex Formulas
Lesson Summary
Learning Outcomes
Quiz 11.4
Introduction
SUMIF
SUMIF in a Formula
Adding Values That Are Greater or Less Than
Adding Values Where the Criteria Is Text
More Example Formulas
Lesson Summary
Learning Outcomes
Quiz 12.1
Average When Conditions Are Met
Review of the Average Function
The AVERAGEIF Function
Step by Step
Lesson Summary
Learning Outcomes
Quiz 12.2
The COUNTIF Function
The Basics
Where the Criteria Is Text
Where the Criteria Is Numbers
More Formula Examples
Lesson Summary
Learning Outcomes
Quiz 12.3
Introduction
Extracting Data
Left Function
Mid Function
Right Function
Lesson Summary
Learning Outcomes
Quiz 13.1
Dealing With Messy Data
The TRIM Function
The CLEAN Function
TRIM and CLEAN Used Together
Lesson Summary
Learning Outcomes
Quiz 13.2
Text Functions
The Upper Function
The Lower Function
The Proper Function
Lesson Summary
Learning Outcomes
Quiz 13.3
To Concatenate
Using Concatenate in Formulas
Example Worksheet
Example Formulas
Lesson Summary
Learning Outcomes
13.4 quiz
Visual Data
Chart or Graph
Chart Types
Inserting a Chart
Lesson Summary
Learning Outcomes
Quiz 14.1
Charts in Excel
Quick Review: Inserting a Chart
Chart Tools
Changing the Chart Type
Lesson Summary
Learning Outcomes
Quiz 14.2
Making the Switch
Excel Charts - Refresher
The Switch Row/Column Command
Lesson Summary
Learning Outcomes
Quiz 14.3
The Quick Analysis Tool
Accessing the Quick Analysis Tool
Numbers, Numbers, Numbers!
How to Select an Analytical Element
Lesson Summary
Learning Outcomes
Quiz 14.4
Introduction
Working in Excel
Excel Scenarios
Lesson Reflection
Excel Formatting
Formatting in Excel Scenarios
Excel Cell Formatting
Cell Formatting Scenarios
Lesson Reflection
Table Talk
Excel Table Scenarios
Chart Smarts
Hands-On Scenarios with Excel Charts
Lesson Reflection
Final Exam
We promise top learning experience 🏆
Entrepreneurship Essentials helps you turn an idea into a viable venture. Learn how entrepreneurs validate concepts through structured experiments, refine their business strategy, and raise the capital necessary to create value & grow their business
Leadership and Organizational Behavior (OB) is the study and application of knowledge about how people, individuals, and groups act in organizations. It does this by taking a system approach. This course will bring out the best leader in you.
Project Management Essentials certificate provides students with fundamental knowledge and skills and a strong start on the path toward becoming a certified Project Management Professional (PMP)® through the Project Management Institute (PMI).
FREQUENTLY ASKED QUESTIONS
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.
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.
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.