Build your Excel skills, one week at a time. Accept a new challenge every Friday to learn and practice Excel.
Overview
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
