Create Event
Search results for:
No result found! Try with different keywords!
Advertisement
16 Hours Only Advanced Microsoft Excel Training Course Annapolis

16 Hours Only Advanced Microsoft Excel Training Course Annapolis

Tue Jan 26, 2021

16 Hours Only Advanced Microsoft Excel Training Course Annapolis

Time Tue Jan 26 2021 at 10:30 am to 12:30 pm

(add to calendar)

IT Training Center, Tech Training Solutions, Annapolis, United States

USD 450
Find Tickets on eventbrite.com
Advertisement

16 Hours Only Advanced Microsoft Excel Training Course Annapolis, 26 January | Event in Annapolis | AllEvents.in 16 Hours Only Advanced Microsoft Excel Training Course Annapolis
16 Hours Advanced Microsoft Excel Training course is Instructor-led, guided training being delivered January 26, 2021 - February 18, 2021.

About this Event

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.

  • The medium of instruction is English.
  • All Published Ticket Prices are in US Dollars.


16 Hours Only Advanced Microsoft Excel Training Course Schedule
  • January 26, 2021 - February 18, 2021 US Pacific time
  • 16 Hours | 2 Hours on Tuesdays, 2 Hours on Thursdays 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 January 26, 2021 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







Also check out other Workshops in Annapolis.

Tickets

Tickets for 16 Hours Only Advanced Microsoft Excel Training Course Annapolis can be booked here.

Get Tickets

Ticket Information Ticket Price
Early Bird USD 450
General Admission USD 550
Search by related topics in Annapolis
Event Photos
Hosted by
Nearby Hotels IT Training Center, Tech Training Solutions, Annapolis, United States
Event details from Report a problem ?

Event Information

Date & Time

Tue Jan 26 2021 at 10:30 am to 12:30 pm
Add to Calendar

Location

IT Training Center, Tech Training Solutions, Annapolis, United States

Advertisement
Discover more events
Advertisement
Make Your Events Easy to Discover

Create an online presence of your events and make them easy to discover & share with the relevant audience.

Create Events