In this learn how to use Solver to solve some bookkeeping or Accounting headaches. In this video you will learn how you can find 2 cells that Sum to a value that you are looking for. Link to Sample file: http://simpletek.ca/files/excel-2013-files/
Category Archive: Tutorials
In this video learn to link separate project files into one Master project with one Resource pool to share resources across projects.
In this video we look at advanced formatting for Gant Chart and Tasks. Also learn to create Custom Calendar, Custom Views. Create Custom fields with formula, drop down menu & graphical indicators. Transfer all custom elements to Global Template. Create & Run Macros.
In this video learn to check for over allocation of resources and how-to fix the problem by using the Leveling too and split task button. Set Baseline. Print Gant Chart, add Cost and Title to the chart. Create/Print Reports. Email project file.