Tue Jan 26 2021 at 10:30 am to 12:30 pm
IT Training Center, Tech Training Solutions, Annapolis, United States
This event has been UPDATED since it was first published. View the UPDATED & Detailed Advanced Microsoft Excel Training course for beginners Information here.
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.
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
Also check out other Workshops in Annapolis.
Tickets for 16 Hours Only Advanced Microsoft Excel Training Course Annapolis can be booked here.
Ticket Information | Ticket Price |
---|---|
Early Bird | USD 450 |
General Admission | USD 550 |
Create an online presence of your events and make them easy to discover & share with the relevant audience.
Create Events