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/
Microsoft Visio 2013/2013
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
Learn One Note 2010
Learn One Note 2013
Mail Merge add individual images
Microsoft Project 2007 pt 5 (Master Project)
In this video learn to link separate project files into one Master project with one Resource pool to share resources across projects.
Microsoft Project 2007 pt 4 (Advanced formatting & Custom Fields & Macros)
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.
Microsoft Project 2007 pt 3 (Resource levelling & Reports)
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.