Advanced Excel Coaching Classes in Mandla
Advanced Excel Training will include following topics:
Introduction to Excel cells, ribbons and providing 200+ Excel shortcut keys.
- Save and print workbooks.
- Enter and edit data.
- Modify a worksheet and workbook.
- Work with cell references.
- Learn to use functions and formulas.
- Create and edit charts and graphics.
- Filter and sort table data.
- Work with pivot tables and charts.
- Import and export data.
- Outline
- Excel Basics
- Work with Cells and Worksheets
- Calculate Your Data
- Format your Workbook
- Add Charts and Graphics
- Collaborate with Others
- Analyze your Data
- Work with Macros and the Web
- Conditional Formatting
- Data Validation
- Paste Special
- Advanced Filter
- Auto Fill
- Flash Fill
- Consolidation
- Functions and Formulas
- Data cleaning formulas and techniques
- Introduction to basic pivot table and data analysis with advanced pivot table
- Excel macro recording for data automation
