Advance Excel Training Institute In Jaipur
Excel
Module 1: Introduction to Excel
- Introduction To Excel Interface
- Understanding Rows And Columns, Naming Cells
- Working With Excel Workbook And Sheets
Module 2: Formatting Excel Work Book:
- New, Open, Close, Save, Save As
- Formatting Text: Font Size, Font Style
- Font Color, Use The Bold, Italic, And Underline
- Wrap Text, Merge And Centre
- Currency, Accounting And Other Formats
- Modifying Columns, Rows & Cells
Module 3: Perform Calculations with Basic Functions
Module 4: Sort and Filter Data with Excel
- Sort And Filtering Data
- Using Number Filter, Text Filter
- Custom Filtering
- Removing Filters From Columns
- Conditional Formatting
Module 5: Create Effective Charts to Present Data Visually
- Inserting Column, Pie Chart Etc.
- Create An Effective Chart With Chart Tool
- Design, Format, And Layout Options
- Adding Chart Title
- Changing Layouts
- Chart Styles
- Editing Chart Data Range
- Editing Data Series
- Changing Chart
Module 6: Proofing and Printing
- Page Setup, Setting Print Area, Print Titles
- Inserting Custom Header And Footer
- Inserting Objects In The Header And Footer
- Page Setup, Setting Margins, Print Preview, Print
- Enable Back Ground Error Checking
- Setting Autocorrect Options.
Advance Excel (Optional)
Module 7: Analyze Data Using Pivot tables and Pivot Charts
- Understand Pivot tables, Create A Pivot table
- Framework Using The Pivot table And Pivot chart
- Create Pivot Chart From Pivot Table.
- Inserting Slicer
- Creating Calculated Fields
Module 8: Protecting and Sharing Workbook
- Protecting A Workbook With A Password
- Allow User To Edit Ranges
- Track Changes
- Working With Comments
- Insert Excel Objects And Charts In Word
- Document and Power Point Presentation.
Module 9: Use Macros to Automate Tasks
- Creating and Recording Macros
- Assigning Macros To The Work Sheets
- Saving Macro Enabled Workbook
Module 10: Advance Formulas
- TEXT Function
- Date & Time Function
- Logical Function
- Financial Function
- Formula Auditing