Excel Training Courses

Excel is one of the most popular software applications in the world and is used by firms in almost every industry, from pizza parlors to private equity. Companies, educational institutions, and government agencies all use Excel to manage and analyze data, create spreadsheets and reports, print charts, and much more. It’s no wonder why a working knowledge of this spreadsheet software is an essential skill for people who spend part of their workday in front of a computer, even for those that do not necessarily have an accounting or finance-related careers. Thus Excel skills are in demand, and its no surprise people with Excel knowledge are earning more money than their counterparts. Excel Training Courses are best to start with in computer industry.

Duration

2.5 Months including Lab

Eligibility

Undergraduates, Graduates
Post-Graduates
Job Aspirants
School Going Students

Pre-requisites

Basic Computers

Deep Dive into Excel Training Courses

Course Content

Expand All | Collapse All

Modules Status

Module 1: Getting Started

Understanding the Excel screen

Navigating in a spreadsheet

Understanding worksheets, columns, rows and cells

Saving, opening, and closing workbooks

Module 2: Formatting a Spreadsheet

Changing column widths and row heights

Changing alignment of cells

Undoing and redoing actions

Formatting numbers , Clearing formats , Applying borders to cells, Merging cells

Module 3: Formulas and Functions

Entering formulas

Copying data and formulas

Using AutoSum

Understanding functions

Using simple aggregate functions (Sum, Count, Average, Min, Max)

Copying formulas

Applying conditions in a formula (The IF function)

Working with ranges

Module 4: Editing Features

Using cut , copy, and paste operations

Using paste special with values

Selection techniques

Navigation techniques

Module 5: Working with Large Worksheets

Freezing and unfreezing panes

Splitting windows

Inserting page breaks for printing

Module 6: Working with Charts

Creating charts using Chart Wizard

Creating different types of charts

Including titles and values in charts

Formatting of charts

Module 7: Previewing and Printing

Previewing worksheets

Page setup

Printing of worksheets in multiple pages

Repeating rows and columns for multiple pages

Printing multiple worksheets

Module 8: Simple Database Operations

Sorting tables

Filtering data with auto filter

Referring data from other worksheets

Targeted International Certifications After this Course

Microsoft Certification (Extra Payment)

Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. Holding a MOS certification can earn an entry-level business employee as much as Rs 600000 more in annual salary

Samyak Certificate (included)

Samyak IT Solutions Pvt Ltd is an ISO 9001:2008 Certified Company and has international level acceptance for its certifications. Students from Samyak are given preference in placements as they have proper hands on job related knowledge already, that any industry needs these days.