Back to course list
- Level: Intermediate
- Duration: 36h 07m
- Release date: 2015-01-16
- Author: Dennis Taylor
- Provider: LinkedIn
Excel Tips Weekly
Description
Content
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.
- Excel Tips - New This Week05m 35s
- Five indispensable keystroke shortcuts for Windows and Mac users05m 35s
- Previous Episodes36h 01m 45s
- Hide and unhide worksheets securely06m 06s
- Resizing, moving, copying, and manipulating charts and other objects10m 17s
- Using list boxes and combo boxes to facilitate forms creation07m 36s
- Using the FORMULATEXT and N functions for worksheet and formula documentation05m 53s
- Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells07m 55s
- Summarizing data from diverse ranges with Data > Consolidate09m 33s
- Using check boxes and conditional formatting together for dynamic displays05m 58s
- Becoming more productive with these 10 tiny tips you'll use often08m
- Transposing data and charts for a different perspective on your data08m 57s
- Applying conditional formatting across rows of data06m 43s
- Exploring various layouts for your PivotTable04m 27s
- Splitting and consolidating workbooks06m 47s
- Using date and time as metrics in a PivotTable06m 53s
- Adding illustrations to your workbook12m 07s
- Using a pick list, VLOOKUP, table, and chart together08m 05s
- Using formulas to calculate values across worksheets and workbooks11m 12s
- Dynamically presenting data via chart slicers07m 15s
- Parsing your data to create unique lists03m 21s
- Using the REPT function to represent data visually03m 06s
- Using source data from a table to make your PivotTable more dynamic07m 08s
- Accelerating Cut, Copy, Paste, and Insert tasks07m 26s
- Increasing your productivity with custom lists05m 09s
- Highlighting PivotTable results with conditional formatting06m 10s
- Customizing templates to fit your unique needs06m 06s
- Creating dynamic charts with in-cell conditional formatting03m 26s
- Enhancing table filtering with slicers05m 23s
- Converting charts into pictures04m 51s
- Custom grouping in PivotTables04m 31s
- Quick formatting tips08m 09s
- The top five unknown but useful keyboard shortcuts06m 17s
- Using the TREND and GROWTH functions for projecting future results05m 54s
- Using scroll bars and spin buttons to facilitate forms creation10m 01s
- Creating colorful 3D buttons for worksheet annotation and macro buttons06m 52s
- Calculating with hours, minutes, and times of day11m 02s
- Tracking down cell dependencies across multiple worksheets and workbooks06m 24s
- Discovering time-saving tools in the Go To Special feature11m 22s
- Using Go To Special06m 01s
- Reducing data entry time by expanding AutoCorrect options06m 10s
- Setting up custom views for quick access to different worksheet displays06m 30s
- Using hyperlinks for rapidly switching worksheet locations and jumping to websites07m 18s
- Controlling worksheet security by allowing selected users to edit specific cell ranges07m 22s
- Using option buttons, group boxes, and checkboxes to facilitate forms creation08m 07s
- Exploring what-if scenarios using Goal Seek09m 55s
- Creating text, numerical, date, and time lists in a flash06m 54s
- Creating variable conditional formatting rules08m 04s
- Handling dates with unusual formats06m 05s
- Using wildcards (asterisk, tilde, and question mark)11m
- Custom formats using asterisk, semicolon, and brackets13m
- Meeting unusual filtering needs via Advanced Filter05m 28s
- Create an organization chart08m 56s
- Two-way lookup using the MATCH and INDEX functions11m 28s
- Using Excel error-checking functions10m 37s
- Custom formats, relative addressing, and conditional formatting08m 26s
- Auditing09m 01s
- Adding comments and shapes07m 35s
- Drawing borders and border grids05m 45s
- Building a flexible monthly table using functions11m 44s
- Adding pictures as worksheet backgrounds04m 15s
- ADDRESS, ROW, and COLUMN functions08m 08s
- Join data with new CONCAT and TEXTJOIN functions06m 15s
- Working with formulas in tables13m 02s
- Locating data validation rules and violations07m 20s
- Creating an Excel template07m 57s
- Restoring missing column titles06m 41s
- Creating a pick list dependent on another pick list06m 59s
- Using command shortcuts with the Alt key05m 51s
- Set up a macro for sorting dynamic data08m 42s
- Use random number functions for sorting and creating sample data09m 57s
- Use calcuated fields and calculated items in a PivotTable08m 57s
- Replace characters by position with the REPLACE function05m 46s
- Work with formulas in tables09m 03s
- Keystroke shortcuts from A to Z: Using the Ctrl key16m 16s
- Use special tricks for working with dates in charts11m 36s
- Use a data form for data entry and exploring data06m 42s
- Creating an Excel template to simplify updating a monthly file07m 10s
- Calculate dates efficiently using Excel's hidden function - DATEDIF07m 36s
- Create dynamic sheet name references with the INDIRECT function06m 45s
- Avoid errors and hidden data with the powerful AGGREGATE function07m 08s
- Hide worksheets, row, columns, cells and other Excel elements07m 26s
- Use slicers and charts together for dynamic presentations09m 04s
- Save a chart as a template: Use the template for current or new charts06m 02s
- MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions08m 12s
- Adjust a chart's source data and adjust its series order09m 07s
- Use the OFFSET function for tabulating moving data11m 23s
- Alter numeric data without formulas10m 19s
- Use Flash Fill to rapidly combine or separate columnar data10m 28s
- Adjust banded-row formatting14m 35s
- Change the shape of comment boxes and other objects06m 32s
- How and when to use the 10 rounding functions in Excel13m 26s
- Calculate faster with the AutoSum button and AutoSum keystroke shortcut06m 54s
- How to use mixed cell references08m 25s
- Activate the Speak On Enter and Speak Cells features05m 38s
- Accelerate data entry with five special techniques12m 08s
- Insert a text box or shape and link a cell's content to it06m 58s
- Use Watch Window and other techniques to track changing cells08m 21s
- How to create time interval entries11m 39s
- How to create frequency tabulations and distributions08m 10s
- Create an expanded list from a summary using PivotTable techniques07m 25s
- Solve matching issues with matching phone numbers and SS numbers10m
- Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative07m 27s
- Use outlining tools to quickly expand and collapse data for dynamic presentations09m 19s
- Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting09m 59s
- Create lists of all 2nd Tuesdays, last Tuesdays. and other date series10m 44s
- Create linkage formulas that refer to other worksheets and workbooks11m 49s
- Formula nesting: Using multiple functions in the same formula13m 22s
- Keyboard shortcuts for numeric formats08m 18s
- Use the Subtotal command to analyze data with single- or multiple-level subtotals09m 15s
- Work with MAX, MAXIFS, LARGE, and related functions08m 14s
- Use the dynamic TODAY and NOW functions for real-time up-to-date calculations09m 24s
- Use the FIND, MID, LEFT, and RIGHT functions10m 38s
- Flip the left-to-right order of columns with the INDEX function or sort by columns08m 18s
- Working with hidden data when copying cells and creating charts10m 58s
- Use conditional formatting data bars to accentuate negative data04m 16s
- Creative use of sparklines in merged cells with axes07m 01s
- Copy formats quickly using dragging techniques and the Format Painter05m 25s
- Displaying multiple worksheets and workbooks together10m 13s
- Tips for creating and updating sample data11m 01s
- Use conditional formatting to overcome formatting limitations of the IF function08m 54s
- Use VLOOKUP, MATCH, and INDEX functions with array formulas10m 38s
- Summarize data from different worksheets with a PivotTable07m 20s
- AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas06m 59s
- Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions08m 40s
- Use custom formulas in data validation to keep out bad data13m 18s
- Dealing with circular errors08m 20s
- Tips for creating charts quickly06m 56s
- Creating heat maps using conditional formatting08m 31s
- Using the INDEX function to extract data by row and column11m 01s
- Displaying tips when using Excel in presentations06m 23s
- The Wrap Text, Merge and Center, and Indent options09m 02s
- Using fill effects (gradients, patterns, styles) for colorful cell background variations05m 10s
- Working with multiple worksheets simultaneously08m 42s
- Exploring font choices not found on the Home tab04m 02s
- Using WordArt for special titles and headings04m 33s
- Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions07m 34s
- Borders and gridlines: Exploring variations, options, and differences08m 24s
- New Excel 2016 chart types: Tree map and sunburst07m 29s
- Freezing column and row titles07m 48s
- Use data validation to force entries to be uppercase or lowercase10m 48s
- Avoiding common chart distortions11m 49s
- Use the new funnel chart available in Excel 36504m 03s
- Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character06m 01s
- Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!09m 39s
- Creating cross-totals with the SUMIFS function and mixed references05m 50s
- New Excel 2016 chart types: Histogram, Pareto, and box, and whisker10m 08s
- Using the AND and OR functions independently or within IF functions09m 58s
- Vertical and horizontal alignment settings and orientation options07m 12s
- Sorting tips and shortcuts08m 40s
- A look at new chart types in Excel 2016: Waterfall06m 57s
- Work with formulas and formats: Decimals and fractions05m 42s
- Creating mixed reference formulas; converting to a table; applying conditional formatting08m 06s
- Control gridlines in charts and on worksheets07m 45s
- Use the INDIRECT function with intersection formulas and range names to extract data06m 34s
- Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes07m 14s
- Control phone number and postal code formats using built-in options or customized formats07m 40s
- Change the default Excel chart type; create and use chart templates06m 13s
- Create your own customized date and time formats07m 31s
- Create on-screen warnings and reminders with comments or data validation messages06m 18s
- Use REPLACE for formats only, for data only, or for both06m 11s
- Create numeric formats: Display in thousands or millions11m 40s
- Converting dates like 20102006 into usable date entries04m 25s
- Create custom lists for letter series like A to Z06m 26s
- Freeze Panes and Split05m 30s
- NETWORKDAYS.INTL and WORKDAY.INTL05m 29s
- Calculate % of change05m 41s
- Fill in all blank cells within a range with either formatting or data04m 13s
- Use the COUNT and COUNTA functions04m 19s
- Use workbook protection to prevent use of sheet commands05m 27s
- Rank data with the RANK and RANK.AVG functions05m 37s
- Use nonstandard fiscal years and quarters in PivotTables05m 35s
- Identify or extract unique entries in a list05m 22s
- Keyboard, mouse, and command techniques for viewing worksheets05m 18s
- Create artistic charts with random numbers07m 23s
- Extract day, month, and year from date fields05m 07s
- Compare data with EXACT, FIND, and SEARCH functions04m 58s
- How to covert ROMAN numberals04m 25s
- Use range names for more readable formulas05m 38s
- Customize your Quick Access Toolbar06m 07s
- Conditional formatting based on date proximity04m 51s
- How to adjust names05m 45s
- Differences and limitations of converting data to a table05m 17s
- Avoid the #DIV/0 error message04m 56s
- Explore formatting options not available on the Home tab04m 25s
- Control table formatting with custom formats03m 12s
- Use date functions for age and tenure calculations05m 23s
- Avoid unintentional entries when typing code numbers04m 29s
- Sorting by moving columns04m 16s
- Calculating cumulative totals03m 52s
- Using the CONVERT function for different numbering systems04m 56s
- Creating an automatically expanding chart by basing it on a table04m 24s
- Keystroke shortcuts using the Alt key05m 20s
- Using the Solver Add-in04m 29s
- Column widths, row heights, merging cells, and related formatting issues05m 01s
- Adjusting default layouts and date grouping in PivotTables04m 14s
- Auditing cell content with Watch Window and dependent cell formulas04m 21s
- Use the LEN and REPT functions for specialized cell testing and display options04m 04s
- Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters05m 06s
- Create double-spaced and triple-spaced printouts while repeating column headings04m 13s
- Helpful keystroke shortcuts05m 03s
- Identify weekdays and weekend days in data04m 50s
- Use chart and filter for presentations04m 09s
- Create picture links05m 37s
- How to use the error-checking rules in Excel04m 59s
- Protect worksheets and lock cells05m 24s
- Use mixed addresses in Excel formulas05m 35s
- Rapid filtering with Filter by Selection03m 45s
- Display large values05m 16s
- Tracking down conditional formatting and data validation rules05m 42s
- Transposing data and using the TRANSPOSE function05m 43s
- Displaying gridlines, borders, and column/row headings when printing04m 37s
- Exploring some of the 200-plus SmartArt graphic options04m 01s
- Using the CEILING and FLOOR functions for specialized rounding needs05m 16s
- Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners05m 39s
- Tabulating totals with the VLOOKUP function and array constants05m 12s
- Working with array formulas more easily04m 23s
- Using the new UNIQUE function to count and copy unique list entries03m 36s
- Creating and updating sample data05m 43s
- Format macros to make you a more efficient Excel user05m 23s
- Use the new SORT and SORTBY functions to extract sorted lists05m 44s
- Use themes to adjust worksheet colors, fonts, and effects03m 42s
- Calculate loan payments and investments with PMT and FV functions06m 16s
- Chart display options with blank cells in source data04m 25s
- Adjust Conditional Formatting rules by altering percentage breakpoints04m 36s
- Discover new formula capabilities with new functions and dynamic arrays05m 06s
- Sort or filter data based on color font or cell color background05m 50s
- Simplify the use of special characters and symbols05m 24s
- Select from over 800 icons to enliven worksheets06m 29s
- Use the new RANDARRAY function that replaces RAND and RANDBETWEEN06m 26s
- How and when to use an area chart04m 16s
- Insert colorful images with the People Graph Add-in05m 37s
- Use formulas to create interactive charts05m 32s
- Track variables using the Scenario Manager04m 43s
- Get totals quickly without creating formulas05m 02s
- Use column or row references to create dynamic formulas04m 31s
- Overcoming obstacles when working with dates in charts04m 45s
- Create map-type charts based on geographical locations04m 20s
- Techniques for creating date series04m 42s
- Extract filtered data with data validation and the FILTER function04m 34s
- Use Find and Replace to change cell contents and formats06m 12s
- Add formula tools and symbols to the Quick Access Toolbar05m 12s
- Use the XLOOKUP function to replace VLOOKUP05m 23s
- Change PivotTable settings for titles and summaries05m 58s
- Use the Excel filtering capability for dates04m 57s
- Use worksheet names in formulas05m 31s
- Use data validation rules with special phone and social security formats05m 44s
- Work with time calculations in formulas05m 14s
- Prevent and locate duplicate worksheet entries04m 41s
- Look forward and backward using EDATE and other date functions05m 37s
- Display and highlight worksheet formula cells05m 46s
- Split or join columnar data with Text to Columns or Flash Fill04m 55s
- Highlight milestone data with conditional formatting and cumulative formulas05m 38s
- Use the XMATCH function to replace MATCH03m 43s
- Create a powerful macro04m 40s
- Work with hidden and visible data in filtered and subtotaled lists05m 54s
- Use TODAY, NOW, YEARFRAC, and DATEDIF06m 17s
- Use data validation rules to prevent duplicate entries in a range04m 38s
- Use various techniques to hide cells, rows, columns, and worksheets04m 56s
- Align, arrange, and rotate shapes in worksheets05m 40s
- File documentation with the Workbook Statistics button04m 22s
- Avoid misleading visuals when rescaling05m 16s
- Use the Fill Justify feature to wrap long text04m 02s
- Create range names from Column and Row headings03m 51s
- Use the SUBSTITUTE and REPLACE functions04m 47s
- Accelerate Conditional Formatting with the Quick Access Toolbar04m 15s
- Use wildcard symbols in functions05m 14s
- Use wildcard symbols in filtering and commands06m 07s
- Condense lengthy nested IF functions with the newer IFS function04m 43s
- Add flair to charts with these formatting options: Gap width, shadow, glow, 3D, and more06m 18s
- Control worksheet security by allowing selected users to edit specific cell ranges05m 43s
- Retrieve vital data based on location using the Geography tool05m 02s
- Use the new SEQUENCE function to quickly build numeric and date arrays05m 46s
- Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions06m 19s
- Create a list box to facilitate selection of data from a list05m 35s
- Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more05m 36s
- Enhance readability with banded rows via conditional formatting05m 25s
- Seven different ways to drag data using the Ctrl, Shift, and Alt keys06m 03s
- Use the SWITCH function: Compare with IFS, CHOOSE, and other lookup functions05m 48s
- Adjust charts quickly with quick layout, change colors, and chart styles options04m 39s
- Analyze PivotTable data with 13 different Show Values As options05m 10s
- Expand/collapse or sort displayed results when using the SUBTOTAL command05m 18s
- Use the AGGREGATE function to circumvent errors and ignore hidden data05m 17s
- Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration06m 11s
- Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH04m 29s
- Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more05m 54s
- Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect05m 56s
- Using the LET function to simplify formulas via programming concepts05m 04s
- Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash04m 35s
- Create moving averages with formulas and chart trendlines05m 47s
- Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR06m 06s
- Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability05m 26s
- Work with cell colors, patterns, and effects to emphasize data and provide visual flair04m 34s
- Dynamic array formulas, new ways to calculate: One formula displays results in multiple cells05m 27s
- Fonts such as Arial and Calibri and a rundown of various available fonts in Excel06m 05s
- Use 3D formulas to tabulate data from multiple worksheets with the same layout06m 36s
- Multiple built-in date formats as well as tons of self-defined variations; m/d/y and mmm-d-yyyy06m 24s
- Where does that cell get its data from?: Tracking down cell precedents04m 15s
- Controlling date entry restrictions using data validation03m 59s
- Remove duplicates from a list vs. creating a new list without duplicates04m 26s
- New data types: Extract valuable online data into your worksheets05m 09s
- Use the FILTER and UNIQUE functions together for dynamic extractions05m 01s
- Adjusting text entries with the UPPER, LOWER, and PROPER functions04m 55s
- Refine filtering needs via custom filter options05m 55s
- Comparing column charts and bar charts: Pros and cons06m 28s
- How to use exponentiation (powers and roots) in Excel formulas05m 50s
- Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions04m 18s
- Tips for saving time when typing function names06m 38s
- SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted06m 37s
- Conversion of values into binary, octal, decimal, and hexadecimal equivalents04m 30s
- Quick number formatting with keystroke shortcuts and icon buttons07m 07s
- Date calculation and formatting issues related to the 2029/2030 switch04m 34s
- Using wildcards in the new XLOOKUP and XMATCH functions05m 56s
- Using slicers as analytical tools06m 02s
- Conditional formatting using contrasting heat maps on multiple vs.single ranges05m 44s
- Create dynamic pick lists using the UNIQUE and SORT functions, and data validation06m 11s
- Contrasting uses of clustered column and stacked column charts06m 57s
- Use the XLOOKUP function with multiple column criteria and multiple column results04m 39s
- Tips for updating entire columns of date entries when using real or sample data04m 15s
- Using TRIM, CLEAN and other functions to clean up text data05m 47s
- Create multiple range names from the top row and/or left column05m 47s
- Use dragging techniques to extend dates by weekdays only, month, or year03m 55s
- Use the LAMBDA function to create worksheet functions06m 27s
- Get the formula results you want using Goal Seek05m 07s
- Sort your data based on a Custom List that you define05m 43s
- Create a dynamic sheet name reference with the INDIRECT function04m 41s
- Calculate dates and/or days of the week for selected future holidays04m 06s
- Use dragging techniques for faster Paste Special options05m 12s
- How to use and not use SS numbers; fake SS numbers; display as XXX-XX-999904m 51s
Random courses
- Java: Creating a Basic Web App (Interactive)
- Webflow For Beginners : Create Your first Website on Webflow
- Buying on Ariba Discovery
- Character Design Basics
- Getting Started with MLflow
- CAU305 CyberArk CDE Recertification
- e.g. Learn Holistic Health and Wellness
- AWS Foundations: How Amazon SageMaker Can Help
- HashiCorp Certified: Vault Associate | practice Exams [2021]
- Using Salesforce Marketing Cloud Connect
Latest courses
- 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