Projects 1

39.00 €
49.00 €
Excel course short description

"All-in-One Solution" – A simple project management solution in Excel with a single file and code lists for multiple users. Master Microsoft Excel from beginner to advanced with most common real-world use cases.

Excel course description


When working with Microsoft Excel, users usually create their files in different ways. In this course, you will learn how to create one file for multiple users to enter project tasks. Code lists and drop down list for uniform and signalization for controlled data entry.

You will learn how to create hidden fields to facilitate the review of results in interactive reports. You will learn how to create counters to display additional data and KPIs, as well as design clearer and more user-friendly tables and reports. You will  automate your work in Excel with the combination of the most useful formulas and functions:  VLOOKUP, IF and TODAY ().

The solution can be shared on:

  • SharePoint portal
  • Lotus Domino Server
  • anywhere users have access to the file.

The  Excel course includes:

  • 7 interactive Power Point presentations with videos included. Follow the instructions, click through the commands in the interactive presentation, and learn how to simplify and automate project management using a real-life example.
  • 9 Microsoft Excel files to learn or use directly in your work. You will receive the 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, meaning you can manage your projects in a different way straight away.
  • Solution – template – Project.xlsm to be used straight away or customized to meet your requirements.

By studying the Excel project management example, you will acquire knowledge that will allow you solve problems in different fields.

Recommended: users who want to make their work with Microsoft Excel easier and better. Learning time: 8 hours to 3 days, depending on your prior knowledge and available time

For: Microsoft Excel  2010, 2013, 2016, 2019, 2021 and  Microsoft Office 365

Watch the video to see how simple the learning process is ›

YOU WILL RECEIVE THE FOLLOWING FILES:

Interactive Power Point presentations* Excel files
1.0 Before you start.ppsm 1.1 Projects.xlsm
1.1 Projects List.ppsm 1.2 Slicers.xlsm
1.2 Input Interface for the Users.ppsm 1.3 Report 0.xlsm
1.3 Signalization and Data Control.ppsm 1.4 Report 1.xlsm
1.4 Design.ppsm 1.5 Report 2.xlsm
1.5 Report.ppsm 1.6 Report 3.xlsm
1.6 Final Touch.ppsm 1.7 Report 4.xlsm

1.8 Report 5.xlsm

1.9 Report Final.xlsm

*with videos included