\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{mdsis2049} \pdfinfo{ /Title (intermediate-spreadsheet-skills.pdf) /Creator (Cheatography) /Author (mdsis2049) /Subject (Intermediate Spreadsheet Skills 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{Intermediate Spreadsheet Skills Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{mdsis2049} via \textcolor{DarkBackground}{\uline{cheatography.com/193569/cs/41419/}}} \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}mdsis2049 \\ \uline{cheatography.com/mdsis2049} \\ \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 25th November, 2023.\\ 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}{What is a Spreadsheet?}} \tn \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{A {\bf{spreadsheet}} is software that helps to organize, calculate and display data. Spreadsheets are especially useful for keeping track of {\emph{numeric data}}—data in the form of numbers. You could use spreadsheets to record how much money goes into and out of bank accounts (accounting), to display statistics for games and sports, to do scientific research, and much more!% Row Count 8 (+ 8) } \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{x{2.64 cm} x{5.36 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Important skills}} \tn % Row 0 \SetRowColor{LightBackground} {\bf{Sorting data}} & Displaying data in a certain order, i.e. from the largest number to the smallest. \tn % Row Count 4 (+ 4) % Row 1 \SetRowColor{white} {\bf{Filtering data}} & Deciding which data is displayed based on some criteria. \tn % Row Count 7 (+ 3) % Row 2 \SetRowColor{LightBackground} {\bf{Creating charts}} & Making visual aids that explain data, e.g. pie charts, bar charts, line charts... \tn % Row Count 11 (+ 4) % Row 3 \SetRowColor{white} {\bf{Writing formulas}} & Using math and special functions to combine the contents of cells in different ways. \tn % Row Count 15 (+ 4) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Example: Sorting and filtering data in Excel}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{p{8.4cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/mdsis2049_1700833902_sortingdata1.png}}} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{Once you have selected the data that you want to sort or filter, you may click on the {\bf{Sort \& Filter}} button in Excel's {\bf{Home}} ribbon. \newline \newline Image Source: \{\{link="https://courses.lumenlearning.com/wm-compapp/chapter/sorting-data/"\}\}Sort Data\{\{/link\}\}. Authored by: Shelli Carter. Provided by: Lumen Learning. License: CC BY: Attribution} \tn \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}{Sort orders}} \tn % Row 0 \SetRowColor{LightBackground} Smallest to Largest & Sorts {\emph{numbers}} (including {\emph{currency}}, etc) from the smallest to the largest. Ex: 1, 4, 8, 16. \tn % Row Count 4 (+ 4) % Row 1 \SetRowColor{white} Largest to smallest & Sorts {\emph{numbers}} (including {\emph{currency}}, etc) from the largest to the smallest. Ex: 16, 8, 4, 1. \tn % Row Count 8 (+ 4) % Row 2 \SetRowColor{LightBackground} A to Z & Sorts {\emph{letters}} from A to Z, or sorts {\emph{characters}} in increasing order by their ASCII codes. Ex: A, Ba, Bb, C. \tn % Row Count 13 (+ 5) % Row 3 \SetRowColor{white} Z to A & Sorts {\emph{letters}} from Z to A, or sorts {\emph{characters}} in decreasing order by their ASCII codes. Ex: C, Bb, Ba, A. \tn % Row Count 18 (+ 5) % Row 4 \SetRowColor{LightBackground} Oldest to Newest & Sorts {\emph{dates}} and {\emph{times}} starting from the oldest. Ex: 1906-01-01, 1976-05-05, 2013-08-08. \tn % Row Count 22 (+ 4) % Row 5 \SetRowColor{white} Newest to Oldest & Sorts {\emph{dates}} and {\emph{times}} starting from the most recent. Ex: 2013-08-08, 1976-05-05, 1906-01-01. \tn % Row Count 26 (+ 4) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Example: Choosing what to filter}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{p{8.4cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/mdsis2049_1700835319_filterdata1.png}}} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{After you turn on filtering for your data, you can click on the triangle button (\{\{fa-square-caret-down\}\} to choose what data to show and hide. When you're done, simply click "OK", and Excel will activate your filter. \newline \newline Image Source: \{\{link="https://courses.lumenlearning.com/wm-compapp/chapter/filtering-data/"\}\}Filter Data\{\{/link\}\}. Authored by: Shelli Carter. Provided by: Lumen Learning. License: CC BY: Attribution} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}