\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{yotka}
\pdfinfo{
  /Title (excel-for-accounting.pdf)
  /Creator (Cheatography)
  /Author (yotka)
  /Subject (Excel for accounting 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}{2A5C7D}
\definecolor{LightBackground}{HTML}{F1F4F6}
\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{Excel for accounting Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{yotka} via \textcolor{DarkBackground}{\uline{cheatography.com/39104/cs/12198/}}}
\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}yotka \\
  \uline{cheatography.com/yotka} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Not Yet Published.\\
   Updated 2nd April, 2018.\\
   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}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Note 1}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{If a number is used more than once, e.g. TAX RATE, it's better when it is input to one cell only. Any other calculations making use of that value shoud refer to that cell. If the TAX RATE changes, there is only one place to change it of the s/s.% Row Count 5 (+ 5)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.16 cm} x{5.84 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Basics}}  \tn
% Row 0
\SetRowColor{LightBackground}
=C4*5 & C4 multiplied by 5 \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
=C4*B10 & C4 multiplied by B10 \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
=C4/E5 & C4 divided by E5 \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\seqsplit{=C4*B10-D1} & C4 times B10, less D1 \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
=C4*120\% & adds 20\% to the value in C4 \tn 
% Row Count 5 (+ 1)
% Row 5
\SetRowColor{white}
\seqsplit{=(C4+C5)/2} & brackets first \tn 
% Row Count 6 (+ 1)
% Row 6
\SetRowColor{LightBackground}
=2\textasciicircum{}2 & 2 squared (to the power of) \tn 
% Row Count 7 (+ 1)
% Row 7
\SetRowColor{white}
=2\textasciicircum{}3 & 2 cubed \tn 
% Row Count 8 (+ 1)
% Row 8
\SetRowColor{LightBackground}
=4\textasciicircum{}(1/2) & square root of 4 \tn 
% Row Count 9 (+ 1)
% Row 9
\SetRowColor{white}
=27\textasciicircum{}(1/3) & cube root of 27 \tn 
% Row Count 10 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.52 cm} x{4.48 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Absolute Reference  {\bf{ F4}}}}  \tn
% Row 0
\SetRowColor{LightBackground}
{\bf{\$ A 1}} & to fix column A \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
{\bf{A \$ 1 }} & to fix row 1 \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
{\bf{\$ A \$ 1 }} & to fix cel A 1 \tn 
% Row Count 3 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Note: Produce Print Screen}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{Press {\bf{Print Screen}} then {\bf{Ctrl+V}} to paste elsewhere.% Row Count 2 (+ 2)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{6.56 cm} p{1.44 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Convert Time to decimal}}  \tn
% Row 0
\SetRowColor{LightBackground}
2 hours 15 minutes & 2.25 \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
1 hour 30 minutes & 1.50 \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
3 hours 45 minutes & 3:75 \tn 
% Row Count 3 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4.48 cm} x{3.52 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Popular keyboard shortcuts}}  \tn
% Row 0
\SetRowColor{LightBackground}
inserts DATE & {\bf{Ctrl ;}} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
inserts TIME & {\bf{Ctrl Shift ;}} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
insers Today's DATE & {\bf{=today ( )}} \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
toggle RIBBON from view & {\bf{Ctrl F1}} \tn 
% Row Count 5 (+ 2)
% Row 4
\SetRowColor{LightBackground}
insert the total & {\bf{Alt +}} \tn 
% Row Count 6 (+ 1)
% Row 5
\SetRowColor{white}
highlight column & {\bf{Ctrl SPACE}} \tn 
% Row Count 7 (+ 1)
% Row 6
\SetRowColor{LightBackground}
highlight row & {\bf{Alt SPACE}} \tn 
% Row Count 8 (+ 1)
% Row 7
\SetRowColor{white}
move b'een sheets & {\bf{Ctrl PgDN/PgUP}} \tn 
% Row Count 10 (+ 2)
% Row 8
\SetRowColor{LightBackground}
lock cells & {\bf{F4}} \tn 
% Row Count 11 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{IF formula}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{{\bf{=IF(logical\_test, value\_if\_true, value\_if\_false)}}} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{e.g: =if(D4\textgreater{}1000, "Bonus", " ")} \tn 
% Row Count 3 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Concatenate formula}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{{\bf{=CONCATENATE (text1, " " , text2)}}} \tn 
% Row Count 1 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}