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

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

here we are

Box

mckayfritz About 5 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 5 years ago

yeet

Google

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.