Package 1

139.00 €
169.00 €
Excel course short description

Package includes knowledge how to build "All-in-one" file structure and upgrade it with design - Projects 1, and network solution for costs planning - Costs 1. With this knowledge you can also build network solution for projects.

Excel course description


PROJECTS 1

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.

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.

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

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

COSTS 1

On the network, separate file folders are organized for each department or user. The files have the identical data structure, what 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 permissions to work with files can be defined for each individual user.

Data from all files is linked to a common database 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:

  • 9 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 costs planning using a real-life example.
  • 9 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 which means you can manage your costs in a different way straight away.
  • A library of macros
  • A network solution (organized folders, database, reports, centralized code list) – Annual costs plan –  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 Annual costs plan
4.0 Before you start.ppsm
4.1 Department_Start.xlsm
Macro in Workbook
1. Departments
4.1 Pivot Table & Pivot Chart Wizard.ppsm
4.2 Department_Query.xlsm
Personal Macro
2. Common Costs
4.2 Internal Query Connection.ppsm
4.3 Department_Append_Query.xlsm

3. Lists
4.3. Refreshing Reports using Macro.ppsm
4.4 Department_Macro.xlsm

4. Databases
4.4. External Query Connection and Refreshing.ppsm
4.5 Department_Macro_RESULT.xlsm

5. Reports
4.4.1 Common Costs File Upgrade.ppsm
4.6 Common_Costs.xlsm

6. Refresh Database
4.5. Settings.ppsm
4.7 Department_ExternalQuery.xlsm


4.6. Network Database.ppsm
4.8 Department_Database.xlsm


4.7. Refreshing Databases and Reports.ppsm
4.9 Department.xlsm



* with videos included