logo
INDIA'S MOST TRUSTED TRAINING INSTITUTE

Basic Microsoft Excel Training Program

Course: ETP9001 Register here

20+

formulas/ functions

30+

shortcut keys

10+

tools and menus

WH

work for home
Technology:Excel
Level:Introduction
Audience(s):Beginners
Language(s):English and Hindi
Training method:Classroom
Course Duration:12 Days
Class Duration:2 Hours
Fee:INR 4000

Overview

An Overview of the Excel Basics That Will Assist You When Using Excel Functions and Formulas. This Microsoft Excel training class is designed for students to gain the skills necessary to use pivot tables, basic formulas and worksheet sheet tools, utilize data tools, collaborate with others, and create and manage data.

if you are using Microsoft excel for the first time, This course about the basic elements of MS EXCEL. In this, course you will learn, how to create a workbook using a template, add data by typing in a worksheet, create a basic chart, save a workbook, use formulas, shortcuts and much more. Basic Excel - An Overview of the Excel Basics That Will Assist You When Using Excel Functions and Formulas.


Students who have nil skills with Microsoft Excel who want to learn more excel, formulas, calculation skills or students who want to learn the topics covered in this course in the interface. This course if good for Level 1, beginners, school - college - university's students.


After completing this course, students will be able to: Insert the course objectives in a bulleted list with periods. For example.

Create pivot tables and charts

Learn to trace precedents and dependents

Learn functions and dependents calculation

Convert text and validate and consolidate data.

Collaborate with others by protecting worksheets and workbooks

Import and export data


This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

What is the Excel?, Excel Application Setting - Calculation, Vba Tab options, Edit Custom list, Worksheet Calculation, Autocorrect Option, Macro Enable / Disable
Overview of basic Excel skills, Basic Short Keys, Worksheet Operations ,Cell Operation , Format Cells ,Freeze Panes
Shortcuts, keyboard shortcuts, navigation shortcuts, Paste Special - many more paste options
Techniques of Paste Special, Protect Worksheets & Workbooks , Time Saving Utilities ,Format Painter
Text to Columns with fixed and delimited parameters, Data Sorting using custom list ,Summarizing data using Auto Outline
Concept of Cell Referencing, Relative Referencing, Absolute Referencing, Mixed Referencing
Page Setup - Margins, Header and Footers, Orientation, Hyperlinked Spreadsheet, Freezing, much more...

No Additional reading just do practice on sheet given by institute.


Microsoft Excel is important because it is the basic spreadsheet program used in Windows, which means a large number of computers in the world use it.    -V. Maurya ❞
Microsoft Excel knowledge is a basic need to used in almost all offices and its The world's most powerful business tool.     -Akumar ❞




Schedule for a Demo Class to Find Out how we Teach!

Schedule for a Demo Class to Find Out how we Teach!

  (+91) 965-442-1288      support@99excel.com   (+91) 931-258-0474

Related Courses

Advanced Excel

Power of Excel Spreadsheets
99excel.com

Excel VBA

Visual Basic for Applications automation
99excel.com

Group User

Get trained each person in your office