Certificate Course in Advanced Excel
Duration: 30 hrs.
Prerequisite: Basic Computer
Software: Microsoft Excel
Excel Introduction
An overview of the screen, navigation and basic spreadsheet concepts- Various selection techniques
- Shortcut Keys
Customizing Excel
- Customizing the Ribbon
- Using and Customizing AutoCorrect
- Changing Excel’s Default Options
Using Basic Functions
- Using Functions – Sum, Average, Max, Min, Count, Counta
- Absolute, Mixed and Relative Referencing
Formatting and Proofing
- Currency Format
- Format Painter
- Formatting Dates
- Custom and Special Formats
- Formatting Cells with Number formats, Font formats, Alignment,
Borders, etc.
- Basic conditional formatting
Mathematical Functions
- SumIf, SumIfsCountIf, CountIfsAverageIf, AverageIfs, Nested IF,
IFERROR Statement, AND, OR, NOT
Protecting Excel
- File Level Protection
- Workbook, Worksheet Protection
Text Functions
- Upper, Lower, Proper
- Left, Mid, Right
- Trim, Len, Exact
- Concatenate
- Find, Substitute
Date and Time Functions
- Today, Now
- Day, Month, Year
- Date, Date if, DateAdd
- EOMonth, Weekday
Advanced Paste Special Techniques
- Paste Formulas, Paste Formats
- Paste Validations
- Transpose Tables
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 Time Lines in Pivot Table
- Auto complete a data range and list
- Quick Analysis Tool
- Smart Lookup and manage Store
Sorting and Filtering
- Filtering on Text, Numbers &Colors
- Sorting Options
- Advanced Filters on 15-20 different criteria(s)
Printing Workbooks
- Setting Up Print Area
- Customizing Headers & Footers
- Designing the structure of a template
- Print Titles –Repeat Rows / Columns
Advance Excel
What If Analysis
- Goal Seek
- Scenario Analysis
- Data Tables (PMT Function)
- Solver Tool
Logical Functions
- If Function
- How to Fix Errors – if error
- Nested If
- Complex if and or functions
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
Lookup Functions
- Vlookup / HLookup
- Index and Match
- Creating Smooth User Interface Using Lookup
- Nested VLookup
- Reverse Lookup using Choose Function
- Worksheet linking using Indirect
- Vlookup with Helper Column
Pivot Tables
- Creating Simple Pivot Tables
- Basic and Advanced Value Field Setting
- Classic Pivot Table
- Choosing Field
- Filtering Pivot Tables
- Modifying Pivot Table Data
- Grouping based on numbers and Dates
- Calculated Field & Calculated Items
- 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.
Charts and slicers
- Various Charts i.e. Bar Charts / Pie Charts / Line Charts
- Using SLICERS, Filter data with Slicers
- Manage Primary and Secondary Axis
This Advanced Microsoft Excel Course Syllabus is designed by Industry Experts. Our Advanced Excel Course Syllabus covers in-depth knowledge of pivot tables, audit and analyse worksheet data,VBA Macro, utilize data tools, collaborate with others, and create and manage macros with live Projects. This advanced Excel course syllabus is designed for the intermediate Excel user who desires to learn more advanced skills. Learn the most advanced formulas, functions, charts and types of financial analysis to be an Excel power user.
Features of the course
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Et optio cum velit autem dolor reprehenderit saepe assumenda eos, qui. Voluptatem eveniet, illum dolor nemo? Velit maiores quaerat a non dolor praesentium, corporis optio ullam, voluptatem fuga consequatur sed cupiditate quam!
Advance Lab
Excellent Trainers
Reasonable Fees
Apply Now
What Students Say ?
Sankesh Sawardekar
Excellent staff! All the topics covered are explained well and also to a point where you are very sure about that topic ! And the best part about the teaching staff here is they are quite approachable and will always welcome you to redo courses in case of any doubts! I will always refer anyone who needs help with certification courses! ONE OF THE BEST Institute IN KONDHWA. Thank you so much Aims Computer Institute 🙏🙏🙏
Uzma Khan
Sharing My Personal Experience Excellent Teaching.. The Teachers Are Soo Good &Friendly.. Teachers Explain The Concept Very well The Environment Is So Neat And Clean.. Teachers Individually Teaches Every Student ...No Group Teaching. Each Student Is Given A Separate Computer... I Really Thank You All The Teachers And Management of Aims Institute...... Thank You Aims Institute....
Muzammil Bilagi
My experiences at Aims Computer Institute is amazing 100% ' the teachers r experts n friendly ' Easy to learn n acquire knowledge every single day. The best atmosphere i can imagine, never thought ever of bunking classes. If u wanna be self-employed go grab some skills there u won't regret it.
Bol Mahmoud
Aims Computer Institute is a absolutely a very good Institute for all courses. Good teaching & teachers are very friendly & co- operative teaching technique is very Good. as I am student currently learning my course (DAA) in this Institute. thank you so much for your very valuable training.
Prerna Kamble
❤️Teaching is very Best quality , I honestly tell that every Teacher in this Academy are very well skilled. Isak sir has the Excellent knowledge of Design,hence they describe every function in simple words & improve our imagination.💻 🖥️ Animesh sir also explain any concept very deeply. Every student who is learning Tally prime from Animesh sir they are doing best in their field.❤️ Regular Attendance & Topic wise exam are taken time to time by academy 📘✒️ This Academy created many graphic Designer, Data operator, Programmer, Developer till now & continue to create. "It is true that powerful people come from powerful places..!"✅💫
Manish
Best Institute to learn any programming language. Teaching staff is very sound and provides the personal attention towards every students. As a Non programmer I have overcome all my fears over programming language. Thanks to Aims Computer Institute.
Kehkashan Shaikh
I am a student of graphic design. I always think that an institution become successful only because of good teacher and luckily we are very proud to have such a great teacher whose name is Isak sir and Eram mam. Our teacher multi talented and behaviors towards us very friendly. I'm very lucky joining this Institute.😊😊☺️☺️ …
Shahin Shaikh
Aims Computer Institute is 1 of the best Institute for learning any Computer Course...As I Am Student Currently learning my course in this Institute. I am having a very good Experience . Lots of Support by both Animesh sir &Isak sir... Thank you for giving us a good knowledge.... I would Recommend everyone, who want to learn Computer Course please visit to Aims Institute.....best Institute..... Thank you both the Sir...for your guidance & Support...... Thank you 💐💐💐💐💐💐
Numera Mujawar
Aims Computer Institute one of the best Institute for learning any computer courses. I was thought very well here.Isak sir is very friendly and most important thing He is one of the best teacher in the world.He taught me very well. I completed my AutoCAD course here.thanks sir.
Jyoti More
Aims Computer Institute is one of the best Institute for learning any computer courses. I had very good experience. I had completed DCA course. Lecturers are very helpful. I would recommend to anyone interested who wants to learn any computer courses.. Thank you so much animesh sir &Isak Sir for your guidance and support.. Thank you once again.
Uzma Khan
cici inc.
It was really a very good training because i got knowledge of Aims Computer Institute along with the practical Isak Sir has cleared all the doubts that we have. It helps a lot as an employee. I would also like to continue some other courses from here as well. The best part was we got the recording for the offline revise.
Amaan Sayyed
cici inc.
Aims Computer Institute was established in 2000. This Institute has been established with a mission to provide quality education to students in the field of Management & IT to enable them to serve the society in all possible ways. We believe in creating and spreading knowledge in different areas through Innovative Educational Programs and Research along with a High Level of Skill and Management. We, at Aims Computer Institute, have created a very friendly learning environment with the latest Computer Hardware and Software Technologies. Whether you are new to the computer industry or are looking to improve your skills, we have the Right Course for you. Well-qualified, experienced certified Instructors train the participants with Easy-to-Use Step by Step training material in the most optimized period of time. Our students are guided by highly qualified teachers and scholars who in their own way are also counsellors and an inspiration. At Aims Computer Institute, education is designed on a broad-based curriculum with the goal to ignite our student's minds. We believe in creating an environment where students also learn from their peers. It is built on the dream to honour our delegates by giving them an environment to grow Intellectually and Skillfully.
Animesh Bera
Aims Computer Institute is very good Institute for extracurricular activities. Way of learning is good. Staff in this Institute are most efficient. They teach very well and the specialty here is that they teach each child individually.
4206_Sukanya Mangesh Rahate
"Great Service From Tutor" I just wanted to say, that I was provided with excellent support and information by AiMS Computer. The staff was very good and helpfully by the course. Very good place to learn.very good atmosphere of learning.student and class environment is really good.😊😊
It was very Excellent 👍. All the teachers are very good. Isak sir and animesh sir are very awesome. The class is very good and the setup are all good. The pc's are of good company's. Environment is very friendly. Explanation of the topics are gets easy when they teaches. They are very welled experienced teachers. It will be recommended class for your computer courses.