\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{Natalie Moore (NatalieMoore)} \pdfinfo{ /Title (microsoft-project.pdf) /Creator (Cheatography) /Author (Natalie Moore (NatalieMoore)) /Subject (Microsoft Project Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{14A330} \definecolor{LightBackground}{HTML}{F0F9F2} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Microsoft Project Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{Natalie Moore (NatalieMoore)} via \textcolor{DarkBackground}{\uline{cheatography.com/19119/cs/2216/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}Natalie Moore (NatalieMoore) \\ \uline{cheatography.com/nataliemoore} \\ \uline{\seqsplit{www}.jchmedia.com/} \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Published 10th June, 2014.\\ Updated 12th May, 2016.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{2} \begin{tabularx}{8.4cm}{x{2.4 cm} x{5.6 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Task ribbon}} \tn % Row 0 \SetRowColor{LightBackground} View & Select different elements of the project you would like to view \tn % Row Count 3 (+ 3) % Row 1 \SetRowColor{white} Clip board & Cut, paste, copy and paint formatting \tn % Row Count 5 (+ 2) % Row 2 \SetRowColor{LightBackground} Font & Edit fonts and colours \tn % Row Count 6 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Schedule}}} \tn % Row Count 7 (+ 1) % Row 4 \SetRowColor{LightBackground} Percentages & Select completion \% \tn % Row Count 8 (+ 1) % Row 5 \SetRowColor{white} Mark on track & Quickly update tasks to 100\% \tn % Row Count 10 (+ 2) % Row 6 \SetRowColor{LightBackground} Respect links & Reschedule a manually scheduled task according to its links \tn % Row Count 13 (+ 3) % Row 7 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{Link and unlink tasks} \tn % Row Count 14 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{Split tasks} \tn % Row Count 15 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{Indent tasks} \tn % Row Count 16 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{{\bf{Tasks}}} \tn % Row Count 17 (+ 1) % Row 11 \SetRowColor{white} Manually schedule & Disable auto scheduling \tn % Row Count 19 (+ 2) % Row 12 \SetRowColor{LightBackground} Auto schedule & Have MS Project auto schedule your tasks \tn % Row Count 21 (+ 2) % Row 13 \SetRowColor{white} Inspect & Check for warnings, resolve problems in tasks \tn % Row Count 23 (+ 2) % Row 14 \SetRowColor{LightBackground} Move & Move the time of your tasks around \tn % Row Count 25 (+ 2) % Row 15 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Insert}}} \tn % Row Count 26 (+ 1) % Row 16 \SetRowColor{LightBackground} Task & Add a new task \tn % Row Count 27 (+ 1) % Row 17 \SetRowColor{white} Summary & Add a new logical header for a group of tasks \tn % Row Count 29 (+ 2) % Row 18 \SetRowColor{LightBackground} Milestone & Add an event / completion (not a task) \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{x{2.4 cm} x{5.6 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Task ribbon (cont)}} \tn % Row 19 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{{\bf{Properties}}} \tn % Row Count 1 (+ 1) % Row 20 \SetRowColor{white} Information & Populate the Task Information dialog box, which will allow you to add further info to the task such as: Deadlines, notes, custom field and editing predessors, resources and general info. \tn % Row Count 8 (+ 7) % Row 21 \SetRowColor{LightBackground} Notes & Populate the Task Information dialog box at the notes field \tn % Row Count 11 (+ 3) % Row 22 \SetRowColor{white} Details & Split screen to view Task Details Form on lower half of screen \tn % Row Count 14 (+ 3) % Row 23 \SetRowColor{LightBackground} Add to timeline & Add the selected task to the project timeline \tn % Row Count 16 (+ 2) % Row 24 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Editing}}} \tn % Row Count 17 (+ 1) % Row 25 \SetRowColor{LightBackground} Scroll to task & Will take you to your task on the gantt chart \tn % Row Count 19 (+ 2) % Row 26 \SetRowColor{white} Find & Search your Project \tn % Row Count 20 (+ 1) % Row 27 \SetRowColor{LightBackground} Clear & Clear notes, hyperlinks, formatting or an entire row \tn % Row Count 22 (+ 2) % Row 28 \SetRowColor{white} Fill & Continue a value into one or more adjoining cells \tn % Row Count 24 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{x{3.68 cm} x{4.32 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Project ribbon}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{{\bf{Insert}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} Add a subproject to a main project & Easy to manage related projects via a master project with multiple projects within it \tn % Row Count 6 (+ 5) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{{\bf{Apps}}} \tn % Row Count 7 (+ 1) % Row 3 \SetRowColor{white} Store & Go to MS Store to look for apps which work with project. There are free ones and \tn % Row Count 11 (+ 4) % Row 4 \SetRowColor{LightBackground} My apps & Access your apps \tn % Row Count 12 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Properties}}} \tn % Row Count 13 (+ 1) % Row 6 \SetRowColor{LightBackground} Project information & View Project Information dialog box \tn % Row Count 15 (+ 2) % Row 7 \SetRowColor{white} Custom fields & Manage your custom fields \tn % Row Count 17 (+ 2) % Row 8 \SetRowColor{LightBackground} WBS & Define or renumber the work breakdown structure \tn % Row Count 20 (+ 3) % Row 9 \SetRowColor{white} Change working time & Manage work days and availability \tn % Row Count 22 (+ 2) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{{\bf{Schedule}}} \tn % Row Count 23 (+ 1) % Row 11 \SetRowColor{white} Calculate project & Calculate project if you have made a change. Only nessessary if you have turned calculations off in Project Options \tn % Row Count 29 (+ 6) % Row 12 \SetRowColor{LightBackground} Set baseline & Take a snapshot of schedule which includes tasts, resources and assignments. Compare multiple in future to see changes. \tn % Row Count 35 (+ 6) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{x{3.68 cm} x{4.32 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Project ribbon (cont)}} \tn % Row 13 \SetRowColor{LightBackground} Move project & Change entire projects start date. Can tick box to also move deadlines \tn % Row Count 4 (+ 4) % Row 14 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Status}}} \tn % Row Count 5 (+ 1) % Row 15 \SetRowColor{LightBackground} Status date & Set status date to report progress of the project. Used for progress and earned value calculations \tn % Row Count 10 (+ 5) % Row 16 \SetRowColor{white} Update Project & Update progress info and reschedule work for some or all tasks in the project \tn % Row Count 14 (+ 4) % Row 17 \SetRowColor{LightBackground} {\bf{Proofing}} & Spell check \tn % Row Count 15 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{x{2.56 cm} x{5.44 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Resource Ribbon}} \tn % Row 0 \SetRowColor{LightBackground} {\bf{View}} & Team Planner - Switch to team planner view \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Assignments}}} \tn % Row Count 3 (+ 1) % Row 2 \SetRowColor{LightBackground} Assign resources & To a task \tn % Row Count 5 (+ 2) % Row 3 \SetRowColor{white} Resource pool & Select where to grab resources from, can use existing projects \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} {\bf{Insert}} & Add resources \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Properties}}} \tn % Row Count 10 (+ 1) % Row 6 \SetRowColor{LightBackground} Information & View Task Detail Information box \tn % Row Count 12 (+ 2) % Row 7 \SetRowColor{white} Notes & View Notes in Task Detail Information box \tn % Row Count 14 (+ 2) % Row 8 \SetRowColor{LightBackground} Details & Screen will split and the Task Details Form will populate on the bottom half of the screen \tn % Row Count 18 (+ 4) % Row 9 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Level}}} \tn % Row Count 19 (+ 1) % Row 10 \SetRowColor{LightBackground} Level selection & Level resolves resource conflicts by delaying or splitting tasks \tn % Row Count 22 (+ 3) % Row 11 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{Level resource} \tn % Row Count 23 (+ 1) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{Level all} \tn % Row Count 24 (+ 1) % Row 13 \SetRowColor{white} Levelling options & update your preferences for leveling tasks \tn % Row Count 26 (+ 2) % Row 14 \SetRowColor{LightBackground} Clear leveling & Clear any leveling delay which has been added to the task or project. \tn % Row Count 29 (+ 3) % Row 15 \SetRowColor{white} Next \seqsplit{overallocation} & move to the next cell with resources which have been over allocated \tn % Row Count 32 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{x{2.56 cm} x{5.44 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Report Ribbon}} \tn % Row 0 \SetRowColor{LightBackground} {\bf{Project}} & Compare projects. Compare two versions of the same project. Kind of 'What If' analysis. \tn % Row Count 4 (+ 4) % Row 1 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{View Reports}}} \tn % Row Count 5 (+ 1) % Row 2 \SetRowColor{LightBackground} New report & Create a Blank, Chart, Table or Comparison report \tn % Row Count 7 (+ 2) % Row 3 \SetRowColor{white} Dashboards & Burndown, Cost Overview, Project Overview. Upcoming Tasks, Work Overview and more \tn % Row Count 10 (+ 3) % Row 4 \SetRowColor{LightBackground} Resources & Overallocated resources and resource overview \tn % Row Count 12 (+ 2) % Row 5 \SetRowColor{white} Costs & Cash flow, overruns, earned value report, resource cost overview, task cost overview \tn % Row Count 16 (+ 4) % Row 6 \SetRowColor{LightBackground} In progress & Critical tasks, late tasks, milestone report, slipping tasks \tn % Row Count 19 (+ 3) % Row 7 \SetRowColor{white} {\bf{Getting started}} & {\bf{Best practice analyser, create reports, get started with project, organise tasks, share with your team}} \tn % Row Count 23 (+ 4) % Row 8 \SetRowColor{LightBackground} Custom & More reports \tn % Row Count 24 (+ 1) % Row 9 \SetRowColor{white} Recent & More reports \tn % Row Count 25 (+ 1) % Row 10 \SetRowColor{LightBackground} {\bf{Visual reports}} & View the projects data in Pivot tables in Excel and Visio \tn % Row Count 28 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{x{2.4 cm} x{5.6 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{View Ribbon}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{{\bf{Task views}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} Gantt Chart & Using resource name or progress tracking \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} Task Usage & View all tasks and the resources assigned. Use to update all tasks easily at the end of a day/week \tn % Row Count 7 (+ 4) % Row 3 \SetRowColor{white} More views & Select other available ways to view tasks \tn % Row Count 9 (+ 2) % Row 4 \SetRowColor{LightBackground} {\emph{Network diagram}} & {\emph{View tasks as a diagram to see how they are interconnected}} \tn % Row Count 12 (+ 3) % Row 5 \SetRowColor{white} Calendar & View tasks on a calander by month, week or custom view \tn % Row Count 14 (+ 2) % Row 6 \SetRowColor{LightBackground} Other views & Brows a number of other veiws available \tn % Row Count 16 (+ 2) % Row 7 \SetRowColor{white} \mymulticolumn{2}{x{8.4cm}}{{\bf{Resource Views}}} \tn % Row Count 17 (+ 1) % Row 8 \SetRowColor{LightBackground} Team planner & See what everyone is allocated to \tn % Row Count 19 (+ 2) % Row 9 \SetRowColor{white} Resource usuage & See how everyones hours are allocated \tn % Row Count 21 (+ 2) % Row 10 \SetRowColor{LightBackground} Resource sheet & View resource details \tn % Row Count 23 (+ 2) % Row 11 \SetRowColor{white} Other views & Select from other views available \tn % Row Count 25 (+ 2) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{{\bf{Data}}} \tn % Row Count 26 (+ 1) % Row 13 \SetRowColor{white} Sort & Sort data by name, cost or ID \tn % Row Count 28 (+ 2) % Row 14 \SetRowColor{LightBackground} Tables & View in and export tables \tn % Row Count 29 (+ 1) % Row 15 \SetRowColor{white} Highlight & Highlight tasks based on "If \#\#, then highlight" \tn % Row Count 31 (+ 2) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{x{2.4 cm} x{5.6 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{View Ribbon (cont)}} \tn % Row 16 \SetRowColor{LightBackground} Group by & Group tasks based on "If \#\#, then group" \tn % Row Count 2 (+ 2) % Row 17 \SetRowColor{white} {\bf{Zoom}} & Various zoom tools \tn % Row Count 3 (+ 1) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{2}{x{8.4cm}}{{\bf{Split view}}} \tn % Row Count 4 (+ 1) % Row 19 \SetRowColor{white} Timeline & Add or remove timeline view from top of page \tn % Row Count 6 (+ 2) % Row 20 \SetRowColor{LightBackground} Details & add or remove details (on various areas of the project) from bottom of page \tn % Row Count 9 (+ 3) % Row 21 \SetRowColor{white} {\bf{Window}} & Various Window view selections \tn % Row Count 11 (+ 2) % Row 22 \SetRowColor{LightBackground} {\bf{Macros}} & Add and edit macros \tn % Row Count 12 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}