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

https://byu.box.com/s/c5kew3mb8jdrm7urtmckuauji3r1m7b4

Box

Excel Badge 2.xlsx | Powered by Box

brennanmann1 Over 2 years ago

You best be referring

Box

Desk Services Referral Tool.xlsx | Powered by Box

18lmartin Over 2 years ago

Screencast I sent to Kimby!

Box

Excel 2.mp4 | Powered by Box

gracea03 Over 3 years ago

Kimby passed off

Box

Basketball Analytics.xlsx | Powered by Box

jed-roundy Over 3 years ago

Met with Kimby today at 1:30pm

https://app.box.com/s/d49aoozhvk6iq91ckuogyywo4v0icwoc

tyler-romney Over 3 years ago

You can see the file in the preview but it doesn't load when you click on it... idk why, sorry! Kimby passed off on 9/15/2022

Box

Box

brooketti Over 3 years ago

Excel 2 screencast

Box

Box

karleepyne Almost 4 years ago

Kimby passed me off!

Box

Box | Login

Brigham Young University uses your network credentials to login to Box. Continue to login to Box through your network. If you are not a part of Brigham Young University, continue to log in with your Box.com account.
g3nius Almost 4 years ago

excel 2 screencast

Zoom Video Communications

Video Conferencing, Web Conferencing, Webinars, Screen Sharing

Zoom is the leader in modern enterprise video communications, with an easy, reliable cloud platform for video and audio conferencing, chat, and webinars across mobile, desktop, and room systems. Zoom Rooms is the original software-based conference room solution used around the world in board, conference, huddle, and training rooms, as well as executive offices and classrooms. Founded in 2011, Zoom helps businesses and organizations bring their teams together in a frictionless environment to get more done.
addiehop About 4 years ago

Civ 6 Leaders info

Box

Box | Login

Brigham Young University uses your network credentials to login to Box. Continue to login to Box through your network. If you are not a part of Brigham Young University, continue to log in with your Box.com account.
nathanwjcannon About 4 years ago

Here's my excel 2 project!

Box

Box

emma1500 Over 4 years ago

The files I used to learn badge 2

Google Docs

Excel Badge 2

Sales1 Employee Name,First Name,Last Name,Position,Phone #,BYU ID,SSN,Qtr1,Qtr2,Qtr3,Qtr4 Bill MacArthur,Bill,MacArthur,Marketing,(801) 223-4561,21-111-1112,211-11-1112,6354,4846,3958,8284 Shannon Lee,Shannon,Lee,Sales,(801) 456-4512,12-212-2328,122-12-2328,8484,5858,5858,4555 Melinda McGregor,M...
savfill Almost 5 years ago