Advance Excel
Syllabus
Module 1 : Perform Calculations With Functions
- Understand Functions, Understand the Components of a Function
- Enter Functions in Worksheets, Type a Function Directly into a Cell
- Use the AutoSum Drop-Down Menu Use the Insert Function Dialog Box
- Nest One Function Inside Another Function, Date and Time Functions
- Financial Functions
- Logical Functions
- Lookup and Reference Functions (V-Lookup and H-Lookup)
- Mathematical Functions
- Statistical Functions
- Text Functions
- Refer to Cells and Ranges in Formulas
- Refer to Other Worksheets and Other Workbooks in Formulas
- Use Range Names and Labels in Formulas
- Troubleshoot Formulas
- Understand and Fix Basic Errors in Formulas
Module 2 : Sort And Filter Data With Excel
- Sort, Perform a Quick Sort by a Single Field
- Perform a Multi field Sort for Finer Sorting
- Sort by a Custom Sort Order
- Filter a to Find Records That Match Criteria
- Perform Quick Filtering with AutoFilter
- Create Custom Filters
- Using Advanced filter
Module 3 : Create Effective Charts To Present Data Visually
- Understand the Basics of Excel Charts
- Create a Chart with the Chart Wizard
- Choose the Right Type of Chart for Your Data
- Use the Chart Toolbar, Select Objects in a Chart
- Configure Chart Options,
- Change the Chart Type
- Change a Chart’s Source Data
- Change the Format ,the Chart Area, Plot area
- Configure and Change the Scale of an Axis
- Liven Up Charts with Patterns, Fills, and Pictures
- Format Individual Chart Elements, Print Charts
- Editing Chart data series
Module 4 :Working with Range Names
- Using Range Names
- Creating Range Names
- Using Range Names in Formulas
- Creating Range Names from Headings
- Deleting Range Names
- Creating 3-D Range Names
Module 5 : Analyze Data Using Pivot Tables And Pivot Charts
- Understand PivotTables
- Create a PivotTable Framework Using the PivotTable and PivotChart Wizard
- Create the PivotTable on the Framework
- Choose PivotTable Options to Configure a PivotTable
- Create Pivot Charts from PivotTables
- Create a Conventional Chart from PivotTable Data
- Creating Calculated fields
- Inserting Slicer
Module 6 : Working with Multiple Workbooks
- Linking Workbooks
- Editing the Link
- Consolidating Workbook & worksheets
Module 7: Protecting And Sharing The Work Book
- Restrict Data and Protect Workbooks
- Check Data Entry for Invalid Entries
- Protect Cells, a Worksheet, or a Workbook
- Protect a Workbook with Passwords
- Work with Comments and Add a Comment to Cell
- Display and Hide the Comments in a Worksheet
- Edit and Format Comments, Delete a Comment
- Insert Excel Objects in Word Documents
- Insert a Chart in a Word Document
- Insert Excel Objects in PowerPoint Presentations
- Insert Word Objects in Worksheets
- Insert PowerPoint Objects in Worksheets
Module 8 : Use Macros To Automate Tasks
- Display the Developers Tab
- Changing Macro Security Setting
- Running a MacroRecording a Macro
- Deleting a Macro
- Assigning a Macro to an Object
Module 9 : 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
- Remove the appropriate check marks to disable any unwanted features
Advance excel
Check the course overview video. Enroll today to learn the powerful excel, very useful in all the careers.