Limited-time offer! Sale ends in




BECOME An expert in ms excel

Learn From Beginner To Advance

Actual Price Rs 10000

999 ONLY
Learn Excel with this A-Z Microsoft™ Excel Course by GuruSkool.
Microsoft™ Excel 2010, 2013, 2016, Excel 2019
Free Support From Trainer Included

Simple Easy To Learn Course Modules!!
Get Enrolled Now!

what you'll get when you enroll in the course Right Now

150+ Microsoft Excel Course Videos Access

Certification of Completion.(No one provides this in 999)

After Your Course Is Complete You'll Get Certificate Through Our Web Portal.

You'll Learn Reporting, Calculators, Pivot Tables, Graphs,
Pie Charts and much more..

digital marketing
Enroll This Course
More Than 12808 Students Already Enrolled !


Course Curriculum

› Introduction

› 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

› 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

› 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

› 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

› Working with font formatting commands

› Changing the background color of cells

› Adding borders to cells

› Formatting data as currency values

› Formatting percentages and using the format painter

› Creating Styles to format Data

› Merging and centering the cells

› Using Conditional Formatting

› Inserting Images

› Inserting and formatting excel shapes

› working with excel SmartArt

› Creating an Excel column Chart

› working with the excel chart ribbon

› Adding , Modifying and Formatting the Excel chart

› Moving the chart and working with Excels pie chart

› Viewing and changing the margins, scaling and orientation in print preview

› working with the page layout view

› Adding Header & Footer and Printing specific range of cells

› Opening the In-built Templetes

› Creating a Custom Template

› Understanding Excel List Structure

› Sorting a list using single level sort

› Sorting a list using Multi level sort

› Using Custom Sort In an Excel List

› Filter an Excel List Using the Autofilter Tool

› Creating subtotals in List

› Format a list as a table

› Finding and Removing the duplicates

› working with DSUM() Function single criteria

› Excel function with OR and AND criteria

› Excel Function DAVERAGE and DCOUNT

› Excel Function SUBTOTAL

› Understanding and Creating the Excel Data Validation

› Decimal and adding a custom data validation

› Dynamic Formulas by using excel data validation Techniques

› Importing data from text files

› Importing Data from Microsoft Access

› Exporting data to a text file

› Understanding and Creating the Excel Pivot table

› Modifying Pivot table Calculations

› Grouping Pivot table

› Formatting the Pivot Table Data

› Drilling down into pivot table data

› Creating Pivot charts

› Filtering the Pivot table manually and with Slicer tool

› Understanding Power Pivot and creating data models

› Creating Pivot Table and calculations

› power Pivot KPIs

› Using the Freeze Panes Tool

› Grouping Data (Columns and or rows)

› print options for large sets of data

› using 3D formulas & Consolidating data from multiple sheets

› Congratulations and Introduction of course 103

› working with excel Name Ranges

› Advantages & disadvantages and Editing of name ranges

› Using IF() Function

› Nesting function with Excel

› Nesting Excel's AND() Function within IF() Function

› Using excel's COUNTIF() and SUMIF() Function

› Using IFERROR() Function

› using the VLOOKUP() Function

› Using HLOOKUP() Function

› Using INDEX() Function

› Using Match() Function

› Combining MATCH() & INDEX() Function

› Continuing Combined MATCH() & INDEX() Function

› working with HLOOKUP() 7 MATCH() Function together

› using excel's LEFT(), RIGHT() & MID() function

› working with excel's LEN() & SEARCH() Function

› using CONCATENATE() Function

› tracing Precedents and dependents in excel formulas

› Working with the Watch window

› Showing formulas

› protectiong Specific cells in a worksheet

› Protecting the structure and the whole workbook

› Working with Goal Seek Function

› Working with Solver Tool

› Building effective Data Tables

› Creating Scenarios

› Understanding the Macros and activationg the developer Tab

› Creating a Macro with the Macro Recorder

› Editing a macro with VBA

› Running Macro with diffrent Types

BUY NOW @  999

The Sample Certificate Which You'll Get After Course Completion

html css and javascript course online
BUY NOW @ 999

About GuruSkool (Rabbi Solutions Private Limited)

GuruSkool Institute of Internet Marketing is a trademark of “Rabbi Solutions Pvt. Ltd.” as a leading Internet Marketing Training provider for Corporate, Professionals, Entrepreneurs and Students. GuruSkool Institute of Internet Marketing provides full-fledged live classroom training for industry executives and entrepreneurs. We teach marketers how to reach right target market with lower acquisition cost in the best way possible. For corporate, GuruSkool conducts 45 hours Full fledged training and advanced 2-day workshop in Internet marketing where our flexible training enables your employees to learn tools, techniques and acquire advanced skills required to increase your business market share, create brand awareness, communicate with potential customers, reach right target market and take your business to global platform.

Final Call

Do not Miss this Opportunity, You may take the advantage of Getting the Digital Marketing Course at this price. Soon the prices will be increased.

Enroll Me Now


Frequently Asked Questions

After you purchase the course you'll automatically get registered in our web portal with your email id and you will receive the purchase confirmation on your email address with the login details for your web portal.

After the purchase is complete you can login in our web portal and there you'll see all your enrolled courses videos/lessons and course material and after the course is complete the certificate will generate automatically and send it to your email address or you may access/download it from your web portal.

If you face any problem or need any help regarding anything about the course or lesson you may give us a call on +91 84476 77362 and we'll be more than happy to assist you regarding your query.
BUY NOW @ 999
This site is not a part of the Facebook website or Facebook Inc. Additionally, This site is NOT endorsed by Facebook in any way. FACEBOOK is a trademark of FACEBOOK, Inc. This site is not a part of the Google website or Google Inc. Additionally, This site is NOT endorsed by Google in any way. Google is a trademark of Google, Inc.
GuruSkool (A Unit of Rabbi Solutions Private LIMITED)