Basic Microsoft Excel

  • Last Update 25 December 2023
  • 0 already enrolled

Description

Learn MS Excel Formulas and Functions. Create Basic and Advanced Excel Formulas. Make an Excel Template Project.

Requirements

Basic Data Entry
Basic operations of copy, paste, and format painter
File Save/Close operation
Program Contents

Target Audience

  • Professionals across all industries

Course Content

Lesson 1: Getting Started with Excel 2010

  • Starting Excel
  • Excel 2010 Working Environment
  • Using the Ribbon as the Excel 2010 User Interface
  • Navigating within the Worksheet
  • Selecting a Cell or Range of Cells
  • Entering Data
  • Entering Cell Contents
  • Cutting, Copying, and Pasting Cell Values
  • Copy and Paste Special/Go to Special
  • Autofill
  • Flashfill
  • Saving your Workbook
  • Opening your Workbook

Lesson 2: Managing Rows & Columns

Lesson 3: Managing Worksheets

Lesson 4: Formatting the Cell

Lesson 5: References

Lesson 6: Working with Formulas and Functions

Lesson 7: Organizing Worksheet and Table Data

Lesson 8: Conditional Formatting

Lesson 9: Pivot Reports and Charts

A course by

Student Ratings & Reviews

No Review Yet
No Review Yet
4,500.00
  • Course level: All Levels
  • Duration 18 hours
  • Total Enrolled 0
  • Last Update 25 December 2023
4,500.00
Share
Share Course
Page Link
Share On Social Media