Microsoft Excel 2010 Basic Level - Start your AI Journey here

Start your AI Journey here

Your Rich Future Starts Here – Free

Log In/Register

Start your AI Journey here

Your Rich Future Starts Here – Free

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Course Content

Expand All

Lesson 1 Basic Excel Elements 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

1.1 Introduction to Excel 2010

1.2 Starting Excel

1.3 The Ribbon and the New Backstage

1.4 Opening an Existing Workbook

1.5 Opening a Recently Used Workbook

1.6 Creating a New Workbook

1.7 Saving Your Workbook

1.8 Closing a Workbook

1.9 Exiting Excel

Lesson 2 Basic Excel Details 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

2.1 Introduction to Lesson 2

2.2 Scrolling With and Without Scroll Bars

2.3 Moving Around the Worksheet

2.4 Left Click vs. Right Click

2.5 Worksheet Tabs

2.6 Where are the Dialog Boxes?

2.7 Setting up the Page Layout

2.8 Previewing and Printing a Workbook

2.9 Getting Help

Lesson 3 Selecting and Editing Techniques 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

3.1 Introduction to Lesson 3

3.2 Selecting an Entire Worksheet

3.3 Selecting a Range of Cells

3.4 Selecting Nonadjacent Cells and Ranges

3.5 Selecting Columns and Rows

3.6 Changing Column Width or Cell Height

3.7 Hiding and Unhidden Rows and Columns

3.8 Moving and Copying Data

3.9 Using Drag and Drop

3.10 Editing Information in Cells

3.11 Using Undo and Redo

Lesson 4 Data Entry Techniques 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

4.1 Introduction to Lesson 4

4.2 Entering Information into Single Cells

4.3 Entering Information into Multiple Cells at Once

4.4 Deleting Information

4.5 Typing Text vs. Numbers

4.6 Learning AutoFill Basics

4.7 Using AutoFill Tricks

Lesson 5 Performing Calculations 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

5.1 Introduction to Lesson 5

5.2 Understanding Formula Operators and Order of Operations

5.3 Using Real Numbers to Do Math

5.4 Using Cell References to Do Math

5.5 Letting the Sum Button do the Math for You

5.6 Creating Simple Formulas

5.7 Using Common Functions

5.8 Using the Insert Functions Dialog Box

5.9 Using AutoFill to Copy Formulas

5.10 Editing Formulas and Functions

Lesson 6 Formatting with Fonts and Alignments 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

6.1 Introduction to Lesson 6

6.2 Changing the Actual Font and Font Size

6.3 Embellishing Fonts

6.4 Aligning Text Within a Cell

6.5 Displaying Text Vertically or at an Angle

6.6 Using the Text Wrap Feature or Wrapping Text Manually

6.7 Using the Merge and Center Tool

Lesson 7 Formatting Cells 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

7.1 Introduction to Lesson 7

7.2 Putting Color into the Cell Background

7.3 Bordering Cells

7.4 Creating the Proper Number Format with a Click of a Button

7.5 Applying Number formats Using the Drop-down Tool

7.6 Copying Formats with the Format Painter

7.7 Using Built-In Styles

7.8 Applying Conditional Formatting

Lesson 8 Working with the Excel Data 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

8.1 Introduction to Lesson 8

8.2 Finding and Replacing information

8.3 Sorting Data

8.4 Copying or Moving Sheet Between Workbooks

8.5 Inserting and/or Deleting Columns and Rows

8.6 Naming Ranges

8.7 Using Various Excel Views for Working Efficiently

8.8 Checking Spelling

8.9 Inserting Page Breaks

Related