\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{holly6901 (holly6901)}
\pdfinfo{
  /Title (excel-formula-s-functions-and-shortcuts.pdf)
  /Creator (Cheatography)
  /Author (holly6901 (holly6901))
  /Subject (Excel formula's functions and shortcuts 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}{A3A3A3}
\definecolor{LightBackground}{HTML}{F3F3F3}
\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 formula's functions and shortcuts Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{holly6901 (holly6901)} via \textcolor{DarkBackground}{\uline{cheatography.com/126769/cs/34126/}}}
\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}holly6901 (holly6901) \\
  \uline{cheatography.com/holly6901} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Published 9th October, 2022.\\
   Updated 9th October, 2022.\\
   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*}{3}

\begin{tabularx}{5.377cm}{x{1.24425 cm} x{3.73275 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Date and time formulas}}  \tn
% Row 0
\SetRowColor{LightBackground}
=NOW & Show the date and time \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
=TODAY() & Show the current date without the time \tn 
% Row Count 3 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{=DAY(TODAY))} & Show today's date in a cell \tn 
% Row Count 5 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{=MONTH(TODAY)} & Show current month in a cell \tn 
% Row Count 7 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{=TODAY()+10} & Add 10 days to current date \tn 
% Row Count 9 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.34379 cm} x{3.63321 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Counting and rounding formulas}}  \tn
% Row 0
\SetRowColor{LightBackground}
=SUM & Calculates the sum of a group of values \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
=AVERAGE & Calculates the mean of a group of values \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
=COUNT & Counts the number of cells in a range that contains numbers \tn 
% Row Count 7 (+ 3)
% Row 3
\SetRowColor{white}
=INT & Removes the decimal portion of a number \tn 
% Row Count 9 (+ 2)
% Row 4
\SetRowColor{LightBackground}
=ROUND & Rounds a number to a specified number of decimal places \tn 
% Row Count 11 (+ 2)
% Row 5
\SetRowColor{white}
=IF & Tests for a true or false condition \tn 
% Row Count 13 (+ 2)
% Row 6
\SetRowColor{LightBackground}
=NOW & Returns the date and time \tn 
% Row Count 14 (+ 1)
% Row 7
\SetRowColor{white}
=TODAY & Returns the date, without the time \tn 
% Row Count 16 (+ 2)
% Row 8
\SetRowColor{LightBackground}
=SUMIF & Calculates a sum from a group of values in which a condition has been met \tn 
% Row Count 19 (+ 3)
% Row 9
\SetRowColor{white}
=COUNTIF & Counts the number of cells in a range that match a criteria \tn 
% Row Count 22 (+ 3)
% Row 10
\SetRowColor{LightBackground}
\seqsplit{=COUNTA(A1:A5)} & Count the number of non-blank cells in a range \tn 
% Row Count 24 (+ 2)
% Row 11
\SetRowColor{white}
\seqsplit{=ROUND(1.457},2) & Rounds 1.45 to one decimal place \tn 
% Row Count 26 (+ 2)
% Row 12
\SetRowColor{LightBackground}
=TRUE & Returns the logical value TRUE \tn 
% Row Count 28 (+ 2)
% Row 13
\SetRowColor{white}
=FALSE & Returns the logical value FALSE \tn 
% Row Count 30 (+ 2)
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{5.377cm}{x{1.34379 cm} x{3.63321 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Counting and rounding formulas (cont)}}  \tn
% Row 14
\SetRowColor{LightBackground}
=AND & Returns TRUE if all of its arguments are TRUE \tn 
% Row Count 2 (+ 2)
% Row 15
\SetRowColor{white}
=OR & Returns TRUE if any argument is TRUE \tn 
% Row Count 4 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.09494 cm} x{3.88206 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Finance}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{=INTRATE} & Calculates the interest rate for a fully invested security \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
=EFFECT & Calculates the effective annual interest rate \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
=FV & Calculates the future value of an investment \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{=FVSCHEDULE} & Calculates the future value of an initial principal after applying a series of compound interest rates \tn 
% Row Count 10 (+ 4)
% Row 4
\SetRowColor{LightBackground}
=IPMT & Calculates the interest payment for an investment for a given period \tn 
% Row Count 13 (+ 3)
% Row 5
\SetRowColor{white}
\seqsplit{=ACCRINT} & Calculates the accrued interest for a security that pays periodic interest \tn 
% Row Count 16 (+ 3)
% Row 6
\SetRowColor{LightBackground}
\seqsplit{=ACCRINTM} & Calculates the accrued interest for a security that pays interest at maturity \tn 
% Row Count 19 (+ 3)
% Row 7
\SetRowColor{white}
\seqsplit{=AMORLINC} & Calculates the depreciation for each accounting period \tn 
% Row Count 21 (+ 2)
% Row 8
\SetRowColor{LightBackground}
=NPV & Calculates the net present value of cash flows based on a discount rate \tn 
% Row Count 24 (+ 3)
% Row 9
\SetRowColor{white}
=YIELD & Calculates the yield of a security based on maturity, face value, and interest rate \tn 
% Row Count 27 (+ 3)
% Row 10
\SetRowColor{LightBackground}
=PRICE & Calculates the price per \$100 face value of a periodic coupon bond \tn 
% Row Count 30 (+ 3)
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{5.377cm}{x{1.09494 cm} x{3.88206 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Finance (cont)}}  \tn
% Row 11
\SetRowColor{LightBackground}
=PMT & Calculates the total payment (debt and interest) on a debt security \tn 
% Row Count 3 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.89126 cm} x{3.08574 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Unit conversion formulas}}  \tn
% Row 0
\SetRowColor{LightBackground}
=CONVERT(A1,"day","hr") & Converts value of A1 from days to hours \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
=CONVERT(A1,"hr","mn") & Converts value of A1 from hours to minutes \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
=CONVERT(A1,"yr","day") & Converts value of A1 from years to day \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
=CONVERT(A1,"C","F") & Converts value of A1 from Celsius to Fahrenheit \tn 
% Row Count 8 (+ 2)
% Row 4
\SetRowColor{LightBackground}
=CONVERT(A1,"tsp","tbs") & Converts value of A1 from teaspoons to tablespoons \tn 
% Row Count 11 (+ 3)
% Row 5
\SetRowColor{white}
=CONVERT(A1,"gal","l") & Converts value of A1 from gallons to litres \tn 
% Row Count 13 (+ 2)
% Row 6
\SetRowColor{LightBackground}
=CONVERT(A1,"mi","km") & Converts value of A1 from miles to kilometres \tn 
% Row Count 15 (+ 2)
% Row 7
\SetRowColor{white}
=CONVERT(A1,"km","mi") & Converts value of A1 from kilometres to miles \tn 
% Row Count 17 (+ 2)
% Row 8
\SetRowColor{LightBackground}
=CONVERT(A1,"in","ft") & Converts value of A1 from inches to feet \tn 
% Row Count 19 (+ 2)
% Row 9
\SetRowColor{white}
=CONVERT(A1,"cm","in") & Converts value of A1 from centimetres to inches \tn 
% Row Count 21 (+ 2)
% Row 10
\SetRowColor{LightBackground}
\seqsplit{=BIN2DEC(1100100)} & Converts binary 1100100 to decimal (100) \tn 
% Row Count 23 (+ 2)
% Row 11
\SetRowColor{white}
=ROMAN & Converts a number into a Roman numeral \tn 
% Row Count 25 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.14471 cm} x{3.83229 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Text Formulas}}  \tn
% Row 0
\SetRowColor{LightBackground}
=LEFT & Extracts one or more characters from the left side of a text string \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
=RIGHT & Extracts one or more characters from the right side of a text string \tn 
% Row Count 6 (+ 3)
% Row 2
\SetRowColor{LightBackground}
=MID & Extracts characters from the middle of a text string \tn 
% Row Count 8 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{=CONCATENATE} & Merges two or more text strings \tn 
% Row Count 10 (+ 2)
% Row 4
\SetRowColor{LightBackground}
=REPLACE & Replaces part of a text string \tn 
% Row Count 11 (+ 1)
% Row 5
\SetRowColor{white}
=LOWER & Converts a text string to all lowercase \tn 
% Row Count 13 (+ 2)
% Row 6
\SetRowColor{LightBackground}
=UPPER & Converts a text string to all uppercase \tn 
% Row Count 15 (+ 2)
% Row 7
\SetRowColor{white}
=PROPER & Converts a text string to proper case \tn 
% Row Count 17 (+ 2)
% Row 8
\SetRowColor{LightBackground}
=LEN & Returns a text string's length in characters \tn 
% Row Count 19 (+ 2)
% Row 9
\SetRowColor{white}
=REPT & Repeats text a given number of times \tn 
% Row Count 21 (+ 2)
% Row 10
\SetRowColor{LightBackground}
=TEXT & Formats a number and converts it to text \tn 
% Row Count 23 (+ 2)
% Row 11
\SetRowColor{white}
=VALUE & Converts a text cell to a number \tn 
% Row Count 25 (+ 2)
% Row 12
\SetRowColor{LightBackground}
=EXACT & Checks to see if two text values are identical \tn 
% Row Count 27 (+ 2)
% Row 13
\SetRowColor{white}
=DOLLAR & Converts a number to text, using the USD currency format \tn 
% Row Count 29 (+ 2)
% Row 14
\SetRowColor{LightBackground}
=CLEAN & Removes all non-printable characters from text \tn 
% Row Count 31 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.44333 cm} x{3.53367 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Mathematics}}  \tn
% Row 0
\SetRowColor{LightBackground}
=B2-C9 & Subtracts values in the two cells \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
=D8*A3 & Multiplies the numbers in the two cells \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{=PRODUCT(A1:A19)} & Multiplies the cells in the range \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{PRODUCT(F6:A1},2) & Multiplies the cells in the range, and multiplies the result by 2 \tn 
% Row Count 9 (+ 3)
% Row 4
\SetRowColor{LightBackground}
=A1/A3 & Divides value in A1 by the value in A3 \tn 
% Row Count 11 (+ 2)
% Row 5
\SetRowColor{white}
=MOD & Returns the remainder from division \tn 
% Row Count 13 (+ 2)
% Row 6
\SetRowColor{LightBackground}
\seqsplit{=MIN(A1:A8)} & Calculates the smallest number in a range \tn 
% Row Count 15 (+ 2)
% Row 7
\SetRowColor{white}
\seqsplit{=MAX(C27:C34)} & Calculates the largest number in a range \tn 
% Row Count 17 (+ 2)
% Row 8
\SetRowColor{LightBackground}
\seqsplit{=SMALL(B1:B7},2) & Calculates the second smallest number in a range \tn 
% Row Count 19 (+ 2)
% Row 9
\SetRowColor{white}
\seqsplit{=LARGE(G13:D7},3) & Calculates the third largest number in a range \tn 
% Row Count 21 (+ 2)
% Row 10
\SetRowColor{LightBackground}
=POWER(9,2) & Calculates nine squared \tn 
% Row Count 22 (+ 1)
% Row 11
\SetRowColor{white}
=9\textasciicircum{}3 & Calculates nine cubed \tn 
% Row Count 23 (+ 1)
% Row 12
\SetRowColor{LightBackground}
=FACT(A1) & Factorial of value in A1 \tn 
% Row Count 24 (+ 1)
% Row 13
\SetRowColor{white}
=EVEN & Rounds a number up to the nearest even integer \tn 
% Row Count 26 (+ 2)
% Row 14
\SetRowColor{LightBackground}
=ODD & Rounds a number up to the nearest odd integer \tn 
% Row Count 28 (+ 2)
% Row 15
\SetRowColor{white}
=AVERAGE & Calculates the average \tn 
% Row Count 29 (+ 1)
% Row 16
\SetRowColor{LightBackground}
=MEDIAN & Calculates the median \tn 
% Row Count 30 (+ 1)
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{5.377cm}{x{1.44333 cm} x{3.53367 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Mathematics (cont)}}  \tn
% Row 17
\SetRowColor{LightBackground}
=SQRT & Calculates the square root of a number \tn 
% Row Count 2 (+ 2)
% Row 18
\SetRowColor{white}
=PI & Shows the value of pi \tn 
% Row Count 3 (+ 1)
% Row 19
\SetRowColor{LightBackground}
=POWER & Calculates the result of a number raised to a power \tn 
% Row Count 5 (+ 2)
% Row 20
\SetRowColor{white}
=RAND & Returns a random number between 0 and 10 \tn 
% Row Count 7 (+ 2)
% Row 21
\SetRowColor{LightBackground}
\seqsplit{=RANDBETWEEN} & Returns a random number between the numbers you specify \tn 
% Row Count 9 (+ 2)
% Row 22
\SetRowColor{white}
=COS & Calculates the cosine of a number \tn 
% Row Count 11 (+ 2)
% Row 23
\SetRowColor{LightBackground}
=SIN & Calculates the sine of the given angle \tn 
% Row Count 13 (+ 2)
% Row 24
\SetRowColor{white}
=TAN & Calculates the tangent of a number \tn 
% Row Count 15 (+ 2)
% Row 25
\SetRowColor{LightBackground}
=CORREL & Calculates the correlation coefficient between two data sets \tn 
% Row Count 18 (+ 3)
% Row 26
\SetRowColor{white}
=STDEVA & Estimates standard deviation based on a sample \tn 
% Row Count 20 (+ 2)
% Row 27
\SetRowColor{LightBackground}
=PROB & Returns the probability that values in a range are between two limits \tn 
% Row Count 23 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


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

\end{document}