Computer Courses

Advanced Excel

Courses
Advanced Excel

Learning Academy distinguished itself as the leading Advanced Excel Training Institute in Bangalore. Our Advanced Excel Training Consultants or Trainers are highly qualified and experienced to deliver high-quality Advanced Excel Training across Bangalore.


Learning Academy is considered pioneer in the field of IT/Non-IT Training in Bangalore. We are mainly focused on revolutionizing learning by making it interesting and motivating. We provide range of career oriented courses for different segments like students, job seekers and corporate citizens.


Our team of certified experts have designed our Advanced Excel Training course content and syllabus based on current requirements from the industry. This enables them to be an Industry-Ready Professional, capable of handling majority of the real-world scenarios. Learning Academy also offer tailored made Advanced Excel Training courses for Corporates.


Our Advanced Excel Training in Bangalore is scheduled normally at a time that best suites you, we offer regular training classes (day time classes), weekend training classes, and fast track training classes. Our Advanced Excel Training course fee is economical and tailor-made based on training requirement. Our team will make you confident & comfortable in cracking interviews.


We also provide online training through which you can access our tutorial Anywhere, Anytime which is valuable and cost-effective. We provide a captivating interactive environment with dynamic content, e-Learning that not only effectively keeps people up-to-date, but interested as well. It’s a One Stop Shop for all IT and Non IT Training in Ramamurthy nagar, Bangalore.


Our Certification from Micro Soft Will help the Candidate to get the Job on Priority & Also Candidate can apply for Microsoft Badge on resume which makes Something Special in Corporates


TRAINER PROFILE

•Our Advanced Excel Training Trainers has more than 5 Years of Experience

•Has worked on 3 real time Advanced Excel Training projects

•Already trained 60+ Students so far

•Has strong Theoretical & Practical Knowledge


ADVANCED EXCEL TRAINING PLACEMENTS IN BANGALORE

•Advanced Excel Training Placement through Learning Academy

•More than 500+ students Trained

•87% percent Placement Record

•427 Interviews Organized

•Advanced Excel Training in Multiple Locations across Bangalore


MS WORD

Microsoft Word is the leading word processing and document creation tool for both personal and business use.


Use Microsoft Word to improve and enhance written materials and build compelling documents with confidence. Microsoft Word’s technology enables you and your business to:


•Produce, edit and format professional documents


•Create tables, charts and graphics to organize content and assess data


•Design templates to automate document formatting and creation to improve efficiency


Mastering Microsoft Word is a useful skill for all business professionals. Your Microsoft Word training will also prepare you for a Microsoft Office Specialist certification.


MS EXCEL

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.


Because most businesses use Excel, learning how to use the application efficiently opens up more opportunities for employment and career advancement.


When employees know how to use Excel, it improves their efficiency in the workplace. Employees who know how to create detailed worksheets, invoices, charts, and complex formulas achieve professional results in a fraction of the time.


MS POWER POINT

PowerPoint is the leading tool for creating professional, visually engaging presentations.


Use PowerPoint designer to communicate your stories or ideas in a compelling way. Regardless of your design or technical capabilities, PowerPoint empowers you to captivate and persuade audiences with beautiful built-in themes, animation features and a professional presentation mode.


Mastering PowerPoint is a useful skill for all business professionals. Your Microsoft PowerPoint training will also prepare you for a Microsoft Office Specialist certification.


MS OUT LOOK

Microsoft Outlook helps users and businesses manage and prioritize communications, organize workloads and coordinate schedules.


Outlook also integrates well with many popular business environments, devices and applications including Active Directory, SharePoint, Exchange, LinkedIn and Salesforce.


MS PROJECT

Microsoft Project helps individuals and businesses deliver high-quality projects on time and within budget.


With Microsoft Project, businesses and individuals can adjust and manage projects in real time. The program helps teams plan and prioritize tasks, assign resources and track progress and budgets to complete projects more efficiently.


Effective project management starts with access to accurate data. Microsoft Project streamlines project, resource and portfolio management so you can easily oversee all aspects of any given project.


FAQ

Learning Academy is a ISO 9001:2015 Certified Training Centers, which follows the Pre Described Training Format which gives the clear understanding of the Training Subject.

Yes, Learning Academy is Registered under Government of Karnataka.

Yes Learning Academy provides the separate Lab for students practicing, all classrooms are LED Connected to make sure our students feel comfortable.

Yes All Our Courses are Certified Courses, So all the students who completes the training from Learning Academy will be awarded with Course completion Certificate.

Yes, We have Flexible payment options for Students to make payments & we also provide Interest free EMI Options.

Yes, Every Student who joins for the courses will have a 100% Placement Assisstance with us.

Advance Excel Training


1. EXCEL INTRODUCTION

↦ An overview of the screen, navigation and basic spreadsheet concepts

↦ Various selection techniques

↦ Shortcut Keys


2. CUSTOMIZING EXCEL

↦ Customizing the Ribbon

↦ Using and Customizing AutoCorrect

↦ Changing Excel’s Default Options


3. USING BASIC FUNCTIONS

↦ Using Functions – Sum, Average, Max, Min, Count, Counta

↦ Absolute, Mixed and Relative Referencing


4. FORMATTING AND PROOFING

↦ Formatting Cells with Number formats, Font formats, Alignment, Borders, etc

↦ Basic conditional formatting


5. MATHEMATICAL FUNCTIONS

↦ Sum If, Sum Ifs Count If, Count Ifs Average If, Average Ifs


6. PROTECTING EXCEL

↦ File Level Protection

↦ Workbook, Worksheet Protection


7. TEXT FUNCTIONS

↦ Upper, Lower, Proper

↦ Left, Mid, Right

↦ Trim, Len, Exact

↦ Concatenate

↦ Find, Substitute


8. DATE AND TIME FUNCTIONS

↦ Today, Now

↦ Day, Month, Year

↦ Date, Date if, Date Add

↦ Month, Weekday


9. ADVANCED PASTE SPECIAL TECHNIQUES

↦ Paste Formulas, Paste Formats

↦ Paste Validations

↦ Transpose Tables


10. New in Excel 2013 / 2016 & 365

↦ New Charts – Tree map & Waterfall

↦ Sunburst, Box and whisker Charts

↦ Combo Charts – Secondary Axis

↦ Adding Slicers Tool in Pivot & Tables

↦ Using Power Map and Power View

↦ Forecast Sheet

↦ Sparklines -Line, Column & Win/ Loss

↦ Using 3-D Map➢ New Controls in Pivot Table – Field, Items and Sets

↦ Various Timelines in Pivot Table

↦ Auto complete a data range and list

↦ Quick Analysis Tool

↦ Smart Lookup and manage Store


11. Sorting and FILTERING

↦ Filtering on Text, Numbers & Colors

↦ Sorting Options


12. PRINTING WORKBOOKS

↦ Setting Up Print Area

↦ Customizing Headers & Footers

↦ Designing the structure of a template

↦ Print Titles –Repeat Rows / Columns


Advance Excel


13. WHAT IF ANALYSIS

↦ Goal Seek

↦ Scenario Analysis

↦ Data Tables (PMT Function)

↦ Solver Tool


14. LOGICAL FUNCTIONS

↦ If Function

↦ How to Fix Errors – if error

↦ Nested If

↦ Complex if and or functions


15. DATA VALIDATION

↦ Number, Date & Time Validation

↦ Text and List Validation

↦ Custom validations based on formula for a cell

↦ Dynamic Dropdown List Creation using Data Validation – Dependency List


16. LOOKUP FUNCTIONS

↦ VLOOKUP / Hookup

↦ Index and Match

↦ Creating Smooth User Interface Using Lookup

↦ Nested VLOOKUP

↦ Reverse Lookup using Choose Function

↦ Worksheet linking using Indirect

↦ VLOOKUP with Helper Column


17. PIVOT TABLES

↦ Creating Simple Pivot Tables

↦ Basic and Advanced Value Field Setting

↦ Classic Pivot table

↦ Grouping based on numbers and Dates

↦ Calculated Field & Calculated Items


18. Arrays Functions

↦ What are the Array Formulas, Use of the Array Formulas?

↦ Basic Examples of Arrays (Using ctrl+shift+enter).

↦ Array with if, Len and mid functions formulas.

↦ Array with Lookup functions.

↦ Advanced Use of formulas with Array.


19. CHARTS and slicers

↦ Various Charts i.e. Bar Charts / Pie Charts / Line Charts

↦ Using SLICERS, Filter data with Slicers

↦ Manage Primary and Secondary Axis

Student Reviews
  • Reviews
    Nithya shree

    It’s a Best place to learn any additional course to grow in Career. I would definitely recommend “Learning Academy” for the one who is willing to learn something to achieve their career goals or to increase their knowledge.

    / 5 Star
  • Reviews
    Swathi Gowda

    Very friendly and polite instructors, They give preference to our timings, Many courses are availabel one of the best I would suggest it for all. Thank you

    / 5 Star
  • Reviews
    Muskan Alia

    Good teaching facilities, proper training provided by the trainer and practice session also I choose this institution as it was cost effective

    / 5 Star
Leave A Comment
Your Rating:

Course Features

  • Duration : 20 Hours
  • Lectures : 20
  • Quizzes : 10
  • Students : 200+

New Batch Starts at
Monday : 01-Jul-2024 and
Wednesday : 03-Jul-2024

Trending Courses