Projektmanagement mit Excel

Planning and Managing Projects with Excel

With practical examples, built step by step. Keep track of deadlines, costs, and resources. Useful VBA macros for project managers. Business Intelligence reports with PowerQuery and Power BI Desktop.

Plan, monitor, and manage projects – this is also possible with Excel in Microsoft 365. Ignatz Schels and Prof. Dr. Uwe M. Seidel are experienced project managers and project controllers. They will show you how to use Microsoft's spreadsheet program for efficient project management. Here, you will practice on a real project: creating checklists, project structures, and cost plans, monitoring deadlines and budgets, and documenting with infographics and charts. You will learn the best features and essential analysis tools of Excel with the two authors and program your first macros using the VBA macro language. Project management with Excel – give it a try, it works!

In the new edition, you will find practical examples of the BI tools PowerQuery, Power Pivot, and Power BI, as well as tips on the latest Excel functions and tools like dynamic arrays.

All examples, tools, and VBA macros are available for download.

EXTRA: E-Book included. System requirements for E-Book included: Internet connection and Adobe Reader or Ebook Reader or Adobe Digital Editions.