I-Edify Education Hub
Book a FREE Trial
9899954389 info@i-edify.com

MS EXCEL (Level 2 - For Beginners / Professionals)

Participants who are looking to grab a hold of MS-EXCEL (intermediate), this is the module you should go for. As a trainer, we expect that participants should have some prior knowledge of MS Excel, so that it streamlines the whole process-flow. Starting from where we left in our previous module (i.e. Sorting and Filtering), we will go on to creating a much better understanding to enhance the practical use of MS-EXCEL. We will definitely learn a lot of short-cuts during these sessions as well. Broadly, these sessions comprise of the following topics : Various modes of Saving a file, Formatting Data in an Excel Worksheet, Implementation of Name Manager, Inserting Images and Shapes into an Excel Worksheet, Creating Basic Charts in Excel, "Paste-Special" Functions, Protection of Cell(s) / Worksheet(s) / Workbook(s), Transpose using different options, Working with Large Sets of Excel Data, Working with Excel's Text Based Functions.

  • 5 Rating
  • (1 Reviews)
  • 33 Student Enrolled
  • 4999
  • 7500


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

Various modes of Saving a file :

-- Compatibility Mode

-- .xlsm Mode

-- .xls Mode

-- .pdf Mode

 

Formatting Data in an Excel Worksheet :

-- Working with Font Formatting Commands 

-- Changing the Background Colour of a Cell 

-- Adding Borders to Cells 

-- Formatting Data as Currency Values 

-- Formatting Percentages 

-- Using Excel's Format Painter 

-- Creating Styles to Format Data 

-- Merging and Centering Cells 

-- Conditional Formatting using various sets

-- Grouping & Ungrouping of Data

 

Implementation of Name Manager :

-- Introduction to Name Manager

-- Uses of "Name Manager"

 

Inserting Images and Shapes into an Excel Worksheet :

-- Inserting Images 

-- Inserting Excel Shapes 

-- Formatting Excel Shapes 

-- Working with Excel SmartArt

 

Creating Basic Charts in Excel :

-- Creating an Excel Column Chart 

-- Working with the Excel Chart Ribbon 

-- Adding and Modifying Data on an Excel Chart 

-- Formatting an Excel Chart 

-- Moving a Chart to another Worksheet 

-- Working with Excel Pie Charts

-- Working with Sparklines

-- Thermometer Chart

-- Gantt Chart

-- Waterfall Chart

-- Histogram Chart

 

"Paste-Special" Functions :

-- Paste Special Values

-- Paste Special Formats

-- Paste Special Formula

-- Paste Special Link

 

Transpose using different options :

-- TRANSPOSE using Paste special

-- Simple Transpose

 

Protection of Cell(s) / Worksheet(s) / Workbook(s) :

-- Protection of Cells

-- Protection of Workbook and Worksheets

 

Working with Large Sets of Excel Data :

-- Using the Freeze Panes Tool 

-- Grouping Large Data (Columns and / or Rows) 

-- Print Options for Large Sets of Data 

-- Linking Worksheets 

-- Consolidating Data from Multiple Worksheets

 

Working with Excel's Text Based Functions :

-- Using Excel's LEFT(), RIGHT() and MID() Functions 

-- Using Excel's LEN() Function 

-- Using Excel's SEARCH() Function 

-- Using Excel's CONCATENATE() Function

 

Recent Courses

blog
Last Updated 27th January 2021
  • 15
  • Free
blog
Last Updated 27th January 2021
  • 20
  • 4400
  • 6000
blog
Last Updated 15th January 2021
  • 15
  • Free
blog
Last Updated 15th January 2021
  • 15
  • 1800
  • 3000
blog
Last Updated 14th January 2021
  • 17
  • 1500
  • 5000

About the Teacher

instructor
About the Teacher

I am Manish Lamba (An Engineer & an MBA) from Aamchi Mumbai (the good old BOMBAY).
I have more than 13 years of Training Expertise & 8 + years of Corporate Experience.
 
All of my Training Experience is into Microsoft Suites, like MS Excel (Basic & Advanced - VBA & Macros) along with Entrance Exam Training (taking care of Quants / LR / DI / Verbal), with the latest tie-up with NM College (Mumbai).
 
I am also into Private Tutoring from 8th Std. till 12th For ISC, CBSE, SSC Boards - taking care of Maths, Science & English.
 
I am associated with ITM (Kharghar & Dombivili) for more than 3 years for their Excel & Advanced Excel Course - completed 14 batches (training on ADVANCED EXCEL - was always my major throughout my corporate tenure as well). My latest Association's would be Tata Motor's & Edelweiss Securities, where I have conducted Trainings for 3 Batches each and D. D. Vispute College (Panvel) - 40 Hour Course - for their students who were interested in learning Automation in EXCEL through MACROS.
 
I have also taken Courses in AMITY University - like Financial Modeling & Simulation, Business Statistics and Operational Research & Research Methods along with Behavioral & Soft Skills Training.
 
I am more inclined towards Online Training where the concepts can be taught more thoroughly through the use of Presentations. I was Associated with Mahesh Tutorials for their 11th Std. Robomate - Video Tutorials for many chapters in Maths.

Student Feedback

5
Course Rating
100%  
100%  
100%