Weekends Advanced Excel Training Course for Beginners Medford

• Phone: +1.206.494.3248
• email: [email protected]
• website: https://skillsharp.co

Weekends Advanced Microsoft Excel training course 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.

• November 7, 2021 - December 4, 2021 US Pacific time
• 4 Weekends | 2 Hours Saturday, 2 Hours Sunday every weekend 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 November 7, 2021 at 7:30 AM US Pacific Time.

• 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

• Basic Excel
• Intermediate Excel
• Advanced Excel

• Anyone who is interested in learning Advanced Microsoft Excel.
• Accountants

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

Host or Publisher Skill Sharp