4 Weekends Advanced Microsoft Excel Training in Saint John

COVID-19: many events have been canceled or postponed, please check with the organizer the event status.
4 Weekends Advanced Microsoft Excel Training in Saint John
Image from eventbrite.com
Sat 23 May 2020
Saturday 23 May 2020
12:30 PM - 2:30 PM
Ended

4 Weekends Advanced Microsoft Excel training is a 4 weekends long Instructor-led and guided training with Practical Hands-On Lab exercises to be taught over 16 hours, 2 sessions per weekend, 2 hours per session.

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

4 Weekends 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

1573 Views - 24/05/2020 Last update
culture sports
TruVs
Saint John, NB, CA
Event from
eventbrite.com

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

Saint John, NB, CA

Browse other venues in Saint John
Discover now


Discover more events in Saint John
Discover now



TruVs
Saint John, NB, CA
Event from
eventbrite.com


Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
  1. Saint John
  2. 4 Weekends Advanced Microsoft Excel Training in Saint John
 
 
 
 
Your changes have been saved.