Excel Advanced

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

Client Testimonials

★★★★★
★★★★★

Bookings, Prices and Enquiries

Private Classroom

Private Remote

From $4500 (344)

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]
Neural Network in R MA, Boston - Federal Street Mon, Jul 2 2018, 9:30 am $3150 / $4390
Java Persistence with Hibernate IL, Chicago - CBD - West Loop Riverside Plaza Center Thu, Jul 5 2018, 9:30 am $2970 / $4170
PostgreSQL Administration and Development Atlanta, GA - One West Court Square Tue, Jul 17 2018, 9:30 am $5940 / $7940
Business Process Modelling in BPMN 2.0 MA, Burlington - District Avenue Tue, Jul 17 2018, 9:30 am $4725 / $6725
Haskell Fundamentals OH, Columbus - Galleria at PNC Plaza Tue, Dec 11 2018, 9:30 am $2700 / $4000
MoDAF/NAF Introduction TX, Austin - Littlefield Congress Fri, Dec 28 2018, 9:30 am $1575 / $2575

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.