Excel Advanced Training Course

Course Code

ExcelAdv

Duration

21 hours (usually 3 days including breaks)

Requirements

Knowledge of Windows and the basics of using Microsoft Excel.

Overview

The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.

Course Outline

Adjustment of the working environment

  • Hotkeys, facilities
  • Create and modify toolbars
  • Options excel (autosave, input, etc.).
  • Options paste special (transpose)
  • Formatting (style, format painter)
  • Tool - go to

Organization of information

  • Management sheets (naming, copying, color change)
  • Assign and manage the names of cells and ranges
  • Protect worksheet and workbook
  • Secure and encrypt files
  • Collaboration and track changes, comments
  • Inspection sheet
  • Create your own templates (charts, worksheets, workbooks)

Data analysis

  • Logic
  • Basic Features
  • Advanced Features
  • Creation of complex / multiple formulas
  • Scenarios
  • Search result
  • Solver
  • Charts
  • Graphics support (shadows, charts, AutoShapes)

Database management (list)

  • Data consolidation
  • Grouping and outlining data
  • Sorting data (over 4 columns)
  • Advanced data filtering
  • Database Functions
  • Subtotal (partial)
  • Tables and Pivot Charts

Cooperation with other applications

  • Get External Data (CSV, TXT)
  • OLE (static and link)
  • Web Queries
  • Publication sheets on site (static and dynamic)
  • Publication PivotTables

Automation of work

  • Conditional Formatting
  • Create your own formats
  • Check the validation

Macros - automation tasks in sheets

  • Registration macros
  • Understanding and modifying the code macros (VBA items)
  • Connecting the interface macros or workbook
  • Create forms on screen or printed

Testimonials

trainer patient and knowledge

Iwona Jawdyk - UBS Business Solutions Poland Sp. z o.o.

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lookup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Possibility to ask various questions and real life solutions to them.

Magdalena Wojtas - UBS Business Solutions Poland Sp. z o.o.

Very helpful, made me feel more comfortable using Excel.

TruGreen

I appreciated the amount of effort and energy that Roman put into this. Hours and hours and hours of Excel training will inevitably get boring, but Roman's attention to detail, energy, and thoroughness made me want to keep learning--even at 5 PM on the second, of two, eight hour learning days.

Christian Labenberg - TruGreen

Relevant examples and interesting corriculum

Alex Gubanov - TruGreen

Excellent trainer. Very adept at modifying the course to fit our timeline.

TruGreen

Learning new ways to process data in Excel, in an engaging and fun learning environment.

Hunter Smith - TruGreen

Interaction with the class

TruGreen

The instructor(see Other Remarks below)

TruGreen

Bookings, Prices and Enquiries

Private Classroom

Private Remote

From $4500 (138)

Public Classroom

Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
MySQL Database Administration Atlanta, GA - One Hartsfield Thu, Mar 1 2018, 9:30 am $2570 / N/A
Test Automation with Selenium CO, Denver - Denver Place Mon, Mar 12 2018, 9:30 am $3445 / $4995
Solr for Developers VA, Stafford - Quantico Corporate Mon, Mar 19 2018, 9:30 am $4455 / $5855
Excel VBA Introduction New York (NYC) - Midtown Manhattan - Park Avenue & E48-49th (Grand Central) Mon, Mar 26 2018, 9:30 am $2430 / $4130
Introduction to R New York (NYC) - Midtown Manhattan - Madison & E38-39th Wed, Mar 28 2018, 9:30 am N/A / $5800
JMeter Fundamentals and JMeter Advanced New York (NYC) - Midtown Manhattan - Park Avenue & E48-49th (Grand Central) Wed, Mar 28 2018, 9:30 am N/A / $3850
Drupal 8 for Developers New York (NYC) - Midtown Manhattan - Madison & E38-39th Thu, Mar 29 2018, 9:30 am N/A / $3900
Introduction to IoT Using Arduino WI, Milwaukee - Downtown Milwaukee Mon, Apr 2 2018, 9:30 am $2970 / $4330
Administering MediaWiki New York (NYC) - Midtown Manhattan - Park Avenue & E48-49th (Grand Central) Mon, Apr 2 2018, 9:30 am N/A / $2250
IT Automation with Saltstack Remote Course - Eastern Time (UTC-05:00) US & Canada Wed, Apr 4 2018, 9:30 am $2370 / N/A
SQL Fundamentals New York (NYC) - Midtown Manhattan - Park Avenue & E48-49th (Grand Central) Mon, Apr 16 2018, 9:30 am N/A / $3700
Introduction to Selenium New York (NYC) - Midtown Manhattan - Madison & E38-39th Tue, Apr 17 2018, 9:30 am N/A / $2300
Apache Tomcat Administration IL, Chicago - CBD - West Loop Riverside Plaza Center Wed, May 2 2018, 9:30 am $4833 / $6233
Excel VBA Introduction New York (NYC) - Midtown Manhattan - Park Avenue & E48-49th (Grand Central) Thu, May 10 2018, 9:30 am N/A / $3200
Neural Network in R MA, Boston - Federal Street Mon, Jul 2 2018, 9:30 am $3150 / $4390

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients