Microsoft Excel - 2/3

1. Complete a Project

Only editable by group admins

Last updated August 6, 2024 at 3:19 PM by byustl
Evidence visible to public

Create a project demonstrating your ability to use all of the tools listed below. Provide a brief explanation of your project and post a link to the file.

Demonstrate skill with:

Know how to import data from a text file
Know how to create and manipulate tables

Format as table
Themes
Sorting and Multilevel sorting
Filtering
Slicers

Pivot Tables

Know how to use them and why they're useful

Conditional formatting

Presets, custom rules

Basics of Power Query Editor

What is it and why we use it

SUMIF function
AVERAGEIF function
COUNT and COUNTIF functions
IFS function
INDEX and MATCH functions
Know how to create charts

Know the different chart elements and what they do
Switch x and y axis
Scatterplots
Pie charts

Know how to set up for printing

Page Breaks
Print Titles

Know how to use different viewing options

Freeze Panes
Split Screen

Paste Special

All posted evidence

Here is my screencast of the skills!

Box

kimbyj Almost 5 years ago

Here is my Excel 2 Project!

Google Docs

Excel 2 Badge.xlsx

katem88 About 5 years ago

Here's my excel project! I'll go over it with Derek during the shift where we work at the same time on Thursday.

Google

Google Sheets - create and edit spreadsheets online, for free.

Create a new spreadsheet and edit with others at the same time -- from your computer, phone or tablet. Get stuff done with or without an internet connection. Use Sheets to edit Excel files. Free from Google.

jessiesuchomel Over 5 years ago

Spencer's EXCEL 2

Google Docs

EXCEL BADGE 2 with Class Files.xlsx

spencerlcannon Over 5 years ago

level 2 files

Box

rebeccaleifer Over 5 years ago

screen recording of me going through the requirements

Box

Box | Login

Brigham Young University uses your network username and password to login to Box. Continue to login to Box through your network.

alainmelchor Almost 6 years ago

Excel badge 2

Box

Box | Login

Brigham Young University uses your network username and password to login to Box. Continue to login to Box through your network.

derek5h Almost 6 years ago

here we are

Box

mckayfritz About 6 years ago

Unlisted screencast of using most of the tools.

YouTube

RK Excel 2 Video 1

Screencast for Excel 2 using most of the tools.

rkitchen2 Over 6 years ago

yeet

Google

excel 2 - Google Drive

juliacstark Almost 7 years ago

I went over everything with Aaron

Trello

Organize anything, together. Trello is a collaboration tool that organizes your projects into boards. In one glance, know what's being worked on, who's working on what, and where something is in a process.

reese About 7 years ago

Excel spreadsheet that has all of the requirements in it.

https://drive.google.com/open?id=1kVMBowLcnZl2FprhB9d_UpnVR_rLNBMY

sbirdsall About 7 years ago