Advance Excel Training

Advance Excel Training

Mlewzklawz IT Solutions Pvt. Ltd., Institute provides Best Advance Excel training Institute in BTM, Bangalore by experienced industry professionals and the Advance Excel training Institute in Bangalore is well equipped with advanced labs. Trainers working in Advance Excel training for over five years are carefully chosen to conduct top quality Advance Excel training in BTM, Bangalore so the students can benefit from real time scenarios. Instructors offering Advance Excel Training in Bangalore have practical knowledge as they implement their knowledge and expertise in day to day work. Students have the choice to pick out the course timings according to their convenience. Once the Advance Excel training course timings are fixed with the instructor, students are required to finish the course within the same schedule. Our schedule for Advance Excel training in Bangalore is incredibly flexible as we provide training in weekdays in morning and evening for students who cannot attend Advance Excel training in Bangalore during weekends because of their work schedule.

Getting Acquainted with excel

  • About Excel
  • The Excel Environment
  • The Title Bar
  • The Ribbon
  • Scroll Bar
  • The Microsoft Office Button
  • The Quick Access Toolbar
  • The Formula Bar
  • The Work Book Window The Work Book View Buttons
  • The Zoom Slider
  • The Mini Toolbar
  • The Keyboard Shortcuts

Creation Basic Work Books

  • Creating New Work Books
  • Saving New Work Books
  • Closing Work Books
  • Opening Work Books
  • Selecting Cells
  • Entering Text Into Cells
  • Number of Cells
  • AutoComplete
  • Pick From Draft-Down List
  • Using The “Window “Command Group
  • Switching To Full Screen View
  • Renaming Work Books
  • Working With Excel File Formats

Using Ranges

  • Selecting Ranges
  • Ranged Data entry
  • Using AutoFill

Creating Formulas

  • Ranged Formula Syntax
  • Simple Formula Syntax
  • Writing Formulas
  • Using Auto Sum
  • Inserting Functions
  • Editing A Range
  • Formula AutoCorrect
  • Auto Calculate

Tables

  • Creating A Table
  • Adding And Editing Records
  • Inserting Records And Fields
  • Deleting Records And Fields

Copy & Pasting formulas

  • Relative Reference And Absolute Reference
  • Cutting, Copying Pasting Data
  • Auto Filling Cells
  • The Undo Button
  • The Redo Button

Columns And Rows

  • Selecting Columns And Rows
  • Adjust Column And Width Of Row Height
  • Hiding And Unhanding Columns And Rows
  • Inserting And Deleting Columns And Rows

Formatting Worksheets

  • Formatting Cells
  • The Format Cells Dialog Box
  • Clearing All Formatting From Cells
  • Copying All Formatting From Cells To Another Area

Working Sheet Tools

  • Moving Between Work Sheets
  • Selecting Multiple Work Sheets
  • Inserting And Deleting Work Sheets
  • Renaming Work Sheets
  • Coloring Work Sheets Tabs
  • Copying Are Moving Work Sheets

Setting Work Sheets Layout

  • Using Page Break Preview
  • Using The Page Layout View
  • The Page Setup Dialogue Box

Printing Work Sheets

  • Using Print Preview
  • Printing Work Sheets

Creating Work Sheets Charts

  • Creating Charts
  • Gantt Chart
  • Selecting Chart And Chart Elements
  • Moving And Resizing Charts
  • Changing The Chart Type
  • Changing The Data Range
  • Switching And Column And Row Data
  • Choosing A Chart Layout
  • Choosing A Chart Style
  • Printing Charts
  • Deleting Charts

Number Formatting

  • Create Custom Formula
  • The Four Parts Of A Format
  • Scaling Number

Dates And Times

  • How Date Times Are Stored
  • Use Date/Time Function
  • Formatting Date And Time

Conditional Formatting And Cell Styles

  • Conditional Formatting
  • Finding Cell With Conditional Formatting
  • Clearing Conditional Formatting
  • Using Table And Cell Styles

Validation And Protection

  • Setting Cell Validation
  • Protecting Cells/Worksheets
  • Grouping And Outline

Editing And Formatting Charts

  • Formatting Chart Object
  • Inserting Object Into A Chart
  • Changing Chart Tables
  • Changing Axes Display
  • Changing The Chart Back Ground
  • Applying Chart Analysis Lines
  • Naming Charts
  • Applying Word Art Style To Chart Elements
  • Create Gantt Chart

Security Features

  • Unlocking Cells
  • Worksheet Protection
  • Password Protecting Excel Files

Sorting Data

  • Sorting Data
  • Custom Sort Order

Pivot Tables

  • Creating Pivot Tables
  • Pivot Charts
  • Manipulating A Pivot Table
  • Changing Calculated Value Fields
  • Applying Pivot Tables Style
  • Sorting And Filtering Pivot Table Data
  • Swapping Rows And Columns

If Function

  • If Function
  • Nested If Function

 Lookup And Advance Lookup Function

  • V-Lookup And H Lookup Function
  • Using Match Find The Value
  • Combination Match And Index
  • Using Offset
  • Indirect Function

 Range Names And Absolute Reference

  • Fixed Only Row/Column
  • Create Range Names

Making Macros

  • Recording Macros
  • Running And Deleting Recorded Macros
  • The Personal Macro Work Book
  • Absolute/Relative Recording
  • Assigning Macros To Button

 

STUDENT BENEFITS

  • Job Assistance
  • Pay Fees in Installment / EMI
  • Technical Support after Course Completion
  • Back up Classes Available
  • Attend Demo class
  • Course Complete Certificate
  • Lab Facility
  • Real Time Project

ADDITIONAL HIGHLIGHTS

  • Total 22-30 hours Class
  • 1 on 1 Training
  • You Get In-Depth Practical Knowledge on each Topic
  • Free Study E-Material, PDFs, Video Trainings
  • Flexible Timing
  • Online Trainings provided

Testimonials

We Have Interns From Following Colleges & Universities

Christ University, Bangalore Dayanand Sagar college, BangalorePesit Colllege, Bangalore AMC College, BangaloreThe Oxford College of Engineering, BangaloreThe Oxford Collge of Science, BangaloreTZone College, BangaloreR.V College of Engineering, BangaloreNoble Scohool of Busniess, BangaloreGreenwood High College, BangaloreSinhgad Institute of Management(SIOM), Pune City College, BangaloreLDRP Institute of Technology and Research, GandhinagarSacred Heart College, TirupatturMes college, BangaloreGuru Nanak Dev University, Amritsar, PunjabReva University Autonomous, BangaloreCollege of Engineering, BangaloreAuxilium College Autonomous, VellorSt Aloysius Institute of Management and Information Technology, MangaloreAlva's College, MoodbidriBallari Institute Of Technology and Management, Ballari, KarnatakaMalnad College of Engineering, HassanVisvesvaraya Technological University, MysoreGITAM, VisakhapatnamJyoti Nivas College, BangaloreK. S. Rangasamy College of Technology, Tamil NaduKLS Gogte Institute of Technology, BelagaviAlliance University, KarnatakaManipal University, KarnatakaM.E.S Kalladi College, MannarkkadMaharaja Institute of Technology, MysoreMVJ College of Engineering, BangaloreSSS Samiti College, Bangalore Surya College of Engineering and Technology, Rayapalayam, Tamil Nadu Newn Horizon College, BangaloreNMKRV College of Women, BangaloreAcharya Institute of Technology, Bangalore

For More Details Click Here

Disclaimer

Above all logos are trademarks of their respective owners.



For More Information: Call us on +917411000877

Contact us on +917411000877