Course Overview
Microsoft Excel is a spreadsheet program used to record and analyze data. We will make you learn most widely used spread sheet skills and master the advance excel skills using tables, pivot tables, charts, graphs, filtering, sorting, conditional formatting, dashboarding, data processing, etc. with real time scenarios and datasets. Join this course to stay on top of your data with must have Microsoft Excel skill.
Details of the course is mentioned below :
Course Modules
You will learn :
- Getting Started with Excel
- Data Entry, Data Editing, and Number Formatting
- Data Formatting
- Working with Cells and Ranges in Excel
- Managing Worksheets
- Data Entry, Data Editing, and Number Formatting
- Data Formatting
- Working with Cells and Ranges in Excel
- Managing Worksheets
- Excel Formula Basics
- Logical Formulas in Excel
- Math Formulas in Excel
- Lookup and Reference Formulas in Excel
- Stats Formulas in Excel
- Text Formulas in Excel
- Date and Time Formulas in Excel
- Formulas Mix and Match
- Named Ranges in Excel
- Data Validation in Excel
- Data Sorting and Filtering in Excel
- Using Conditional Formatting in Excel
- Introduction to Excel Charting
- Advanced Excel Charting Examples
- Dynamic Charts in Excel
- Introduction to Pivot table
- Using Slicers
- Creating calculated table
- Creating multiple pivot table from one
- Classic pivot table option
- Advance pivot table options
- Totals and Subtotals
- Looking behind the scenes data of your pivot table
- Refreshing your data
- Advanced Pivot Table Tips and Tricks
- Reporting
- Dashboarding
- Protection in Excel
- Introduction to Macros and VB Editor
- Printing
- Sharing
FAQ
Any graduate, fresher, experienced and looking to start or change their career into data analytics can attend. No prior experience is mandatory.
Absolutely. We start the training from scratch. After completing the course you will not feel that you have never programmed.
Yes
Our trainers are from the industry. Every class is followed by real time assignments which will make you feel confident when you get into a job.
Fully online. You can attend from anywhere. You just need a laptop and a good internet connection
Yes 100%. It is live and fully interactive. We dont believe in running through power point presentations.
Please contact on the given number.
Contact Us
+91 70198 30464 / +91 79911 97543
Enroll / Enquire
Address : Saroj Iris, No. 106 (Wing A), Gunjur, Varthur Hobli, Bangalore - 560087
Phone : +91 70198 30464 / +91 79911 97543
Email :
info@dakshahanalyticsacademy.com, dakshahanalyticsacademy@gmail.com