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/
In this video learn about Microsoft Visio 2013. Learn to create Flow chart and Organization Chart. Add design, Background, fields, text. Add Data to symbols using Data Graphics.
Flow chart – min 7:30
Insert Hyperlink – min 19:45
Insert Field – min 23:20
Data Graphics – min 24:35
Print – min 29:45
Organization chart – min 31:10
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.
Learn to use Microsoft Project 2007, add Project Start Date, add calendar work exceptions & work time. Learn to add tasks, duration, notes, attachments. Create Milestones & Summary tasks. Link all tasks together. Learn about different types of Tasks, Task dependency & Constraint types.