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