- Home
- Categories
- LANGUAGE
- MATHEMATICS
- SCIENCE
- SOCIAL SCIENCE
- CODING
- IT
- MIND, BODY, SOUL
- EVENTS@I-EDIFY
- ENTRANCE EXAMS
- ART O MANIA
- STUDENTS COUNSELLOR
- COMMERCE
- LEARN TO EARN
- TRAINER'S CLUB
- KINDERGARTEN
Enter the world of I-Edify
MS EXCEL (Level 1 - For Beginners)
Freshers / Beginners who are looking to grab a hold of MS-EXCEL (basics), this is the module you should go for. Starting from scratch, we will go onto creating a long-lasting interest in MS-EXCEL and learn a lot of short-cuts during the sessions. Broadly, these sessions comprise of the following topics : Microsoft Excel Fundamentals, Entering and Editing - Text and Formulas, Working with Basic Excel Functions, Modifying an Excel Worksheet along with Sorting and Filtering.
-
- 5 Rating
- (1 Reviews)
- 52 Student Enrolled
.jpg)
Requirements
- Laptop / MAC-Book, Speed - At least 2 GHz, Storage - Minimum 10 GB, Windows 7 or higher / Windows XP, MS Office Suite (Office 365 / 2013 or higher), Good Wi-Fi connection, Additional Stationary (like notebook / paper, pen etc.).
Description
Microsoft Excel Fundamentals :
-- Launching Excel
-- Introduction to the Excel Interface
-- Customizing the Excel Quick-Access Toolbar
-- Understanding the Structure of an Excel Workbook
-- Saving an Excel Document
-- Opening an Existing Excel Document
Common Excel Shortcut Keys (would be taken in all the sessions)
Entering and Editing - Text and Formulas :
-- Entering Text to Create Spreadsheet Titles
-- Working with Numeric Data in Excel
-- Entering Date Values in Excel
-- Working with Cell References
-- Data Linking within Workbooks and Worksheets
-- Creating Basic Formulas in Excel
-- Relative Versus Absolute Cell References in Formulas
-- Understanding the Order of Operation (BODMAS)
Working with Basic Excel Functions :
-- The structure of an Excel Function
-- Working with the SUM() Function
-- Working with the MIN() and MAX() Functions
-- Working with the AVERAGE() Function
-- Working with the COUNT() Function
-- Using the AutoSum Command
-- Using the AutoFill Command to Copy Formulas
-- Usage of IF Function
Modifying an Excel Worksheet :
-- Moving and Copying Data in an Excel Worksheet
-- Inserting and Deleting Rows and Columns
-- Changing the Width and Height of the Cells
-- Hiding and Unhiding - Excel Rows and Columns
-- Deleting an Excel Worksheet
-- Renaming an Excel Worksheet
-- Moving and Copying the Excel Worksheet
Sorting and Filtering :
-- Sort Function
-- Sorting with Single / Multiple Column(s) / Function(s)
-- Custom Sorting
-- Filtering the Data
-- Advanced Filter Technique
Recent Courses
About the Teacher
