Advanced excel boot camp
5.0 /5- Offered byGrant Thornton
Advanced excel boot camp at Grant Thornton Overview
Duration | 16 hours |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Advanced excel boot camp at Grant Thornton Highlights
- Certificate of participation
- 16 Hours of face-to-face classroom sessions
- Practice material
- Workbooks
- Assessments and quizzes
Advanced excel boot camp at Grant Thornton Course details
- This course is helpful for employees at all levels across verticals (HR, finance, sales and marketing, etc) who work on large spreadsheets and are responsible for reporting and managing MIS
- This course is also designed for students who want to analyse data using the rich features of Microsoft Excel
- The course is also designed for students would want to learn how sort and filter data, import and export data sets, and analyse data using the rich features provided in Excel
- It will impart the necessary skills to collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data
- Learner will be able to simplify complex spreadsheets
- Learner will be able to streamline operational work by using advanced formulas and templates
- Learner will be able to use advanced functions to improve productivity
- enhance spreadsheets by applying visual elements such as charts and graphics
Advanced excel boot camp at Grant Thornton Curriculum
Custom and conditional formats
Creating a custom format
Creating a custom number format
Using conditional Formatting
Creating conditional formatting
Editing conditional formatting
Adding conditional formatting
Deleting conditional formatting from the selected range
Range names
Using range names
Creating range names
Using range names in formulas
Creating range names from headings
Deleting range names
Formulas and functions
Text function
Logical functions
Date and time functions
Information function
Database functions
Math and trigonometry functions
Statistical functions
LOOKUP and reference functions
Managing, sorting and filtering tables
Creating tables
Naming the tables
Changing the table style
Creating a total row
Creating a calculated column
Using filters in a table
Removing the duplicate record
Charts
Creating a chart
Formatting a chart
Adding labels
Changing the chart type, data source
Pivot tables
Creating pivot tables
Adding pivot table report fields
Refreshing pivot table reports
Changing the summary functions
Creating report filter page
Working with shared workbooks
Sharing a workbook
Opening and editing a shared workbook
Tracking changes
Resolving conflict in a shared workbook
Multiple workbooks
Linking workbooks
Editing link
Consolidating workbooks
Worksheet and workbook protection
Protecting your worksheet
Protecting range with password
Protecting your workbook and Excel file
Other courses offered by Grant Thornton
Advanced excel boot camp at Grant Thornton Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?