Projects 2

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 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.

Macros used to refresh and filter your reports, and macros and designated buttons to navigate Excel sheets. You will also learn what you need to know about the Visual Basic editor.

The solution can be shared on:

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

The  Excel course includes:

• 10 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.
• 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, meaning you can manage your projects in a different way straight away.
• A library of macros
• Solution – template with macros – Project.xlsm to be used straight away or customized to meet your requirements.

Recommended: users who want to easily upgrade reports with macros and extend the functionality of Microsoft Excel with prefixes, IT staff.
Learning time: 10 hours to 4 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:

*with videos included