SCHEDULE
March 3, 2021
No avaliable slots
INFO
ADVANCED MICROSOFT EXCEL TRAINING COURSE
Advanced Microsoft Excel training course is Instructor-led and guided and is being delivered for 16 Hours over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session.
Instructor-led and guided training
Practical Hands-On, Highly Interactive training
This course will be taught in English language
All Published Ticket Prices are in US Dollars
4 Weekends Advanced Microsoft Excel Training Schedule
October 31, 2020 - November 22 , 2020 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 city name and check your local date and time for the first session to be held on October 31, 2020 at 7.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
INTERESTED LIST
Be the first and others will follow
EXPERIENCES
Be the first to share photos!
RATINGS & REVIEWS
Nothing here yet. Be the first
INQUIRIES
Interact with the Organizer and other attendees here
ORGANIZER PHOTOS

LOCATION Dubai - Dubai - United Arab Emirates
ORGANIZE EVENTS & ACTIVITIES!
Featured
Get promoted on SCENE
share your reviews and experiences for a better and interactive SCENE community for you and others.
#BetterTogether
Your kind of scenes with your kind of people! Connect with both organizers and attendees!
