About this Event
This event has been UPDATED since it was first published. View the UPDATED & Detailed Advanced Microsoft Excel Training course for beginners Information here.
4 Weekends Advanced Microsoft Excel training course is a 4 weekends long Instructor-led and guided training with Practical Hands-On Lab exercises to be taught over 16 hours, 2 sessions per weekend, 2 hours per session.
- The medium of instruction is English.
- All Published Ticket Prices are in US Dollars.
4 Weekends Only Advanced Microsoft Excel Training Course Schedule
- February 6, 2021 - February 28, 2021 US Pacific Time
- 4 Weekends | 2 hours on Saturdays, 2 hours on Sundays every week US Pacific time
- 7:30 AM - 9:30 AM US Pacific time each of those days
- Please click here to add your location and check your local date and time for first session to be held on February 6, 2021 at 7:30 AM US Pacific Time.
Features and Benefits
- 4 weekends, 8 sessions, 16 hours of total Instructor-led and guided training
- Training material, instructor handouts and access to useful resources on the cloud provided
- Practical Hands-on Lab exercises provided
- Actual code and scripts provided
- Real-life Scenarios
What you will learn?
- Basic Excel
- Intermediate Excel
- Advanced Excel
Who should attend
- Anyone who is interested in learning Advanced Microsoft Excel.
- Accountants
Course Outline
1. Basic Excel
• Introduction
• Basic Calculations
• Microsoft Office Button
• Using worksheets effectively
• Formatting text and numbers
• Saving Excel 2007 files
• Saving an Excel file as a PDF file
• Inbuilt Functions
• Sort Function
• More on sort data
• Formatting data as tables
• Absolute and relative cell reference
• Page layout and print preview
• Printing: display grid lines
• Conditional Formatting
• Charts
• Text to columns
• Auto-filter
2. Intermediate Excel
• Library functions use
• How to avoid auto hyperlinks
• Fill data across worksheets
• How to use comments
• How to remove duplicates
• Template based workbook
• Themes and smartart diagrams
• ‘IF’ function
• Countif
• Nested IF functions
• Advanced filter
• Named ranges
• Subtotals
• Formatting in-cell graphs(conditional format)
• Data validation
• Custom Data Validation
3. Advanced Excel
• Pivot Tables
• Vlookup/Hlookup
• Absolute range calculations
• Goal Seek
• Get external data – text files
• Import data from databases
• Import data from an Excel file
• Array Formulas
• Calculations in Word
• Data tables and sensitivity analysis
• Printing: Repeat specific rows
• Excel Help – Vlookup
Event Venue & Nearby Stays
IT Training Center, Tech Training Solutions, Chantilly, United States
USD 400.00 to USD 500.00