Advanced excel boot camp

Description

Why MS Excel

In today’s evolving business environment, all organisational functions need to work on complex spreadsheets representing financial results, budgets, forecasts and plans. As a result, Microsoft Excel has become an integral data processing and analysing tool for making critical business decisions.

Since Microsoft Excel is domain and department agnostic, a strong working knowledge of the software can help you add immense value.

Training objectives

Participants will learn how to

• simplify complex spreadsheets
• streamline operational work by using advanced formulas and templates
• use advanced functions to improve productivity
• enhance spreadsheets by applying visual elements such as charts and graphics

Who should attend

• 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.

Our deliverables

• 16 Hours of face-to-face classroom sessions
• Practice material
• Workbooks
• Assessments and quizzes
• Certificate of participation

Course coverage

• Custom and conditional formats
  1. Creating a custom format
  2. Creating a custom number format
  3. Using conditional Formatting
  4. Creating conditional formatting
  5. Editing conditional formatting
  6. Adding conditional formatting
  7. Deleting conditional formatting from the selected range
• Range names
  1. Using range names
  2. Creating range names
  3. Using range names in formulas
  4. Creating range names from headings
  5. Deleting range names
• Formulas and functions
  1. Text function
  2. Logical functions
  3. Date and time functions
  4. Information function
  5. Database functions
  6. Math and trigonometry functions
  7. Statistical functions
  8. LOOKUP and reference functions
• Managing, sorting and filtering tables
  1. Creating tables
  2. Naming the tables
  3. Changing the table style
  4. Creating a total row
  5. Creating a calculated column
  6. Using filters in a table
  7. Removing the duplicate record
• Charts
  1. Creating a chart
  2. Formatting a chart
  3. Adding labels
  4. Changing the chart type, data source
• Pivot tables
  1. Creating pivot tables
  2. Adding pivot table report fields
  3. Refreshing pivot table reports
  4. Changing the summary functions
  5. Creating report filter page
• Working with shared workbooks
  1. Sharing a workbook
  2. Opening and editing a shared workbook
  3. Tracking changes
  4. Resolving conflict in a shared workbook
• Multiple workbooks
  1. Linking workbooks
  2. Editing link
  3. Consolidating workbooks
• Worksheet and workbook protection
  1. Protecting your worksheet
  2. Protecting range with password
  3. Protecting your workbook and Excel file

Cancellation and refund policy

The refund policy in case of withdrawal of nomination would work as follows:-

• A refund of 50% of the fee would be provided for cancellation requests received up to five working days before the training start date
• Participants who cancel in less than five working days, or there is no show on the training date are  liable to pay the full course fee and would not be entitled to refunds.

Cancellations must be made via emails only. However desirous participants can be accommodated in the future batches of programme, without paying anything extra. It is requested that willingness to attend any future programme should be communicated at the earliest convenience.