4 Weeks Advanced Microsoft Excel Training in Guilford

4 WEEKS 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. 4 WEEKS ADVANCED MICROSOFT EXCEL TRAINING SCHEDULE * May 26, 2020 - June 18, 2020 US Pacific time * 4 Weeks | 2 hours on Tuesdays, 2 hours on Thursdays every week | US Pacific Time * 6:30 PM - 8:30 PM US Pacific time each of those days * Please click here to add your location and find your local date and time for the 1st session to be held on May 26, 2020 at 6:30 PM US Pacific Time. [https://www.timeanddate.com/worldclock/converter.html?iso=20200527T013000&p1=234] 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