Projects 3

79.00 €
99.00 €
Excel course short description

Network project management solution in Excel – Projects 2 upgraded to a network environment. You will gain advanced-level skills in Excel, to use spreadsheets, design, tables, formulas and automation efficiently to process large quantities of data relevant to business tasks. On your computer or on local network.

Excel course description


On the network, separate file folders are organized for each department or user. The files have the identical data structurewhat is different are the settings for a particular department or company. Code lists are centralized and linked to all files by Queries. When opening the file, the code lists' data is refreshed in real time. Window settings to work with files can be defined for each folder.

Data from all files is linked to a common database that is used to create interactive reports, dashboards, KPIs. Macros are recorded to refresh databases.

You will learn Microsoft Excel network settings – a perfect way to automate the work process.


The Excel course includes:

  • 10 interactive Power Point presentations with videos included. You will follow the instructions and click through the commands in the interactive presentation and learn how to simplify and automate project management using a real-life example.
  • 15 Excel files to learn or use directly in your work. You will receive the final solution explained step-by-step in the interactive presentation, in a separate XLSM file. You can modify and use it either to learn or directly in your work which means you can manage your projects in a different way straight away.
  • A library of macros
  • A network solution (organized folders, database, reports, centralized code list) – template with macros – Project.xlsm to be used straight away or customized to meet your requirements.

Recommended: advanced users, IT staff
Learning time: 12 hours to 5 days, depending on your prior knowledge and available time
For: Microsoft Excel  2010, 2013, 2016, 2019, 2021 and  Microsoft Office 365

YOU WILL RECEIVE THE FOLLOWING FILES:

Interactive Power Point presentations*  Excel files Excel macro library Network solution
3.0 Before you start.ppsm 3.1 Projects.xlsm PersonalMacro_Module1.bas 1. Departments
3.1 Projects List.ppsm 3.2 Slicers.xlsm Projects_Module1.bas 2. DATABASE
3.2 Input Interface for the Users.ppsm 3.3 Report 0.xlsm Projects_Module2.bas 3. Reports
3.3 Signalization and Data Control.ppsm 3.4 Report 1.xlsm Projects_Module3.bas 4. Lists
3.4 Design.ppsm 3.5 Report 2.xlsm Reports_Module1.bas 5. ProjectsTemp.xlsm
3.5 Report.ppsm 3.6 Report 3.xlsm

3.6 Final Touch.ppsm 3.7 Report 4.xlsm

3.7 Settings.ppsm 3.8 Report 5.xlsm

3.8 Double Drop-Down List and Prefix.ppsm 3.9 Report Final.xlsm

3.9 Refreshing Reports using Macro.ppsm 3.10 ProjectsTemp.xlsm

3.10 External Query Connection.ppsm 3.11 Projects1.xlsm

3.11 Pivot Table & Pivot Chart Wizard Connection.ppsm 3.12 Projects2.xlsm


3.13 Projects2_macro.xlsm


3.14 Projects3_macro.xlsm


3.15 Projects.xlsm






*with videos included