Excel Weekly Challenge
Offered By: LinkedIn Learning
Course Description
Overview
Build your Excel skills, one week at a time. Accept a new challenge every Friday to learn and practice Excel.
Syllabus
New This Week
- Graph the population
- Sharpen your Excel skills with hands-on practice
- Add new participants to teams
- Format the cells in a form
- Align and adjust text on an order form
- Get a count of possible venues
- Identify and move attendee data
- Combine first and last names
- Clean up bizarre formatting
- Fill in categories and sort
- Add a new list and line it up
- Sort addresses by region
- Help find our perfect home
- Excel in real life: House shopping
- Prepare this report to be printed
- List and inspect survey results
- Create table of course summaries
- Correct city names
- Fix the pricing formula
- Fill in pick list details
- Create a chart of monthly complaints
- Calculate pay based on hours and location
- Review accuracy of invoice
- Combine three donation lists into one
- Group and sort inventory items
- The expense report is wrong
- Categorize the status of each apartment
- Excel in real life: Auditing inventory
- Leading zeroes
- Sort and stack
- Fix dates
- Add a shape
- Combo chart with secondary axis
- Horizontal sort
- Set up and format a workbook
- Count addresses
- Fix IDs
- Protect and validate
- Identify at least five problems with this data
- Hide zeroes
- Correct these calculations
- What is this formula doing?
- Pricing grid and drop-down list
- Write a formula trigger
- Merge and compare lists
- Recreate this graphic
- Insert a happy or sad face
- Conditional formatting and sorting icons
- Crop and print
- Quick access and theme
- Update graphs
- Insert a PivotTable
- Delete transactions and insert a PivotTable
- Close holes in a list
- QAT and pivot table
- Unpivot and split columns
- Presentations part 1: Randomize
- Presentations part 2: What day is each person presenting?
- Calculate team fees
- Lookup and correct errors
- Calculate final cost and set data validation
- Clear excess images
- Format workbook defaults
- Extract all Saturdays
- Copy to a new workbook and save as a PDF
- Insert a PivotTable and slicers to review workshop data
- Use Find and Replace to correct names
- Isolate addresses
- Payment errors, part 1
- Payment errors, part 2
- Change chart type and create summary
- Create drop-down lists
- Explain this sales formula
- Using COUNTIFS with wildcards
- Create an index column
- Create tables and eliminate hyperlinks
- List the top seven donation amounts
- Get data ready for a PivotTable
- Modify a PivotTable
- Find a Power Query result
- Create a dynamic drop-down list
- Filter venues with dynamic arrays
- Find and restore missing data
- Override names
- Answer four questions about data
- Protect calculations with a shape
- Working with inventory percentages
- Replace highlights with conditional formatting
- Replace "Al" with "Alyssa"
- Apply a spin button
- Create a custom message in data validation
- Change the parameters of a data validation
- Identify multiple shifts
- Apply conditional formatting icons
- View a worksheet through two windows
- Correct dates to show the weekday, day, month, and year
- Remove the background from an image
- Calculate reimbursements based on a maximum per day
- Sort this data
- Apply formulas to new data
- Clear the formatting in a range of cells
- Transpose data and paste formula
- Find three ways to extract the item ID
- Write a formula from nothing and create your own data
- Isolate data by the week
- TJ's arts and crafts: How can we improve this workbook?
- Explain this crazy formula and test it
- Please fix this PivotTable
- How many paid days off are available?
- Count flights in a matrix
- Adjust layout
- Sum the salmon dishes
- Event planning formula
- What's the deal with these payroll calculations?
- Format grid
- Apply two conditional formatting rules
- Tally the number of guests for a party
- Set the footers for printing worksheets
- Who failed one exam or the other, but not both?
- Apply slicers and filter dataset
- Check the quality of survey responses
- Extract names from a dataset
- Change icon colors
- Create a chart and adjust the axis
- Extract sales data
- Create an order form
- Correct and format dates
- Curriculum audit: Accept reasonable dates
- Create a running total
- Convert liquids
- Office expenses and relationships
- IF AND OR: Identify records of interest
- Use conditional formatting to identify top and bottom values
- Calculate team records and break ties
- Assign random topics to our students
- Insert and format shapes
- Too hot or too cold
- Several lines: Just one cell
- Distribute the sales data
- Who's unique in this list?
- Repeat a pattern
- Who's on all three lists?
- Show me how to make a drop-down list
- Goals vs. actuals
- Calculate deadlines
- Conditional formatting icons
- Unpivot expenses
- Too many characters: Count characters in a cell
- Filter project data
- Sorting up, down, left, and right
- How many days are we open?
- Clean up this song list
- Sorting this column isn't working–what's wrong?
- What's going up and what's going down?
- Prep data for a pivot table
- Retrieve prices
- Clean and sort this song list
- Highlight southwest
- Create a drop-down list from table headers
- Summarize your progress
- Troubleshoot settings for printing
- Identify and correct completion dates
- Append these three datasets
- Filter with Excel's dynamic arrays
- Find two ways to combine these cells
- Who gets paid this month, and who doesn't?
- Build a sentence with variable inputs
- Correct the behavior of these spin buttons
- Identify and isolate distinct entries
- Isolate values and build a chart
- What's wrong with my XLOOKUP?
- Excel Slicers: Insert, format, select
- After ten rounds, which is the winning team?
- How much more can Kate advance?
- Assign email addresses and check for duplicates
- Identify five problems with this spreadsheet
- Write a sentence with dynamic values
- Print the entire sheet and its charts
- What's the revenue based on revenue share?
- Drop-down lists: Chairs and prices
- PivotTable training
- Write a formula trigger to control calculations
- Identify multipart last names
- Format times and calculate pay
- Area chart: Up vs. down?
- Create a PivotTable for juniors and seniors
- Clean the source data and fix the PivotTable
- Use the Picture Format tools to improve an image
- Split string of IDs
- Clean data to correct the PivotTable
- Animated color-change emoji
- Find the missing item numbers
- Filter for the car
- Spell out and sort the months
- Use three methods to identify and count empty cells
- Relative cell references and pricing
- Change the gridlines
- Modify this two-way lookup formula to fit your data
- PJ's 10-mile run
- Calculate the commissions based on increments of $100
- Correct this XLOOKUP
- Count and sort the airport codes
- Change the conditional formatting
- Calculate your out-of-pocket expense
- Highlight the odd-numbered rooms
- Make assignments based on the last name
- Sort names in Power Query
- Identify the non-donors
- Sort so the strikethrough values are on the bottom
- Simplify the IF formula and create a lookup table
- Total the emoji scores
- Delete unneeded rows
- Identify entries with specific day and time
- Attendance matrix
- Measure the response rate
- Sort city dates
- Attendance queries
- Decrypt the words
- How much for the beach rental?
- Get data from image
- Quickly answer these questions
- Flag and delete records
- Delete rows and split text
- Tally the project cost
- Accept ID or confirmation number
- Generate random codes
- Count the L names
- Correct double column headers
- Quiz!
- Calculate total loss
- Calculate the percent change
- How many penalties can be accrued?
- Build your own Pivot Table
- Sort data by last name
- List all available colors
- Build a Venn diagram
- Build an Event Calculator
- Sum the total loss
- Find the missing numbers
- Bring contents into a single cell
- Recycle a query to use on a different dataset
- Paydays that fall on a weekend or holiday
- Apply slicers to a review class schedule
- Build a bar chart for program attendance
- How many boxes can fit on this shelf?
- Stack names with rows in between
- Create a trivia night calendar
- Tally top scores
- Include filepath on print out
- Add a picture in a PivotTable
- Indent cells
- Change cell borders
- Create a logo and save it
- Convert performer roster
- Randomize three ways
- Teach me XLOOKUP
- Attendance of Mavis and Benedict
- Book club attendance count
- Create a 12x10 block of numbers with no duplicates
- Identify the top five and bottom five values
- Sort by shift
- Set print layout
- I know the day but need the year
- Filtering vehicles
- Sort pairs of columns
- Find trends using sparklines
- Flip the zone
- Highlight every third cell
- Explain the query
- Modify the query
- List the cheeses
- Schedule the meetings
- Append three datasets
- Filter by three criteria
- Convert range to table references
- Control and identify worksheet entries
- Flip this dataset
- Build a table
- Sort by last name
- Payment tracking
- Home scores
Taught by
Oz du Soleil
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX