Become an Expert in MS Excel
- Offered byGuruskool
Become an Expert in MS Excel at Guruskool Overview
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
Become an Expert in MS Excel at Guruskool Course details
- Reporting
- Calculators
- Pivot Tables
- Graphs
- Pie Charts
- 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