About Course
In the Advance Excel course, you will learn how to use Microsoft Excel and learn the advanced concepts which are commonly used in various companies. MS Excel is one of the most used feature for storing data, and doing arithmatic and data visualization. MS Excel is used by large number of people from students to CEO of companies. In this course you will cover all important excel topics which are expected in real professional work. This course contains video lecture material, study notes, practice assignments and one project which will help you in mastering advance concepts in MS Excel.
Course Requirement
- Good internet connection
- Microsoft office installed in your computer
Course Structure
- Introduction to MS Excel
- Why we should learn Excel?
- Interface & Terminology
- Overview of MS excel – Worksheet and cell
- Excel Ribbon
- Keyboard shortcuts
- Quick Access Toolbar
- introduction to cells
- Operating on cells/rows/colums
- Cell Formatting
- Number Formats in Cell
- Basic operation- Cut, Copy & Paste, Formatting cell
- Personalizing your Worksheets
- Handling Multiple worksheets
- Find & Replace in multiple worksheets
- Protecting your WorkSheet
- . Printing & Page Layout
- Assignment
- Intro to Excel functions
- Key Formulas in MS Excel
- Cell References
- Date/Time Functions
- Text Functions
- Financial Functions
- Logical Functions
- Lookup Functions
- Data Validation
- Assignment
- Basic tips for working with data
- Freezing panes and view options
- Data sorting
- Data filtering
- Tables and Charts
- Assignment
- Conditional Formatting
- What-If Analysis
- Pivot Tables
- Assignment
Students Testimonials
yes this course was a good match for me because i actually learned things i had no clue about which will help me later and to also teach others.
FAQ
This course covers all the advance level concepts in MS-Excel which are used in real companies. Both students and working professionals can enrol into this course, and learn all the MS-Excel concepts thoroughly.
Basic knowledge of excel is good, but it is not enough to survive in real world. As you know , MS Excel is one of the most used tool in handling and operating on data by different people starting from freshers to CEO/Directors of the companies. This course covers all the major concepts which are used in real world. You will be able to solve day to day business problems using Excel.
This course contains pre-recorded video material,notes, practice assignments and a project. You can learn and practice your Excel skills,and ask your doubts with our teachers. Our teachers are leading professionals for software companies who have been using Excel for more than 10 years.
You can contact our teachers via email and whatsapp. You can also use our public forum to get answers to your queries.
No, this course contains only pre-recorded content. There will not be any live lectures. However, we will offer 24×7 doubt support for handling your queries on timely basis.
Yes, we will offer you a certificate of completion once you are done with all project work and assignments. You can download the certificate and can print it.