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

yup, dats it

Box

ExcelBadge2boi.xlsx | Powered by Box

dwharker Almost 3 years ago

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

Box

Excel Badge 2.xlsx | Powered by Box

brennanmann1 Almost 3 years ago

You best be referring

Box

Desk Services Referral Tool.xlsx | Powered by Box

18lmartin Almost 3 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 Almost 4 years ago

Met with Kimby today at 1:30pm

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

tyler-romney Almost 4 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 Almost 4 years ago

Excel 2 screencast

Box

Box

karleepyne About 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 About 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 Over 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 Over 4 years ago

Here's my excel 2 project!

Box

Box

emma1500 Over 4 years ago