67

MICROSOFT EXCEL COURSES

EXCEL COURSES 2007/2010/2013/2016

INFORMATION ABOUT COURSES AVAILABLE

COURSES are AVAILABLE for EXCEL 2007, EXCEL 2010, 2013 and 2016 EXCEL EXCEL
Course Name Description The duration of the Price (without VAT) Next course Date
Excel Beginner Course Microsoft Office Specialist Excel Level I 16 hours ago 159 EUR 06.09.2018
Excel Course-Advanced Environment Microsoft Office Specialist Excel Level II 16 hours ago 159 EUR 13.09.2018
Excel Expert Course Microsoft Office Specialist Excel Level III 16 hours ago 275 EUR 20.09.2018
Excel VBA Course Microsoft Office Specialist Excel VBA 24 hours 290 EUR 03.09.2018
Course On Excel MACROS Microsoft Office Specialist Excel Macro 16 hours ago 159 EUR N/A
Excel Course Package Level I + Level II Microsoft Office Specialist Excel Package Level I + Level II 24 hours 320 EUR N/A
Excel Course Package Level II + Level III Microsoft Office Specialist Excel Package Level II + Level III 24 hours 450 EUR N/A
Excel Course Package Level I + Level II Level III + Microsoft Office Specialist Excel Package Level I + Level II + Level III 40 hours 550 EUR N/A

INFORMATION ABOUT COURSES AVAILABLE

COURSES are AVAILABLE for EXCEL 2007, EXCEL 2010, EXCEL 2013
Course Name Description The duration of the Price (without VAT) Next course Date
Excel PowerPivot PowerPivot Excel and PowerQuery, data analysis 16 hours ago N/A

AGENDA FOR DEVELOPING MICROSOFT OFFICE SPECIALIST EXCEL LEVEL I

Module 1: Excel Interface 2007/2010/2013/2016

Module 2: introduction to Microsoft Office Excel

Module 3: changing a book work

Module 4: Greetings

Module 6: working with sheets

Module 7: Printing contents on a worksheet

Module 8: creating and modifying Excel graphs (Charts)

Module 9: visualisation Tools/data tracking

AGENDA FOR DEVELOPING MICROSOFT OFFICE SPECIALIST EXCEL LEVEL II

Module 1: Excel Interface 2007/2010/2013/2016

Module 2: beginner level Recap

Module 3: Printing (Page Break Preview)

Module 4: Import/Export database (BD/shortcuts)

Module 5: sorting, simple and complex (multiple columns)

Module 6: simple Filters, custom, advanced

Module 7: data validation (Data Validation)

Module 8: Conditional Formatting (Conditional Formatting)

Module 9: Subtotals

Module 10: Consolidation

Module 11: functions and formulas

Module 12: Goal Seek

Module 13: Scenarios

Module 14: Tracing formulas (Formula Auditing)

Module 15: data protection (Security)

Module 16: Pivot Tables

AGENDA FOR DEVELOPING MICROSOFT OFFICE SPECIALIST EXCEL LEVEL III

Module 1: Sorting complex + Tips and tricks
Module 2: advanced filters + Tips and tricks
Module 3: data validation + Tips and tricks
Module 4: Conditional Formatting based on formulas + Tips and tricks
Module 5: Advanced Subtotals + Tips and tricks
Module 6:3D Consolidations
Module 7: Advanced Functions (Match, Index, Sumproduct, Lookup, ISError, DSUM, DAverage, DCount//etc.)
Module 8: Array Formulas
Module 9: advanced scenarios
Module 10: Solver Tool
Module 11: Pivot Tables in Excel + Slider Tool + Pivot Charts Chart
Module 12: Super tool Excel PowerPivot

MICROSOFT OFFICE SPECIALIST EXCEL VBA

Module 1: Excel Interface 2007/2010/2013/2016

Module 2. Visual Basic Editor

Module 3. VBA Instructions

Module 4. Microsoft Excel Objects

Module 5. Modifying the user interface

Module 6. How to manage errors

MICROSOFT OFFICE SPECIALIST EXCEL MACRO

Module 1: Recording a simple macro

Module 2: using a macro

Module 3: signing up for a complex macro

Module 4: Simplify and protect a macro

MICROSOFT OFFICE SPECIALIST EXCEL PACKAGE LEVEL I + LEVEL II

Module 1: Excel Interface 2007/2010/2013/2016
Module 2: introduction to Microsoft Excel
Module 3: changing a book work
Module 4: formatting a worksheet
Module 5: working with sheets
Module 6: creating and modifying Excel graphs (Charts)
Module 7: data visualization/tracking
Module 8: Formulas
Module 9: Functions
Module 10: Printing (Page Break Preview)
Module 11: Data Import/Export (shortcut-uri BD/Internet)
Module 12: sorting, simple and complex (multiple columns)
Module 13: simple custom Filters, advanced
Module 14: data validation (Data Validation)
Module 15: Conditional Formatting (Conditional Formatting)
Module 16: Subtotals
Module 17: Consolidation
Module 18: Goal Seek
Module 19: Scenarios
Module 20: Tracing formulas (Formula Auditing)
Module 21: data protection (Security)
Module 22: Pivot Tables
Module 23: News from Excel

MICROSOFT OFFICE SPECIALIST EXCEL PACKAGE LEVEL II LEVEL III +

Module 1: Excel Interface 2007/2010/2013/2016
Module 2: beginner level Recap
Module 3: Printing (Page Break Preview)
Module 4: Import/Export database (BD/shortcuts)
Module 5: simple and complex Sorting + Tips and tricks
Module 6: simple Filters, custom, Advanced + Tips and tricks
Module 7: data validation + Tips and tricks
Module 8: simple Conditional Formatting + formula-based + Tips and tricks
Module 9: Subtotal + Tips and tricks
Module 10: Consolidation Consolidation + 3D + Tips and tricks
Module 11: functions and formulas
-Today (), Now (), Year, Month, Day, WeekDay ()
-Conditional-IF (), Choose ()
-BOOLEAN (Logical) AND (), ()
-Text-Left, Right, Len, Trim, Instr, Lower, Upper
-Other TEXT-SURROGATES (), value(), CONCATENATED ()-Standard Aggregates-SUM (), Count (), Average (), Min (), Max ()
-Conditional Aggregate-SumIfs, CountIfs () ()
Module 12: Advanced Functions (Match, Index, Sumproduct, Lookup, ISError, DSUM, DAverage, DCount//)
Module 13: Array Formulas
Module 14: Goal Seek
Module 15: Solver Tool
Module 16: Scenarios
Module 17: Tracing formulas (Formula Auditing)
Module 18: data protection (Security)
Module 19: Pivot Tables + Graphs Pivot Chart
Module 20: Super tool PowerPivot in Excel
Module 21: News from Excel

MICROSOFT OFFICE SPECIALIST EXCEL PACKAGE LEVEL I + LEVEL II LEVEL III +

Module 1: Excel Interface 2007/2010/2013/2016
Module 2: introduction to Microsoft Excel
Module 3: changing a book work
Module 4: Greetings
Module 5: formatting a worksheet
Module 6: working with sheets
Module 7: Printing contents on a worksheet
Module 8: creating and modifying Excel graphs (Charts)
Module 9: Data Import/Export (shortcut-uri BD/Internet)
Module 10: sorting, simple and complex + Tips and tricks
Module 11: simple custom Filters, Advanced + Tips and tricks
Module 12: validate data + Tips and tricks
Module 13: simple Conditional Formatting + formula-based + Tips and tricks
Module 14: Subtotal + Tips and tricks
Module 15: Consolidation Consolidation + 3D + Tips and tricks
Module 16: functions and formulas
-Today (), Now (), Year, Month, Day, WeekDay ()
-Conditional-IF (), Choose ()
-BOOLEAN (Logical) AND (), ()
-Text-Left, Right, Len, Trim, Instr, Lower, Upper
-Other TEXT-SURROGATES (), value(), CONCATENATED ()-Standard Aggregates-SUM (), Count (), Average (), Min (), Max ()
-Conditional Aggregate-SumIfs, CountIfs () ()
Module 17: Advanced Functions (Match, Index, Sumproduct, Lookup, ISError, DSUM, DAverage, DCount//)
Module 18: Array Formulas
Module 19: Goal Seek
Module 20: Solver Tool
Module 21: Scenarios
Module 22: Tracing formulas (Formula Auditing)
Module 23: data protection (Security)
Module 24: Pivot Tables + Graphs Pivot Chart
Module 25: PowerPivot Excel Super tool
Module 26: News from Excel

EXCEL POWERPIVOT & POWERQUERY, ANALYZING DATA

Module 1: introduction to the concepts and terms of BI (Business Intelligence)

Lessons

What is Business Intelligence (BI)?

What is a data warehouse (data warehousing)?

Operational data vs data "historic"

Three-dimensional model

What is a star schema?

What is OLAP (online analytical processing)?

What is DAX (Data Analysis Expression language)?

Module 2: introduction to POWERPIVOT

Lessons

Review concepts and facilities Excel

Excel application limits

Classic swivel tables Excel

PivotTables in PowerPivot

Use Pivottables to produce reports

Managing colonelor irrelevant

Calculation of columns and measures

Adding additional tables

Updating data

Tool Slicers

Module 3: Building POWERPIVOT models

Lessons

What is a data model?

Introduction to handling external data and the relational

Creating and managing database connections towards the

How we can help Microsoft Access application

Connecting to a database system database server (SQL Server)

Application use Microsoft Query

Using data analysis (Sql Server Analysis Services)

Reporting service (Sql Server Reporting Services)

Alternative methods for loading external data (links Excel, Clipboard, etc.)

PowerPivot Query Designer

Power Usage Query to import data

Module 4: managing POWERPIVOT Models

Lessons

Modifying connections towards the external data

Modifying the properties of the tables with data

Definition of custom data tables

Filtering data

Types of data

Create relationships between tables

Managing relationships (one-to-many, many-to-many, multiple keys, etc.)

Diagram View vs. Date View

Defining hierarchies

Module 5: Operations using PIVOT tables

Lessons

Types of pivot tables

Custom sorting

Ration and percentages

Agregari of data without using the SUM function

Calculations Year-to-date

Formatari type graphics and conditioned Sparklines

Powerpivot Slicers vs. Excel Slicers

Key Performance Indicators (KPIs)

Power Usage Query to import data

Creating user panels (dashboards)

Use The Power View

Module 6: best practices

Lessons

Managing and optimizing the use of working memory

Calculated columns vs. measures

Observations related to reincararea/updating data

Observations related to securing an Excel books