On Demand
Advanced Excel 2024 Training & Certification
Get Trained & Get Certified in Advanced Excel
Students Enrolled
0
+
Ratings for this course
What you'll learn?
- Create and format charts.
- Work effectively with multiple sheets in workbooks.
- Use productivity tools.
- Quick analysis tools and work with the Excel list/database features.
Description
This course will teach students about the functions and features of MS Office Excel. After completing this course, Students will learn how to: create elaborated worksheets and workbooks to display data in an effectual way, use functions and formulas, use PowerPivot to access data sources, create relationships, utilize the PowerPivot DAX expressions and create format reports.
Ideal Candidates for This Course:
- Bussiness Users.
- Students who are interested in Excel.
Curriculum
Total Hours
0
Hours
Advanced Excel
Module1: Share & Protect data
- AImporting data into Excel.
- Protecting specific data and formulae.
- Tracking changes in a workbook.
- Hiding elements of a workbook.
- Workbook security.
- Merging and sharing workbooks.
- Connecting with hyperlinks.
- Preparing workbooks for distribution and review.
- Sharing Excel data externally.
- Important shortcuts in Excel.
Module 2 : Formulae & Functions
- Using name ranges in formulae.
- Text functions (upper, lower, proper, transpose, concatenate etc.)
- Time & date functions.
- Logical formulae (and, if, not, or, etc.).
- Array formulae.
- Lookup formulae (vlookup, hlookup, index, match etc.).
- Statistical formulae (round, average, max, min, sumif, countif, counta, etc.).
- Complex nested formulae.
- Circular references and other errors.
- Formulae auditing.
- Xlookup and other super formulas in Google sheet and excel.
Module 3 : Data management & analysis
- Creating & maintaining data tables.
- Sorting & subtotalling data.
- Auto filter and custom filtering.
- What-if analysis.
- Scenario manager.
- Goal seeker function.
- Solver function.
- Data Table.
- Database Functions in excel.
- Data validation in excel.
Module 4: Pivot Tables & Charts
- Pivot Tables & Charts.
- Creating a pivot table.
- Defining the layout and the presentation of a pivot table.
- Pivoting data elements.
- Selecting, copying, moving or deleting in a pivot table.
- Filtering, sorting and slicing data in a pivot table.
- Creating Dashboard.
Module 5: Charts & graphics
- Selecting the right chart.
- Formatting the labels, titles and legends.
- Managing the axis, data series and scale.
- Modifying and updating source data.
- Saving custom charts.
- Inserting graphic objects.
Module 6: Formatting & Presentation
- Formatting dates, numbers and text.
- Using functions to format text and data.
- Creating and applying custom formats.
- Conditional formatting.
- Installed templates and workbook design.
- Styles & themes.
- Splitting windows and freezing panes.
- Headers, footers and repeated rows/columns.
- Page setup and printing.
Module 7: Macros & VBA
- What is a macro?.
- Recording a macro.
- Running a macro.
- Assigning a macro to a button.
- Macro security.
- Editing a macro using VBA.
- Macro security.
- Editing a macro using VBA.
- Writing a macro in the Visual Basic Editor.
- Creating custom functions using VBA.
- Design of dashboard applications.
Course Features
- Duration: 16 hours
- Training Type: Classroom & Online
- Students Enrolled: 60000+
- Certificate: Yes
- Batch Available: Mon-Sun
- 100% Placement Support: Yes
Salary Scale
Maximum
10 LPA
70%
Average
4 LPA
50%
Minimum
2.5 LPA
30%
Job Role
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
- It is a long established fact that a reader will
Training Option
- Live-Online Instructor Led Training
- 100+ lab assignments & Quizzes
- 24/7 Lab access on Rooman Cloud Lab
- Labs Designed & Mentorship support by Industry Experts
- 5 capstone projects
- Live-Online sessions with Industry Experts & Subject Matter Expert from Rooman
- Access to Recorded Session of Live-Online Classes available 24/7
- Industry Recognized Course Completion Certificate
- Interview Preparation & Placement Support
- In-Person Classroom based Training conducted by Subject Matter Expert
- Flexibility to attend classes at any of our 50+ Centers PAN India
- Hands-on experience at our state-of-the-art Lab
- 100+ lab assignments & Quizzes
- 24/7 Lab access on Rooman Cloud Lab
- Labs Designed & Mentorship support by Industry Experts
- 5 Capstone & 1 real-world project
- Exclusive sessions with Industry & Subject Matter Expert
- Access to Recorded Session of Live-Online Classes available 24/7
- Industry Recognized Course Completion Certificate
- Interview Preparation & Placement Support
- Access to Campus Placement drives
- 1 year access to our LMS
Our Alumni
Exam Partner
FAQ
Item #1
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.