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 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.
Create Resource list and assign them to Tasks. Change individual Resource Hours & charges if they change mid project. Understand different types of Resources and learn to add Fixed Cost to Tasks.
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.