Guruskool
Guruskool Logo

Become an Expert in MS Excel 

  • Offered byGuruskool

Become an Expert in MS Excel
 at 
Guruskool 
Overview

Learn From Beginner To Advance

Duration

15 hours

Total fee

385

Mode of learning

Online

Credential

Certificate

Become an Expert in MS Excel
 at 
Guruskool 
Highlights

  • Earn a Certification of Completion from Guruskool
  • 150+ Microsoft Excel Course Videos
  • Free Support From Trainer Included
Details Icon

Become an Expert in MS Excel
 at 
Guruskool 
Course details

Skills you will learn
What are the course deliverables?
  • Reporting
  • Calculators
  • Pivot Tables
  • Graphs
  • Pie Charts
More about this course
  • Learn Microsoft Excel 2010, 2013, 2016, Excel 2019

Become an Expert in MS Excel
 at 
Guruskool 
Curriculum

Section 1

Introduction

Section 2

Launching Excel

Microsoft Excel Startup Screen

Introduction to the Excel Interface

Customizing the Excel Quick Access Toolbar

More on The Excel Interface

Understanding the structure of an excel Workbook

Saving an excel document

Opening a document

Common Excel Shortcut Keys

Section 3

Entering text to create spreadsheets tiltles

Working with Numeric Data In Excel

Entering the Date Values In Excel

Working with Cell Refrences

Creating Basic Formulas In Excel

Relative Versus Absolute Cell Refrence In Formulas

Understanding the Order of Operation

Section 4

The structure of an excel function

Working with the Sum() Function

Working with the MIN() and MAX() Function

Working with average() Function

Working with the count() Function

Adjacent cells error in Excel calculation

Using the Autosum Command

Excel's Autosum Shortcut key

Using the Autofill Command to copy formulas

Section 5

Moving and copying the date in excel worksheet

Inserting and deleting the rows and columns

Changing the width and the height of the cells

Hiding and unhiding excel rows and columns

Renaming an excel worksheet

Deleting an excel worksheet

Moving and copying an excel worksheet

Other courses offered by Guruskool

qna

Become an Expert in MS Excel
 at 
Guruskool 

Student Forum

chatAnything you would want to ask experts?
Write here...