Excel Tips Weekly
With Dennis Taylor
Liked by 177,159 users
Duration: 49h 18m
Skill level: Intermediate
Released: 1/16/2015
Course details
This tips-based course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis. Tune in every Tuesday for a new tip from expert Dennis Taylor. Each tutorial is a short, self-contained lesson guaranteed to give you new insights into Excel.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skills you’ll gain
Meet the instructor
Learner reviews
4.7 out of 5
The overall rating is calculated using the average of submitted ratings. Ratings and reviews can only be submitted when non-anonymous learners complete at least 40% of the course. This helps us avoid fake reviews and spam.
-
5 star 82% -
4 star 13% -
3 star 3% -
2 star <1% -
1 star 2%
Inhalt
-
-
(Locked)
Hide and unhide worksheets securely6m 6s
-
(Locked)
Resizing, moving, copying, and manipulating charts and other objects10m 17s
-
(Locked)
Using list boxes and combo boxes to facilitate forms creation7m 36s
-
(Locked)
Using the FORMULATEXT and N functions for worksheet and formula documentation5m 53s
-
(Locked)
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells7m 55s
-
(Locked)
Summarizing data from diverse ranges with Data > Consolidate9m 33s
-
(Locked)
Using check boxes and conditional formatting together for dynamic displays5m 58s
-
(Locked)
Becoming more productive with these 10 tiny tips you'll use often8m
-
(Locked)
Transposing data and charts for a different perspective on your data8m 57s
-
(Locked)
Applying conditional formatting across rows of data6m 43s
-
(Locked)
Exploring various layouts for your PivotTable4m 27s
-
(Locked)
Splitting and consolidating workbooks6m 47s
-
(Locked)
Using date and time as metrics in a PivotTable6m 53s
-
(Locked)
Adding illustrations to your workbook12m 7s
-
(Locked)
Using a pick list, VLOOKUP, table, and chart together8m 5s
-
(Locked)
Using formulas to calculate values across worksheets and workbooks11m 12s
-
(Locked)
Dynamically presenting data via chart slicers7m 15s
-
(Locked)
Parsing your data to create unique lists3m 21s
-
(Locked)
Using the REPT function to represent data visually3m 6s
-
(Locked)
Using source data from a table to make your PivotTable more dynamic7m 8s
-
(Locked)
Accelerating Cut, Copy, Paste, and Insert tasks7m 26s
-
(Locked)
Increasing your productivity with custom lists5m 9s
-
(Locked)
Highlighting PivotTable results with conditional formatting6m 10s
-
(Locked)
Customizing templates to fit your unique needs6m 6s
-
(Locked)
Creating dynamic charts with in-cell conditional formatting3m 26s
-
(Locked)
Enhancing table filtering with slicers5m 23s
-
(Locked)
Converting charts into pictures4m 51s
-
(Locked)
Custom grouping in PivotTables4m 31s
-
(Locked)
Quick formatting tips8m 9s
-
(Locked)
The top five unknown but useful keyboard shortcuts6m 17s
-
(Locked)
Using the TREND and GROWTH functions for projecting future results5m 54s
-
(Locked)
Using scroll bars and spin buttons to facilitate forms creation10m 1s
-
(Locked)
Creating colorful 3D buttons for worksheet annotation and macro buttons6m 52s
-
(Locked)
Calculating with hours, minutes, and times of day11m 2s
-
(Locked)
Tracking down cell dependencies across multiple worksheets and workbooks6m 24s
-
(Locked)
Discovering time-saving tools in the Go To Special feature11m 22s
-
(Locked)
Using Go To Special6m 1s
-
(Locked)
Reducing data entry time by expanding AutoCorrect options6m 10s
-
(Locked)
Setting up custom views for quick access to different worksheet displays6m 30s
-
(Locked)
Using hyperlinks for rapidly switching worksheet locations and jumping to websites7m 18s
-
(Locked)
Controlling worksheet security by allowing selected users to edit specific cell ranges7m 22s
-
(Locked)
Using option buttons, group boxes, and checkboxes to facilitate forms creation8m 7s
-
(Locked)
Exploring what-if scenarios using Goal Seek9m 55s
-
(Locked)
Creating text, numerical, date, and time lists in a flash6m 54s
-
(Locked)
Creating variable conditional formatting rules8m 4s
-
(Locked)
Handling dates with unusual formats6m 5s
-
(Locked)
Ten quick tips to use daily: formulas, formatting, and accessing commands6m 32s
-
(Locked)
Using wildcards (asterisk, tilde, and question mark)11m
-
(Locked)
Custom formats using asterisk, semicolon, and brackets13m
-
(Locked)
Meeting unusual filtering needs via Advanced Filter5m 28s
-
(Locked)
Create an organization chart8m 56s
-
(Locked)
Two-way lookup using the MATCH and INDEX functions11m 28s
-
(Locked)
Using Excel error-checking functions10m 37s
-
(Locked)
Custom formats, relative addressing, and conditional formatting8m 26s
-
(Locked)
Auditing9m 1s
-
(Locked)
Adding comments and shapes7m 35s
-
(Locked)
Drawing borders and border grids5m 45s
-
(Locked)
Building a flexible monthly table using functions11m 44s
-
(Locked)
Adding pictures as worksheet backgrounds4m 15s
-
(Locked)
ADDRESS, ROW, and COLUMN functions8m 8s
-
(Locked)
Join data with new CONCAT and TEXTJOIN functions6m 15s
-
(Locked)
Working with formulas in tables13m 2s
-
(Locked)
Locating data validation rules and violations7m 20s
-
(Locked)
Creating an Excel template7m 57s
-
(Locked)
Restoring missing column titles6m 41s
-
(Locked)
Creating a pick list dependent on another pick list6m 59s
-
(Locked)
Using command shortcuts with the Alt key5m 51s
-
(Locked)
Set up a macro for sorting dynamic data8m 42s
-
(Locked)
Use random number functions for sorting and creating sample data9m 57s
-
(Locked)
Use calcuated fields and calculated items in a PivotTable8m 57s
-
(Locked)
Replace characters by position with the REPLACE function5m 46s
-
(Locked)
Work with formulas in tables9m 3s
-
(Locked)
Keystroke shortcuts from A to Z: Using the Ctrl key16m 16s
-
(Locked)
Use special tricks for working with dates in charts11m 36s
-
(Locked)
Use a data form for data entry and exploring data6m 42s
-
(Locked)
Creating an Excel template to simplify updating a monthly file7m 10s
-
(Locked)
Calculate dates efficiently using Excel's hidden function - DATEDIF7m 36s
-
(Locked)
Create dynamic sheet name references with the INDIRECT function6m 45s
-
(Locked)
Avoid errors and hidden data with the powerful AGGREGATE function7m 8s
-
(Locked)
Hide worksheets, row, columns, cells and other Excel elements7m 26s
-
(Locked)
Use slicers and charts together for dynamic presentations9m 4s
-
(Locked)
Save a chart as a template: Use the template for current or new charts6m 2s
-
(Locked)
MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions8m 12s
-
(Locked)
Adjust a chart's source data and adjust its series order9m 7s
-
(Locked)
Use the OFFSET function for tabulating moving data11m 23s
-
(Locked)
Alter numeric data without formulas10m 19s
-
(Locked)
Use Flash Fill to rapidly combine or separate columnar data10m 28s
-
(Locked)
Adjust banded-row formatting14m 35s
-
(Locked)
Change the shape of comment boxes and other objects6m 32s
-
(Locked)
How and when to use the 10 rounding functions in Excel13m 26s
-
(Locked)
Calculate faster with the AutoSum button and AutoSum keystroke shortcut6m 54s
-
(Locked)
How to use mixed cell references8m 25s
-
(Locked)
Activate the Speak On Enter and Speak Cells features5m 38s
-
(Locked)
Accelerate data entry with five special techniques12m 8s
-
(Locked)
Insert a text box or shape and link a cell's content to it6m 58s
-
(Locked)
Use Watch Window and other techniques to track changing cells8m 21s
-
(Locked)
How to create time interval entries11m 39s
-
(Locked)
How to create frequency tabulations and distributions8m 10s
-
(Locked)
Create an expanded list from a summary using PivotTable techniques7m 25s
-
(Locked)
Solve matching issues with matching phone numbers and SS numbers10m
-
(Locked)
Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative7m 27s
-
(Locked)
Use outlining tools to quickly expand and collapse data for dynamic presentations9m 19s
-
(Locked)
Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting9m 59s
-
(Locked)
Create lists of all 2nd Tuesdays, last Tuesdays. and other date series10m 44s
-
(Locked)
Create linkage formulas that refer to other worksheets and workbooks11m 49s
-
(Locked)
Formula nesting: Using multiple functions in the same formula13m 22s
-
(Locked)
Keyboard shortcuts for numeric formats8m 18s
-
(Locked)
Use the Subtotal command to analyze data with single- or multiple-level subtotals9m 15s
-
(Locked)
Work with MAX, MAXIFS, LARGE, and related functions8m 14s
-
(Locked)
Use the dynamic TODAY and NOW functions for real-time up-to-date calculations9m 24s
-
(Locked)
Use the FIND, MID, LEFT, and RIGHT functions10m 38s
-
(Locked)
Flip the left-to-right order of columns with the INDEX function or sort by columns8m 18s
-
(Locked)
Working with hidden data when copying cells and creating charts10m 58s
-
(Locked)
Use conditional formatting data bars to accentuate negative data4m 16s
-
(Locked)
Creative use of sparklines in merged cells with axes7m 1s
-
(Locked)
Copy formats quickly using dragging techniques and the Format Painter5m 25s
-
(Locked)
Displaying multiple worksheets and workbooks together10m 13s
-
(Locked)
Tips for creating and updating sample data11m 1s
-
(Locked)
Use conditional formatting to overcome formatting limitations of the IF function8m 54s
-
(Locked)
Use VLOOKUP, MATCH, and INDEX functions with array formulas10m 38s
-
(Locked)
Summarize data from different worksheets with a PivotTable7m 20s
-
(Locked)
AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas6m 59s
-
(Locked)
Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions8m 40s
-
(Locked)
Use custom formulas in data validation to keep out bad data13m 18s
-
(Locked)
Dealing with circular errors8m 20s
-
(Locked)
Tips for creating charts quickly6m 56s
-
(Locked)
Creating heat maps using conditional formatting8m 31s
-
(Locked)
Using the INDEX function to extract data by row and column11m 1s
-
(Locked)
Displaying tips when using Excel in presentations6m 23s
-
(Locked)
The Wrap Text, Merge and Center, and Indent options9m 2s
-
(Locked)
Using fill effects (gradients, patterns, styles) for colorful cell background variations5m 10s
-
(Locked)
Working with multiple worksheets simultaneously8m 42s
-
(Locked)
Exploring font choices not found on the Home tab4m 2s
-
(Locked)
Using WordArt for special titles and headings4m 33s
-
(Locked)
Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions7m 34s
-
(Locked)
Borders and gridlines: Exploring variations, options, and differences8m 24s
-
(Locked)
New Excel 2016 chart types: Tree map and sunburst7m 29s
-
(Locked)
Freezing column and row titles7m 48s
-
(Locked)
Use data validation to force entries to be uppercase or lowercase10m 48s
-
(Locked)
Avoiding common chart distortions11m 49s
-
(Locked)
Use the new funnel chart available in Excel 3654m 3s
-
(Locked)
Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character6m 1s
-
(Locked)
Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!9m 39s
-
(Locked)
Creating cross-totals with the SUMIFS function and mixed references5m 50s
-
(Locked)
New Excel 2016 chart types: Histogram, Pareto, and box, and whisker10m 8s
-
(Locked)
Using the AND and OR functions independently or within IF functions9m 58s
-
(Locked)
Vertical and horizontal alignment settings and orientation options7m 12s
-
(Locked)
Sorting tips and shortcuts8m 40s
-
(Locked)
A look at new chart types in Excel 2016: Waterfall6m 57s
-
(Locked)
Work with formulas and formats: Decimals and fractions5m 42s
-
(Locked)
Creating mixed reference formulas; converting to a table; applying conditional formatting8m 6s
-
(Locked)
Control gridlines in charts and on worksheets7m 45s
-
(Locked)
Use the INDIRECT function with intersection formulas and range names to extract data6m 34s
-
(Locked)
Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes7m 14s
-
(Locked)
Control phone number and postal code formats using built-in options or customized formats7m 40s
-
(Locked)
Change the default Excel chart type; create and use chart templates6m 13s
-
(Locked)
Create your own customized date and time formats7m 31s
-
(Locked)
Create on-screen warnings and reminders with comments or data validation messages6m 18s
-
(Locked)
Use REPLACE for formats only, for data only, or for both6m 11s
-
(Locked)
Create numeric formats: Display in thousands or millions11m 40s
-
(Locked)
Converting dates like 20102006 into usable date entries4m 25s
-
(Locked)
Create custom lists for letter series like A to Z6m 26s
-
(Locked)
Freeze Panes and Split5m 30s
-
(Locked)
NETWORKDAYS.INTL and WORKDAY.INTL5m 29s
-
(Locked)
Calculate % of change5m 41s
-
(Locked)
Fill in all blank cells within a range with either formatting or data4m 13s
-
(Locked)
Use the COUNT and COUNTA functions4m 19s
-
(Locked)
Use workbook protection to prevent use of sheet commands5m 27s
-
(Locked)
Rank data with the RANK and RANK.AVG functions5m 37s
-
(Locked)
Use nonstandard fiscal years and quarters in PivotTables5m 35s
-
(Locked)
Identify or extract unique entries in a list5m 22s
-
(Locked)
Keyboard, mouse, and command techniques for viewing worksheets5m 18s
-
(Locked)
Create artistic charts with random numbers7m 23s
-
(Locked)
Extract day, month, and year from date fields5m 7s
-
(Locked)
Compare data with EXACT, FIND, and SEARCH functions4m 58s
-
(Locked)
How to covert ROMAN numberals4m 25s
-
(Locked)
Use range names for more readable formulas5m 38s
-
(Locked)
Customize your Quick Access Toolbar6m 7s
-
(Locked)
Conditional formatting based on date proximity4m 51s
-
(Locked)
How to adjust names5m 45s
-
(Locked)
Differences and limitations of converting data to a table5m 17s
-
(Locked)
Avoid the #DIV/0 error message4m 56s
-
(Locked)
Explore formatting options not available on the Home tab4m 25s
-
(Locked)
Control table formatting with custom formats3m 12s
-
(Locked)
Use date functions for age and tenure calculations5m 23s
-
(Locked)
Avoid unintentional entries when typing code numbers4m 29s
-
(Locked)
Sorting by moving columns4m 16s
-
(Locked)
Calculating cumulative totals3m 52s
-
(Locked)
Using the CONVERT function for different numbering systems4m 56s
-
(Locked)
Creating an automatically expanding chart by basing it on a table4m 24s
-
(Locked)
Keystroke shortcuts using the Alt key5m 20s
-
(Locked)
Using the Solver Add-in4m 29s
-
(Locked)
Column widths, row heights, merging cells, and related formatting issues5m 1s
-
(Locked)
Adjusting default layouts and date grouping in PivotTables4m 14s
-
(Locked)
Auditing cell content with Watch Window and dependent cell formulas4m 21s
-
(Locked)
Use the LEN and REPT functions for specialized cell testing and display options4m 4s
-
(Locked)
Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters5m 6s
-
(Locked)
Create double-spaced and triple-spaced printouts while repeating column headings4m 13s
-
(Locked)
Helpful keystroke shortcuts5m 2s
-
(Locked)
Identify weekdays and weekend days in data4m 50s
-
(Locked)
Use chart and filter for presentations4m 9s
-
(Locked)
Create picture links5m 37s
-
(Locked)
How to use the error-checking rules in Excel4m 59s
-
(Locked)
Protect worksheets and lock cells5m 24s
-
(Locked)
Use mixed addresses in Excel formulas5m 35s
-
(Locked)
Rapid filtering with Filter by Selection3m 45s
-
(Locked)
Display large values5m 16s
-
(Locked)
Tracking down conditional formatting and data validation rules5m 42s
-
(Locked)
Transposing data and using the TRANSPOSE function5m 43s
-
(Locked)
Displaying gridlines, borders, and column/row headings when printing4m 37s
-
(Locked)
Exploring some of the 200-plus SmartArt graphic options4m 1s
-
(Locked)
Using the CEILING and FLOOR functions for specialized rounding needs5m 16s
-
(Locked)
Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners5m 39s
-
(Locked)
Tabulating totals with the VLOOKUP function and array constants5m 12s
-
(Locked)
Working with array formulas more easily4m 23s
-
(Locked)
Using the new UNIQUE function to count and copy unique list entries3m 36s
-
(Locked)
Creating and updating sample data5m 43s
-
(Locked)
Format macros to make you a more efficient Excel user5m 23s
-
(Locked)
Use the new SORT and SORTBY functions to extract sorted lists5m 44s
-
(Locked)
Use themes to adjust worksheet colors, fonts, and effects3m 42s
-
(Locked)
Calculate loan payments and investments with PMT and FV functions6m 16s
-
(Locked)
Chart display options with blank cells in source data4m 25s
-
(Locked)
Adjust Conditional Formatting rules by altering percentage breakpoints4m 36s
-
(Locked)
Discover new formula capabilities with new functions and dynamic arrays5m 6s
-
(Locked)
Sort or filter data based on color font or cell color background5m 50s
-
(Locked)
Simplify the use of special characters and symbols5m 24s
-
(Locked)
Select from over 800 icons to enliven worksheets6m 29s
-
(Locked)
Use the new RANDARRAY function that replaces RAND and RANDBETWEEN6m 26s
-
(Locked)
How and when to use an area chart4m 16s
-
(Locked)
Insert colorful images with the People Graph Add-in5m 37s
-
(Locked)
Use formulas to create interactive charts5m 32s
-
(Locked)
Track variables using the Scenario Manager4m 43s
-
(Locked)
Get totals quickly without creating formulas5m 2s
-
(Locked)
Use column or row references to create dynamic formulas4m 31s
-
(Locked)
Overcoming obstacles when working with dates in charts4m 45s
-
(Locked)
Create map-type charts based on geographical locations4m 19s
-
(Locked)
Techniques for creating date series4m 42s
-
(Locked)
Extract filtered data with data validation and the FILTER function4m 34s
-
(Locked)
Use Find and Replace to change cell contents and formats6m 12s
-
(Locked)
Add formula tools and symbols to the Quick Access Toolbar5m 12s
-
(Locked)
Use the XLOOKUP function to replace VLOOKUP5m 23s
-
(Locked)
Change PivotTable settings for titles and summaries5m 58s
-
(Locked)
Use the Excel filtering capability for dates4m 57s
-
(Locked)
Use worksheet names in formulas5m 31s
-
(Locked)
Use data validation rules with special phone and social security formats5m 44s
-
(Locked)
Work with time calculations in formulas5m 14s
-
(Locked)
Prevent and locate duplicate worksheet entries4m 41s
-
(Locked)
Look forward and backward using EDATE and other date functions5m 37s
-
(Locked)
Display and highlight worksheet formula cells5m 46s
-
(Locked)
Split or join columnar data with Text to Columns or Flash Fill4m 55s
-
(Locked)
Highlight milestone data with conditional formatting and cumulative formulas5m 38s
-
(Locked)
Use the XMATCH function to replace MATCH3m 43s
-
(Locked)
Create a powerful macro4m 40s
-
(Locked)
Work with hidden and visible data in filtered and subtotaled lists5m 54s
-
(Locked)
Use TODAY, NOW, YEARFRAC, and DATEDIF6m 17s
-
(Locked)
Use data validation rules to prevent duplicate entries in a range4m 38s
-
(Locked)
Use various techniques to hide cells, rows, columns, and worksheets4m 56s
-
(Locked)
Align, arrange, and rotate shapes in worksheets5m 40s
-
(Locked)
File documentation with the Workbook Statistics button4m 22s
-
(Locked)
Avoid misleading visuals when rescaling5m 16s
-
(Locked)
Use the Fill Justify feature to wrap long text4m 2s
-
(Locked)
Create range names from Column and Row headings3m 51s
-
(Locked)
Use the SUBSTITUTE and REPLACE functions4m 47s
-
(Locked)
Accelerate Conditional Formatting with the Quick Access Toolbar4m 15s
-
(Locked)
Use wildcard symbols in functions5m 14s
-
(Locked)
Use wildcard symbols in filtering and commands6m 7s
-
(Locked)
Condense lengthy nested IF functions with the newer IFS function4m 43s
-
(Locked)
Add flair to charts with these formatting options: Gap width, shadow, glow, 3D, and more6m 18s
-
(Locked)
Control worksheet security by allowing selected users to edit specific cell ranges5m 43s
-
(Locked)
Retrieve vital data based on location using the Geography tool5m 2s
-
(Locked)
Use the new SEQUENCE function to quickly build numeric and date arrays5m 46s
-
(Locked)
Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions6m 19s
-
(Locked)
Create a list box to facilitate selection of data from a list5m 35s
-
(Locked)
Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more5m 36s
-
(Locked)
Enhance readability with banded rows via conditional formatting5m 25s
-
(Locked)
Seven different ways to drag data using the Ctrl, Shift, and Alt keys6m 3s
-
(Locked)
Use the SWITCH function: Compare with IFS, CHOOSE, and other lookup functions5m 48s
-
(Locked)
Adjust charts quickly with quick layout, change colors, and chart styles options4m 39s
-
(Locked)
Analyze PivotTable data with 13 different Show Values As options5m 10s
-
(Locked)
Expand/collapse or sort displayed results when using the SUBTOTAL command5m 18s
-
(Locked)
Use the AGGREGATE function to circumvent errors and ignore hidden data5m 17s
-
(Locked)
Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration6m 11s
-
(Locked)
Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH4m 29s
-
(Locked)
Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more5m 54s
-
(Locked)
Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect5m 56s
-
(Locked)
Using the LET function to simplify formulas via programming concepts5m 4s
-
(Locked)
Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash4m 35s
-
(Locked)
Create moving averages with formulas and chart trendlines5m 47s
-
(Locked)
Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR6m 5s
-
(Locked)
Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability5m 26s
-
(Locked)
Work with cell colors, patterns, and effects to emphasize data and provide visual flair4m 34s
-
(Locked)
Dynamic array formulas, new ways to calculate: One formula displays results in multiple cells5m 27s
-
(Locked)
Fonts such as Arial and Calibri and a rundown of various available fonts in Excel6m 5s
-
(Locked)
Use 3D formulas to tabulate data from multiple worksheets with the same layout6m 36s
-
(Locked)
Multiple built-in date formats as well as tons of self-defined variations; m/d/y and mmm-d-yyyy6m 24s
-
(Locked)
Where does that cell get its data from?: Tracking down cell precedents4m 15s
-
(Locked)
Controlling date entry restrictions using data validation3m 59s
-
(Locked)
Remove duplicates from a list vs. creating a new list without duplicates4m 26s
-
(Locked)
New data types: Extract valuable online data into your worksheets5m 9s
-
(Locked)
Use the FILTER and UNIQUE functions together for dynamic extractions5m 1s
-
(Locked)
Adjusting text entries with the UPPER, LOWER, and PROPER functions4m 55s
-
(Locked)
Refine filtering needs via custom filter options5m 55s
-
(Locked)
Comparing column charts and bar charts: Pros and cons6m 28s
-
(Locked)
How to use exponentiation (powers and roots) in Excel formulas5m 50s
-
(Locked)
Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions4m 18s
-
(Locked)
Tips for saving time when typing function names6m 38s
-
(Locked)
SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted6m 37s
-
(Locked)
Conversion of values into binary, octal, decimal, and hexadecimal equivalents4m 30s
-
(Locked)
Quick number formatting with keystroke shortcuts and icon buttons7m 7s
-
(Locked)
Date calculation and formatting issues related to the 2029/2030 switch4m 34s
-
(Locked)
Using wildcards in the new XLOOKUP and XMATCH functions5m 56s
-
(Locked)
Using slicers as analytical tools6m 2s
-
(Locked)
Conditional formatting using contrasting heat maps on multiple vs.single ranges5m 44s
-
(Locked)
Create dynamic pick lists using the UNIQUE and SORT functions, and data validation6m 11s
-
(Locked)
Contrasting uses of clustered column and stacked column charts6m 57s
-
(Locked)
Use the XLOOKUP function with multiple column criteria and multiple column results4m 39s
-
(Locked)
Tips for updating entire columns of date entries when using real or sample data4m 15s
-
(Locked)
Filtering lists with AND and OR criteria when using the FILTER function4m 29s
-
(Locked)
Using TRIM, CLEAN and other functions to clean up text data5m 47s
-
(Locked)
Create multiple range names from the top row and/or left column5m 47s
-
(Locked)
Use dragging techniques to extend dates by weekdays only, month, or year3m 55s
-
(Locked)
Use the LAMBDA function to create worksheet functions6m 27s
-
(Locked)
Get the formula results you want using Goal Seek5m 7s
-
(Locked)
Sort your data based on a Custom List that you define5m 43s
-
(Locked)
Create a dynamic sheet name reference with the INDIRECT function4m 41s
-
(Locked)
Calculate dates and/or days of the week for selected future holidays4m 6s
-
(Locked)
Use dragging techniques for faster Paste Special options5m 12s
-
(Locked)
How to use and not use SS numbers; fake SS numbers; display as XXX-XX-99994m 51s
-
(Locked)
Five indispensable keystroke shortcuts for Windows and Mac users5m 35s
-
(Locked)
Using new formula-writing techniques to simplify wide-ranging formulas6m 6s
-
(Locked)
Calculate time differences within days and across multiple days6m 26s
-
(Locked)
Use keyboard, mouse, and commands to zoom in/out quickly in Excel Windows and Mac versions5m 45s
-
(Locked)
Make dynamic presentations with rapid expand/collapse detail features in outlining5m 54s
-
(Locked)
Get data analysis suggestions with the Analyze Data (formerly Ideas) tool5m 41s
-
(Locked)
Using the Distinct vs. Unique options when using the UNIQUE function4m 58s
-
(Locked)
Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it4m 29s
-
(Locked)
Exploring Excel's Sunburst chart to display hierarchical data5m 5s
-
(Locked)
Creating floating text boxes with shadow, reflection, glow, and other shape effects4m 27s
-
(Locked)
Page Setup tip: Print repeating titles, shrink-to-fit, landscape/portrait, double-spaced layout6m 4s
-
(Locked)
Use Data Validation based on multiple criteria5m 38s
-
(Locked)
Customize the Quick Access Toolbar using the Alt key or a mouse5m 44s
-
(Locked)
Exploring treemap charts to display hierarchical data6m 5s
-
(Locked)
Use the Quick Analysis tool for easy access to power tools3m 36s
-
(Locked)
Create a number series with the Ctrl key and left/right mouse button5m 56s
-
(Locked)
Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales4m 51s
-
(Locked)
Unhide multiple worksheets at once and use the very hidden option5m 5s
-
(Locked)
Use the Fill Justify command to quickly rewrap text into different cells3m 45s
-
(Locked)
Create a 15th day or end-of-month series and adjust to weekdays only4m 27s
-
(Locked)
Use the Go To Special option to select and populate blank cells5m 4s
-
(Locked)
Accentuate values with conditional formatting and sparklines6m 10s
-
(Locked)
Transpose data with formula substitution and the TRANSPOSE function4m 34s
-
(Locked)
Use emojis and other symbols in formulas and charts5m 50s
-
(Locked)
Use the Advanced Filter for specialized filtering needs5m 48s
-
(Locked)
Combo charts: Combine different chart types to present data more clearly5m 33s
-
(Locked)
Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells6m 29s
-
(Locked)
Exploring Edit Default Layout options when using PivotTables4m 28s
-
(Locked)
Navigation tips: Shortcuts to jump within and between worksheets and workbooks5m 44s
-
(Locked)
Use DATEDIF to calculate months or days after yearly or monthly anniversaries5m 18s
-
(Locked)
WordArt Transform: Special text character layouts5m 24s
-
(Locked)
Sort data based on months and weekdays, even when entered as text5m 36s
-
(Locked)
Use formulas to calculate values across worksheets and workbooks6m 32s
-
(Locked)
Use XLOOKUP instead of complex combinations of VLOOKUP, INDEX, and MATCH5m 41s
-
(Locked)
Use dragging techniques to create a forecast based on TREND and GROWTH functions5m 25s
-
(Locked)
Stock charts: Adding Open, High, Low, Close, and Volume values4m 49s
-
(Locked)
Control gridlines: Change colors, turn them on/off, and assign to a macro button4m 50s
-
(Locked)
Examples of TRANSPOSE and other functions working differently with the new calculation engine5m 18s
-
(Locked)
Locate formula dependencies via keystroke shortcuts and the Trace Dependents command4m 48s
-
(Locked)
Replace text based on formats, like cell attributes (bold, text color, etc.)5m 2s
-
(Locked)
Create forms using check boxes and option buttons to simplify data entry5m 47s
-
(Locked)
Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data6m 2s
-
(Locked)
Create a moving average with a chart or by using a formula4m 22s
-
(Locked)
Redesigned Data Validation feature: Now more efficient when using large lists4m 43s
-
(Locked)
Link pictures of data ranges to changing data4m 14s
-
(Locked)
Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas5m 29s
-
(Locked)
Create multiple PivotTables from a single source6m 47s
-
(Locked)
Explore icon sets in the Excel Conditional Formatting feature4m 46s
-
(Locked)
Use the IMAGE function to paste an image into a cell4m 40s
-
(Locked)
Use TOCOL and TOROW to realign array data into single columns and rows5m 28s
-
(Locked)
Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows5m 3s
-
(Locked)
Use bubble charts to show relationships between sets of values5m 35s
-
(Locked)
Contrast TEXTJOIN, CONCAT, and TEXTSPLIT to gather and split data5m 47s
-
(Locked)
Use shrink-to-fit options to adjust the display of cell content and compress printed output4m 22s
-
(Locked)
Locate formula precedents via keystroke shortcuts and the Trace Precedents command4m 5s
-
(Locked)
Try these editing tips and keystroke shortcuts to use with long formulas5m 38s
-
(Locked)
Customize and utilize status bar displays and copy/paste its data4m 57s
-
(Locked)
Command and keystroke shortcuts for sorting frequently used data4m 57s
-
(Locked)
Extract text from cells using the new TEXTBEFORE and TEXTAFTER functions4m 14s
-
(Locked)
Quickly link cell content for main titles and axis titles for selected chart types4m
-
(Locked)
Use the TAKE, DROP, FILTER and SORTBY functions to build dependent lists6m 9s
-
(Locked)
Create new lists by changing the PivotTable Report Layout to Tabular and adding repeating labels4m 10s
-
(Locked)
Rapid filtering by content, cell color, or font color via right-clicking3m 31s
-
(Locked)
Restructure column/row data using new WRAPROWS and WRAPCOLS functions6m 2s
-
(Locked)
Working with date and time-based data and the over-24-hour display issue5m 25s
-
(Locked)
Multiple tips for creating charts quickly5m 44s
-
(Locked)
Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions5m 16s
-
(Locked)
Overcoming rounding concerns in formulas with functions and decimal displays4m 13s
-
(Locked)
Highlighting PivotTable results with conditional formatting4m 42s
-
(Locked)
An overview of the 12 database functions in Excel5m 21s
-
(Locked)
Advantages and disadvantages of using pie charts to display data4m 20s
-
(Locked)
Rapid sorting via right-clicking options3m 20s
-
(Locked)
Converting charts into pictures3m 50s
-
(Locked)
Using three functions to track worksheet cells that are text, numbers, or formulas6m 44s
-
(Locked)
Using new BYROW and BYCOL functions to analyze data6m 25s
-
(Locked)
Create formulas rapidly with these shortcuts6m 50s
-
(Locked)
Exploring 3-D Column and 3-D Bar charts5m 55s
-
(Locked)
New VSTACK and HSTACK functions6m 35s
-
(Locked)
Calculating day of the week totals from a large transaction list5m 27s
-
(Locked)
Contrasating uses of the newer functions: XMATCH and XLOOKUP7m 11s
-
(Locked)
Various techniques for highlighting (selecting) cell ranges quickly7m 25s
-
(Locked)
Inserting special symbols using AutoCorrect options and the Insert Symbol command6m 39s
-
(Locked)
Reviewing Excel Information functions - ISBLANK, ISNUMBER, ISTEXT, etc.6m 31s
-
(Locked)
Manipulating text functions LEFT, MID, and TEXT to create new ID numbers5m 10s
-
(Locked)
Discovering timesaving tools in the Go To Special feature6m 13s
-
(Locked)
Calculating chronological and fiscal quarters6m 10s
-
(Locked)
Sorting by moving columns left/right - in tables, Pivot Tables, SORT and SORTBY5m 37s
-
(Locked)
Using Conditional Formatting for analysis and data emphasis6m 11s
-
(Locked)
Using Indent buttons to control text displays and currency formatting3m 32s
-
(Locked)
Create shapes and text boxes with content linked to worksheet cells5m 2s
-
(Locked)
Dynamically presenting data via chart slicers5m 6s
-
(Locked)
Sorting by day of month for birthday and anniversary lists3m 34s
-
(Locked)
Using wildcards (asterisk, question mark, and tilde) in formulas and commands7m 32s
-
(Locked)
Using SEARCH, FIND, and COUNT to tabulate data occurrences4m 30s
-
(Locked)
Comparing the Data Analysis Histogram feature and Excel's Histogram chart5m 9s
-
(Locked)
Using the AND and OR functions independently or within IF functions6m 25s
-
(Locked)
Use various techniques to flip lists upside-down or left-to-right4m 52s
-
(Locked)
Combine data with the TEXTJOIN, CONCAT, and CONCATENATE5m 9s
-
(Locked)
Use Excel's Advanced Options to fine-tune settings and increase efficiency5m 19s
-
(Locked)
Use ALT and other shortcuts when working with AutoComplete, Data Validation, etc.4m 5s
-
(Locked)
Use the powerful COUNTIF family—8 functions—for statistical analysis7m 18s
-
(Locked)
Show relationships between sets of values with a Scatter(XY) Chart7m 4s
-
(Locked)
Locate and track a worksheet's Data Validation rules and violations5m 40s
-
(Locked)
Use AGGREGATE to avoid errors and ignore hidden data5m 52s
-
(Locked)
Explore multiple approaches for locating, preventing, and deleting duplicate data5m 20s
-
(Locked)
Use a single SEQUENCE function to create various date layouts5m 24s
-
(Locked)
Combine a Validation list, XLOOKUP function, table, and chart to build a presentation model5m 10s
-
(Locked)
Pros and cons of using Stacked Area charts and Stacked Column Charts5m 7s
-
(Locked)
Nested use of FILTER, SORT, and CHOOSECOLS functions for selective column retrieval6m 41s
-
(Locked)
Learn about the new Office Theme, the default Aptos Font and new colors in M365 apps5m 7s
-
(Locked)
Analyze data using TOCOL, TOROW, LARGE, and SMALL4m 49s
-
(Locked)
Refine chart elements quickly with the powerful and overlooked Quick Layout button5m 43s
-
(Locked)
Tips and techniques for displaying Excel worksheets effectively during presentations6m 51s
-
(Locked)
Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions6m 39s
-
(Locked)
Using entire column (or row) references to create more dynamic formulas6m 51s
-
(Locked)
Using Excel's Accessibility Checker to follow best practices for those with disabilities5m 10s
-
(Locked)
Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data6m 28s
-
(Locked)
Create dynamic presentations with Slicers, Filters, and Charts6m 39s
-
(Locked)
Compare and contrast multiple column sorting with SORT and SORTBY9m 8s
-
(Locked)
Use keystroke and mouse shortcuts to display and navigate worksheets7m 35s
-
(Locked)
Show gain/loss in census figures with the RANK, IF, and LET functions7m 28s
-
(Locked)
Apply conditional formatting across data rows7m 43s
-
(Locked)
Expand and collapse date displays in PivotTables4m 19s
-
(Locked)
Use TODAY and NOW for real-time up-to-date calculations5m 9s
-
(Locked)
Use Freeze Panes and Split to view different worksheet portions7m 19s
-
(Locked)
Use CEILING and FLOOR for specialized numeric rounding needs6m 31s
-
(Locked)
Highlight negative positive values with Conditional Formatting and Data Bars5m 56s
-
(Locked)
Use AutoSum to simplify and accelerate formula creations4m 44s
-
(Locked)
Dynamic sheet name reference with INDIRECT5m 27s
-
(Locked)
Create custom and built-in lists to sort and fill in sequences8m 11s
-
(Locked)
Consolidate and split workbooks5m 51s
-
(Locked)
Expand, collapse and sort displayed results when using Subtotal6m 39s
-
(Locked)
Random number functions: RAND, RANDBETWEEN, and RANDARRAY5m 48s
-
(Locked)
Using the new GROUPBY and PIVOTBY functions6m 28s
-
(Locked)
Creating 3D and other formulas that use data from different worksheets7m 34s
-
(Locked)
Quick searching for menu commands with the right mouse button3m 41s
-
(Locked)
Using the new Checkbox button on the Insert tab4m 13s
-
(Locked)
Using Ctrl+Shift+V and other quick methods to copy values without formulas5m 18s
-
(Locked)
Use SORT and FILTER function to create charts based on dynamic arrays7m 44s
-
(Locked)
Extracting data from an online image6m 17s
-
(Locked)
What’s included
- Practice while you learn 341 exercise files
- Learn on the go Access on tablet and phone