uCertify

PF106 - Introduction to Spreadsheets

(FLU-PF106.AE1)
Lessons
Lab
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Excel: The 50-Cent Tour

  • Getting Comfy with the Excel Window
  • Creating Fresh Workbooks
  • Data Entry 101
2

Sprucing Up a Worksheet

  • Selecting Cells and Ranges
  • Adjusting Columns and Rows
  • Formatting Cells from the Ribbon
  • Formatting Numbers, Dates, and Time Values
  • Hiring Out the Format Painter
3

Fiddling with Your Worksheets

  • Editing a Cell
  • A Worksheet with a View
  • Copying and Moving Stuff Around
4

Taming Your Worksheets

  • Revamping a Worksheet
  • Overhauling a Workbook
5

Building Basic Formulas

  • Getting Started with Formulas
  • Augmenting Formulas with Functions
  • Copying Formulas
  • Adding Array Formulas
  • Naming Cells and Ranges
6

Analyzing Data

  • Getting Quick Analyses from Excel
  • Eyeballing Trends and Outliers with Conditional Formatting
  • Managing Information in Tables
  • What If You Used What-If Analysis?
  • Summarizing Data with PivotTables
7

Visualizing Data with Charts

  • Learning Some Crucial Chart Basics
  • Forging a Fresh Chart
  • Selecting Chart Elements
  • Dressing Up Your Charts
8

Automating Excel with Copilot

  • Getting Copilot on the Job
  • Analyzing Data
  • Creating Formulas
  • Highlighting Data
  • Sorting and Filtering Data
  • Visualizing Data

1

Excel: The 50-Cent Tour

  • Creating and Saving a Workbook
2

Sprucing Up a Worksheet

  • Adjusting the Columns
  • Hiding the Rows
  • Hiding the Columns
3

Fiddling with Your Worksheets

  • Adding and Replacing Data in a Cell
  • Deleting a Row
  • Inserting a Cell Range
  • Freezing the Top Row
  • Copying and Pasting the Data
4

Taming Your Worksheets

  • Deleting a Column
  • Adding Color to the Worksheet Tab
  • Making a Copy of the Worksheet
  • Adding a New Worksheet
  • Hiding a Worksheet
  • Deleting a Worksheet
5

Building Basic Formulas

  • Creating Worksheet Formulas
  • Calculating the Sum
  • Using the TODAY Function
  • Adding the Arguments for the IF Portion of the Nested Function
  • Creating Named Ranges
  • Editing Range Names
6

Analyzing Data

  • Creating a Forecast Sheet
  • Converting the Data into a Table
  • Adding Fields to the PivotTable
7

Visualizing Data with Charts

  • Creating the Combo Chart
  • Changing the Chart Type
  • Changing the Labels of the Line Chart
8

Automating Excel with Copilot

  • Using the MATCH Function
  • Using the INDEX Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the SORT Function
  • Using the FILTER Function
  • Creating Sparklines

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More