Duration: 2Months
Class Schedule: 3 classes per week, 2 hours per
class
Course Overview:
This
course is designed to help learners master the essential skills needed to
perform data analysis using Microsoft Excel, one of the most versatile and
widely used tools in the business world. The course covers the complete
spectrum of Excel-based data analysis, from foundational functions to advanced
techniques such as pivot tables, data visualization, and statistical analysis.
With
hands-on exercises and real-world case studies, learners will gain the ability
to organize, analyze, and interpret data efficiently. By the end of the course,
they will be equipped with the skills to make data-driven decisions
confidently.
How
This Course Will Help Learners
1.
Develop
Core Data Analysis Skills: Learn
to use Excel's robust features for analyzing data accurately and efficiently.
2.
Enhance
Career Opportunities: Excel
proficiency is a critical skill for roles in business, finance, marketing, and
beyond.
3.
Streamline
Workflows: Master Excel’s
automation features, such as formulas and macros, to save time and reduce
manual effort.
4.
Improve
Decision-Making: Gain the
ability to extract meaningful insights from data, enabling better strategic
decisions.
5.
Real-World
Application: Practical projects
and assignments will prepare learners to tackle real-life business problems
confidently.
Learning
Objectives
By
the end of this course, learners will:
Foundational Excel Skills
1.
Understand the
Excel interface and basic functionalities.
2.
Perform data
entry, formatting, and manipulation effectively.
3.
Use essential
formulas and functions, such as SUM, AVERAGE, IF, VLOOKUP, and HLOOKUP.
Data
Organization and Cleaning
1.
Organize datasets
using sorting, filtering, and grouping techniques.
2.
Use text and data
functions to clean and preprocess raw data.
3.
Apply conditional
formatting to highlight key trends and anomalies.
Data
Analysis Techniques
1.
Use PivotTables
and PivotCharts for dynamic data summarization.
2.
Perform
statistical analysis with functions like AVERAGEIF, COUNTIF, and STDEV.
3.
Analyze trends
and forecast outcomes using Excel’s built-in tools, such as Trendlines and
What-If Analysis.
Data
Visualization
1.
Create
professional charts and graphs, including bar charts, scatter plots, and line
graphs.
2.
Design
interactive dashboards using slicers and form controls.
3.
Customize
visualizations for clear and impactful data storytelling.
Advanced
Excel Features
1.
Use advanced
formulas, such as INDEX, MATCH, and nested functions, for complex data
analysis.
2.
Automate
repetitive tasks using Excel Macros and VBA scripting basics.
3.
Connect Excel
with external data sources for real-time analysis.
<div class="WordSection1"><p class="MsoNormal" style="margin: 0in 0in 0.0001pt; text-indent: 0in; line-height: normal;"><span style="font-weight: bolder;"><span style="font-size: 14pt; font-family: Calibri, sans-serif; color: rgb(112, 48, 160);"> </span></span></p><p class="MsoNormal" style="margin: 0in 0in 0.0001pt; text-indent: 0in; line-height: normal;"><span style="font-weight: bolder;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><font color="#000000">BEGINNERS’ LEVEL</font></span><span style="font-size: 14pt; font-family: Calibri, sans-serif; color: rgb(112, 48, 160);"> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></p><h1 style="margin: 0in 0in 0.0001pt; line-height: normal; text-indent: 0in;"><span style="font-weight: bolder;"><font color="#000000"><i><span style="font-size: 14pt; font-family: Calibri, sans-serif;">WEEK 1:</span></i><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></font></span></h1><p class="MsoNormal" style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-weight: bolder;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><font color="#000000">EXCEL FOUNDATIONAL CONCEPTS </font></span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Excel shortcuts <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">The use of keyboard for frequent commands<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Customizing the Quick Access Toolbar<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Using the Auto Fill tool to fill cells with data<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Using smart tags to complete common task<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Copy and paste content using the clipboard</span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><br></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-weight: bolder;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><font color="#000000">CREATING AND EDITING WORKBOOKS</font></span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Create, open and save Excel files quickly <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Add text, numbers, dates and times <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Move, copy and delete data <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Navigate with mouse and keyboard <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Move, copy, insert, delete and rename worksheets <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Insert and delete columns and rows <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Change the layout of a spreadsheet</span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><br></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-weight: bolder;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><font color="#000000">FORMATTING CONTENT </font></span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Clearly structure and present worksheet content<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">User various tools to format text<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Change number formats<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Align text and numbers<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Modify the size of rows and columns<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Apply borders for clarity<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Hide gridlines on a worksheet<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Merge multiple cells into one cell<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Wrap text within a cell<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Apply styles to cells for quick formatting<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the Format Painter tools for speed and consistency in appearance<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Clear formatting and tidy up content <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Check the spelling of text<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><i style="color: inherit; font-family: inherit; font-size: 2.5rem; text-indent: 0in;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><br></span></i></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><i style="color: inherit; font-family: inherit; font-size: 2.5rem; text-indent: 0in;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">WEEK 2:</span></span></i></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="color: inherit; font-family: Calibri, sans-serif; font-size: 14pt; text-indent: 0in;"><span style="font-weight: bolder;">WRITING AND EDITING FORMULAS</span></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Write formulas to add, subtract, multiply and divide <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Add and edit formulas within the formula bar <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Copy a formula to other cells<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">View results of calculations in the status bar<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use brackets to change the order of a calculation<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h1 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">OVERVIEW OF FUNCTIONS</span><o:p></o:p></span></h1><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Write Common functions such as SUM <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the AutoSum tool <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Add new figures and ensure functions remain correct <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Copy a function to other cells <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Work with the tools in the formulas tab <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the insert function tool to find and build functions <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use AutoComplete to add functions <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the PRODUCT and SUMPRODUCT<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 54.5pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;">functions <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 54.5pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h1 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">BASIC STATISTICAL FUNCTIONS</span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif; color: black;"></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></h1><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Using the MAX and MIN functions to display the highest and lowest figures <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use functions to calculate the average, median or mode figure<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 0in; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> <o:p></o:p></span></p><h1 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;"><font color="#000000">INTERMEDIATE LEVEL</font></span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></h1><h1 style="margin: 0in 0in 0.0001pt; line-height: normal; text-indent: 0in;"><i><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">WEEK 3:</span></span></i><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></h1><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">LOGICAL FUNCTIONS</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the IF function to ask questions of data and display <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">information<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the IF function to analyze data and perform calculations<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Nest multiple IF functions within the same formula<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Combine IF with the AND function<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Combine IF with the OR function<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">LOOKUP FUNCTIONS</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the VLOOKUP function to search for and find data <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Edit a VLOOKUP function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the MATCH function to search for data <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">User the INDEX function to return values <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Combine the MATCH and INDEX functions <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the HLOOKUP function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">COUNT FUNCTIONS</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the COUNT function<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the COUNTA function<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the COUNTBLANK function</span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 0in 0.0001pt; text-indent: 0in; line-height: normal;"><span style="font-weight: bolder;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span><i style="text-indent: 0in; color: inherit; font-family: inherit; font-size: 2.5rem;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;">WEEK 4:</span></i></span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">ROUNDING UP AND DOWN FUNCTIONS</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the ROUND function<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the ROUNDUP function<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the ROUNDDOWN function<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">IS FUNCTIONS TO TEST DATA</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Using the ISBLANK function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the ISERROR function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the ISNUMBER function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the ISTEXT function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">SORT AND FILTER DATA</span> <o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Sort records into alphabetical or numerical<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Sort records by date<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Sort records by color<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use drop down filters to find specific records<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Create customized filters to find records that meet criteria<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt; line-height: normal; text-indent: 0in;"><span style="font-weight: bolder;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span><span style="color: inherit; font-family: Calibri, sans-serif; font-size: 14pt; text-indent: 0in;">TABLES OF DATA </span></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Convert a range of cells into a Table to simplify analysis</span><span style="font-family: Calibri, sans-serif; font-size: 14pt; text-indent: 0in;"> </span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Add new fields to a Table <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Add new records to a Table<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Add calculated fields to a Table<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">CREATING AND EDITING CHARTS</span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif; color: black;"></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Create column, line, pie, area, scatter and radar chars <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Change the chart type <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the quick layout options <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Draw attention to chart content with<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 54.5pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Effective formatting <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Apply styles to charts/Add trendlines to charts <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 0in 0.0001pt 0.75in; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> <o:p></o:p></span></p><h1 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-weight: bolder;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><font color="#000000">ADVANCED LEVEL </font></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></span></h1><h1 style="margin: 0in 0in 0.0001pt; line-height: normal; text-indent: 0in;"><i><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">WEEK 5:</span></span></i><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></h1><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">ADVANCED DATA FILTERS</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Filter data using the advanced filter<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Copy filtered data to other cells <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Filter data to display unique records<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use Table tools to perform calculations <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Name Tables of data and work with dynamic named ranges<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use functions to analyze data within a Table<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">INTRODUCTION TO PIVOT TABLES</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Create PivotTables <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Change the layout of PivotTables <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Sort data vertically and horizontally <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Filter data within a PivotTable <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Search for data within a PivotTable <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Customize field names <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Format data displayed within Pivot Tables <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Drill down to display data & Create Pivot Charts <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">ADVANCED PIVOT TABLE SKILLS</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Set PivotTable options <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Change the calculations performed <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Work with subtotals within a PivotTable <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Create top 10 reports </span><span style="font-family: Calibri, sans-serif; font-size: 14pt; text-indent: 0in;"> </span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Group data into date periods <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Group data into number ranges <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Display values as percentages of total figures <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Group data into number ranges <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Display values as percentages of total figures <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Create running totals <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Create calculated fields <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use slicers to filter multiple PivotTables <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Apply conditional formatting to data within<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 54.5pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;">PivotTables <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use formulas to extract data from<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 54.5pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;">PivotTables<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 54.5pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h1 style="margin: 0in 0in 0.0001pt; line-height: normal; text-indent: 0in;"><i><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">WEEK 6:</span></span></i><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><o:p></o:p></span></h1><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">DATA VALIDATION</span> <o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Set validation rules to specify what type of data can be entered <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Create drop down lists for data entry <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Connect drop down lists to data within a spreadsheet <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use input messages to help users enter correct data <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Display error alerts when invalid data is entered <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: 0in; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span></p><h2 style="margin: 0in 0in 0.0001pt -0.25pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">DATABASE FUNCTIONS</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the DSUM function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the DCOUNT function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Use the SUBTOTAL function <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 36.5pt; line-height: normal;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"> </span><span style="font-family: Calibri, sans-serif; font-size: 14pt;"> </span></p><h2 style="margin: 0in 0in 0.0001pt; line-height: normal; text-indent: 0in;"><span style="font-size: 14pt; font-family: Calibri, sans-serif;"><span style="font-weight: bolder;">LINKING DATA BETWEEN SHEETS AND FILES</span><o:p></o:p></span></h2><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Link one cell to another <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Link data across sheets in the same Excel workbook <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Link data across two Excel files <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Update and manage linked data <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">PROTECTING AND HIDING DATA<o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Hide rows and columns <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Hide worksheets </span><span style="font-family: Calibri, sans-serif; font-size: 14pt; text-indent: 0in;"> </span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Protect formulas within cells <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Password protect worksheets and workbooks <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Protect ranges of cells <o:p></o:p></span></p><p class="MsoNormal" style="margin: 0in 33.5pt 0.0001pt 53.25pt; text-indent: -0.25in; line-height: normal;"><span style="font-size: 9.5pt; font-family: Verdana, sans-serif;">•<span style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: " times="" new="" roman";"=""> </span></span><span style="font-size: 14pt; font-family: Calibri, sans-serif;">Copying and pasting hidden data<o:p></o:p></span></p></div><span style="font-size: 14pt; font-family: Calibri, sans-serif; color: black;"><br clear="all" style="break-before: page;"></span><p class="MsoNormal" style="margin: 0in 0in 8pt; text-indent: 0in; line-height: 17.12px;"><span style="font-size: 14pt; line-height: 19.9733px; font-family: Calibri, sans-serif;"> </span></p>