Call for advice now!
7378123128
Training Highlights
Instructor Led Training
Weekly Doubt clearing Session
Lifetime Assistance for Revision
Lifetime Login Access to Student Dashboard
World-Wide Valid Certification
Study Material, Assignments and Projects
Course Highlights
1
Vlookup & Hlookup
2
Pivot Table
3
Data Validations
4
Introduction to Macros
Course Overview
Microsoft Office Excel allows the business organization to make better decisions, which increases productivity and revenue. It also represents a large amount of data in an efficient and user-friendly manner, which helps the management to identify the current situation of the company. IT DESK training course gives detailed knowledge about the features of Microsoft Excel which includes Pivot Table, Proofing, Charts, Data tools, and other many functions.
Advanced excel helps to perform complex and large calculations, as well as data analysis and better presentation of data. Advanced Excel is used by various businesses worldwide for accounting, administrative purposes, and also for creating and reviewing reports. IT DESK promotes the students to do Internships and all the online Trainings are provided on the latest version of Microsoft Excel.
IT DESK certificate provides an excellent way to distinguish oneself from others and escalate the students’ career.
Course Contents
- Get a head start with templates and set up an Excel template
- Create new default workbook and worksheet templates
- Learn how modular templates can make your spreadsheets more consistent and much quicker to set up
- Customizing the Excel interface to put the tools that you need at your fingertips
- How to build in checks and controls from the outset
- Key techniques that reduce risk and increase automation and efficiency
- Documentation and review tools
- Outlining and Grouping Data
- Using the Subtotals Tool
- Exploring Scenarios
- Goal Seek and Data Tables
- Using Solver
- Date & Time Validation
- Text & List Validation
- Custom Validations
- Data Validation on Dynamic Dropdown list
- Getting Started with PivotTables
- Displaying Data in a PivotTable
- Formatting a PivotTable
- Using the Classic PivotTable Layout
- Slicers
- Getting Started with Pivot Charts
- Using the PivotChart Tools Tabs
- Formatting a PivotChart
- Hyperlinks
- Custom AutoFill List
- Sharing Workbooks
- VLOOKUP and HLOOKUP Function
- Nested VLOOKUP
- Recording and Playing Macros
- Copying and Deleting Macros
- Visual Basic and Macros
How will you get your certificate?
IT DESK is a pioneer in CS/IT training and most of the industries give great recognition to its certificate throughout India and abroad. IT DESK Certificates are ISO verified which makes it highly reputed comparing to the other local brands and helps the student get prioritize while going for job opportunities in the industry. IT DESK Software Training is conducted by highly knowledgeable trainers which help students to enhance their skill set by putting great emphasizes on project-based learning.
Reviews from students
How Our instructors are certified
IT DESK has a team of highly skilled trainers, who focus on delivering well standard and quality training to each of its learners. Each IT DESK trainer has professional degrees and has more than 5 years+ of experience in the stream of Computer Science and Information Technology. Along with that, they are certified from prestigious institutes and have esteem knowledge of their courses which helps the learners to enhance their skills and meet the industry requirements. Our courses are not just based on theoretical concepts; in fact, it puts a great emphasis on industry-driven learning which is being regularly updated
Frequently Asked Questions(FAQ)
No such prerequisite, however a basic knowledge of the subject is preferable.
Generally, the average training duration is 2 hours daily. Although if someone wants a half-day or full-day fast track course these are also available.
Yes, the study material is included in the course. IT DESK provides you the exercise books and a multicolor reference guide which helps to revise the whole software anytime.
The certificate shall be provided in both digital and physical form once you complete the training. The certificate shall be displayed in your login after you complete the training. You can collect the physical certificate from the center.
Cad desk is a pioneer in CS/IT training and most industries and Universities/colleges recognize its certificate by reputation.
This is lifetime access to your login and all its benefits.
Definitely, IT DESK being the leader in CS | IT, receives many openings on day to day basis, and registered students shall be able to access that information.
Related Courses
Advance Java(J2EE)
Tally ERP
Data Science With R Programming
PHP
Data Science with Python
Tableau
Web Design
Ethical Hacking
Adv. Excel
Mobile Application Development (Android)
ASP.NET MVC
Core Java
CorelDRAW Graphics Design
Adobe Photoshop
Core Python Programming
C#
C++
C Programming
Course Categories
