Excel Advanced Training Course

Description

• Type

  Course

• Methodology

  Online

Description

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.

About this course

Requirements

Knowledge of Windows and the basics of using Microsoft Excel.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

• Excel
• Options
• Database Management
• Database
• Database training
• Data analysis
• Logic
• Graphics
• Web
• MS Excel

Course programme

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

Additional information

21 hours (usually 3 days including breaks)

See related categories

• Logic courses
• Distance learning Logic courses
• Graphics courses
• Distance learning Graphics courses
• Restaurant management courses
• Human resource management courses
• Behaviour management courses
• Spa management courses
• Animal management courses
• Construction site management courses
• Transactional analysis courses
• Sport management courses
• Diploma hotel management courses
• Sports management courses
• Excel vba courses
• Motion graphics courses
• Maintenance management courses
• Iseb business analysis courses
• Site management courses
• Excel courses
• Distance learning Excel courses
• Distance learning Course
• Nobleprog Limited courses