- Level: Beginner
- Duration: 05h 21m
- Release date: 2018-10-05
- Author: Oz du Soleil
- Provider: Lynda
Excel Weekly Challenge
There are countless books and courses that teach Microsoft Excel. However, true mastery requires practice. You have to apply what you've learned in order to make it stick. This series, with Excel MVP Oz du Soleil, provides weekly Excel challenges taken from Oz's experience helping clients with real-world problems. Each video begins with a challenge, such as inconsistent cell formatting, duplicate line items, or incomplete data. Pause the video and download the related exercise file to work out your own solution using the powerful features built into Excel. When you're ready, you can restart the video to see how Oz solves the challenge. In just a few minutes a week, you can learn the most popular and useful Excel formulas, functions, and features. Tune in every Friday for a new technique.Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
- New This Week03m 30s
- Apply two conditional formatting rules03m 30s
- Introduction01m 38s
- Sharpen your Excel skills with hands-on practice01m 38s
- Excel Challenges05h 16m 41s
- Add new participants to teams02m 21s
- Format the cells in a form01m 24s
- Align and adjust text on an order form01m 24s
- Get a count of possible venues02m 01s
- Identify and move attendee data03m 20s
- Combine first and last names02m
- Clean up bizarre formatting02m
- Fill in categories and sort02m 03s
- Add a new list and line it up02m 06s
- Sort addresses by region01m 28s
- Help find our perfect home02m 21s
- Excel in real life: House shopping05m 39s
- Prepare this report to be printed02m 01s
- List and inspect survey results02m 18s
- Create table of course summaries01m 51s
- Correct city names01m 04s
- Fix the pricing formula01m 48s
- Fill in pick list details03m 40s
- Create a chart of monthly complaints01m 28s
- Calculate pay based on hours and location03m 21s
- Review accuracy of invoice02m 12s
- Combine three donation lists into one04m 30s
- Group and sort inventory items02m 16s
- The expense report is wrong02m 18s
- Categorize the status of each apartment03m
- Excel in real life: Auditing inventory04m 37s
- Leading zeroes01m 51s
- Sort and stack02m 35s
- Fix dates02m 57s
- Add a shape02m 59s
- Combo chart with secondary axis01m 48s
- Horizontal sort02m 34s
- Set up and format a workbook03m 17s
- Count addresses02m 51s
- Fix IDs03m 25s
- Protect and validate03m 47s
- Find duplicates03m 51s
- Hide zeroes02m
- Correct these calculations03m 19s
- What is this formula doing?02m 39s
- Pricing grid and drop-down list03m 42s
- Write a formula trigger03m 14s
- Merge and compare lists03m 24s
- Recreate this graphic05m 05s
- Insert a happy or sad face03m
- Conditional formatting and sorting icons02m 35s
- Crop and print01m 53s
- Quick access and theme02m 08s
- Update graphs03m 26s
- Insert a PivotTable02m 26s
- Delete transactions and insert a PivotTable02m 58s
- Close holes in a list01m 02s
- QAT and pivot table02m 54s
- Unpivot and split columns02m 19s
- Presentations part 1: Randomize04m 05s
- Presentations part 2: What day is each person presenting?02m 49s
- Calculate team fees03m 02s
- Lookup and correct errors02m 47s
- Calculate final cost and set data validation05m 32s
- Clear excess images01m 51s
- Format workbook defaults01m 11s
- Extract all Saturdays02m 52s
- Copy to a new workbook and save as a PDF02m 01s
- Insert a PivotTable and slicers to review workshop data03m 23s
- Use Find and Replace to correct names01m 35s
- Isolate addresses04m 37s
- Payment errors, part 101m 39s
- Payment errors, part 204m 32s
- Change chart type and create summary03m 33s
- Create drop-down lists02m 59s
- Explain this sales formula03m 50s
- Using COUNTIFS with wildcards01m 42s
- Create an index column01m 32s
- Create tables and eliminate hyperlinks02m 17s
- List the top seven donation amounts01m 45s
- Get data ready for a PivotTable03m 05s
- Modify a PivotTable02m 35s
- Find a Power Query result01m 19s
- Create a dynamic drop-down list03m 34s
- Filter venues with dynamic arrays02m 25s
- Find and restore missing data03m 08s
- Override names01m 57s
- Answer four questions about data02m 54s
- Protect calculations with a shape04m 32s
- Working with inventory percentages01m 32s
- Replace highlights with conditional formatting03m 42s
- Replace "Al" with "Alyssa"02m 51s
- Apply a spin button03m 24s
- Create a custom message in data validation02m 11s
- Change the parameters of a data validation03m 11s
- Identify multiple shifts02m 43s
- Apply conditional formatting icons02m 21s
- View a worksheet through two windows02m 30s
- Correct dates to show the weekday, day, month, and year01m 49s
- Remove the background from an image02m 35s
- Calculate reimbursements based on a maximum per day04m 02s
- Sort this data01m 56s
- Apply formulas to new data02m 30s
- Clear the formatting in a range of cells01m 46s
- Transpose data and paste formula02m 03s
- Find three ways to extract the item ID03m 11s
- Write a formula from nothing and create your own data02m 42s
- Isolate data by the week03m 23s
- TJ's arts and crafts: How can we improve this workbook?04m 04s
- Explain this crazy formula and test it05m 18s
- Please fix this PivotTable03m 26s
- How many paid days off are available?03m 22s
- Count flights in a matrix03m 36s
- Adjust layout02m 37s
- Sum the salmon dishes02m 05s
- Event planning formula04m 08s
- What's the deal with these payroll calculations?04m 47s
- Format grid03m 23s
- Developing Mobile-specific Features with Flutter
- Excel Advanced - Pivot Tables, Tables, Graphs
- Spring Framework: Spring Data JPA with Hibernate
- Facebook's technical interview kit level 1
- Getting Started with Pulumi
- Complete C# Unity Game Developer 2D
- Design Principles for Serving Layer in Microsoft Azure
- The Solution Focused Toolkit
- Creating Basic Robots with Robotic Process Automation
- 1Z0-1088-21 || Oracle Cloud Infrastructure 2021 Enterprise
- Ember.js: The Documentary
- GraphQL: The Documentary
- AWS Certified Solutions Architect - Professional (SAP-C01) Cert Prep: 1 Design for Organizational Complexity
- CCSP Cert Prep: 4 Cloud Application Security
- What Business Leaders Need to Know about Web3 (+ Metaverse)
- Building No-Code Apps with AppSheet: Implementation
- Automation Anywhere: The Big Picture
- Protective Technology with Apache Kafka
- Coding for Visual Learners: Learning JavaScript from Scratch
- StringBuilder Internals