$425.98 – $532.07

16 Hours Only Advanced Microsoft Excel Training Course Monterrey

Actions and Detail Panel

From $425.98

Event Information

Share this event

Date and Time

Location

Location

IT Training Center

Tech Training Solutions

Monterrey

Mexico

View Map

Refund Policy

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Event description
16 Hours Advanced Microsoft Excel Training course is Instructor-led, guided training being delivered December 22, 2020 - January 14, 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 Schedule

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

Share with friends

Date and Time

Location

IT Training Center

Tech Training Solutions

Monterrey

Mexico

View Map

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved