16 Hours Only Advanced Microsoft Excel Training Course Dublin
Event Information
About this Event
16 Hours Advanced Microsoft Excel training is a 4 weeks long Instructor-led and guided training with Practical Hands-On Lab exercises to be taught over 16 hours, 2 sessions per week, 2 hours per session.
- The medium of instruction is English.
- All Published Ticket Prices are in US Dollars.
16 Hours Advanced Microsoft Excel Training Course Schedule
- April 27, 2021 - May 20, 2021 US Pacific time
- 4 Weeks | 2 Hours on Tuesdays, 2 Hours on Thursdays every week US Pacific time
- 8:30 AM - 10:30 AM US Pacific time each of those days
- Please click here to add your city name and check your local date and time for the first session to be held on April 27, 2021 at 8:30 AM US Pacific Time.
Features and Benefits
- 4 weeks, 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