Objective:
This Advanced Excel program will help participants in enhancing the ability to use spreadsheets, graphing, tables, calculations, and automation, efficiently to process large quantities of data relevant to business tasks.
Topics Covered:
➱ Brush-up on Basics
➱ Working with Cell Reference
➱ List Management
➱ Working wit Formulas & Functions
➱ Sorting & Filtering data
➱ Working with Styles & Conditional Formatting
➱ Working with Lookup Functions
➱ Working with Range Names
➱ Data Validation
➱ Working with Templates
➱ What-If Analysis(optional)
➱ More Functions
➱ Workbook Sharing and Auditing
➱ Working with Professional Reports & Graph
➱ Basics of Macros(VBA)
Target Audience:
➱ Working professionals across industries
➱ Freshers/ New Joiners across industries
➱ Students/ Entrepreneurs/ Teachers/ Tutors/ Facilitators/Anyone seeking to upskill
➱ Self Employed ( Lawyers, Entrepreneurs, Doctors, Consultants etc)
➱ Students Youngsters aspiring to join corporates
➱ People aspiring to start their business
➱ Organizations looking to train their workforce on Advanced Excel
What will I learn?
- Use different methods for entering and editing data and the various ways to write simple formulas.
- Examine spreadsheet concepts and explore the Microsoft Office Excel environment.
- Create, enter and Modify a worksheet and workbook.
- Work with Formulas & Functions, Cell Reference, Styles & Conditional Formatting.
- Learn to use functions and formulas.
- Create and edit charts and graphics.
- Filter and sort table data.
- Work with templates, professional reports, graphs, pivot tables and charts.
- Import and export data.
- Hands-on live demonstration and practice by expert
- Participants join from their location
- Real-time Q&A session
- Live Chat facility for having individual /group conversations
Write a public review