Excel Tips Weekly

Excel Tips Weekly

Excel Tips Weekly is an Intermediate level tutorial on Business, written by the creator, Dennis Taylor. This tutorial is a critical step for a person who needs to sharpen his/her Business expertise. It provides you a thorough grip on Business, Business Intelligence, IT, Data Analysis, Spreadsheets, Excel, Business, Business Intelligence, IT, Data Analysis, Spreadsheets and Excel.

Free Download - Excel Tips Weekly
Author Dennis Taylor
Publish Date 1/16/2015
Skill Intermediate
Duration 29h 30m
Topic Business
Video Tutorials 335
Last Update 4/7/2020

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 Weekly : Video Lessons

  • Create a powerful macro4m 40s
  • Hide and unhide worksheets securely6m 6s
  • Resizing, moving, copying, and manipulating charts and other objects10m 17s
  • Using list boxes and combo boxes to facilitate forms creation7m 36s
  • Using the FORMULATEXT and N functions for worksheet and formula documentation5m 53s
  • Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells7m 55s
  • Summarizing data from diverse ranges with Data > Consolidate9m 33s
  • Using check boxes and conditional formatting together for dynamic displays5m 58s
  • Becoming more productive with these 10 tiny tips you'll use often8m
  • Transposing data and charts for a different perspective on your data8m 57s
  • Applying conditional formatting across rows of data6m 43s
  • Exploring various layouts for your PivotTable4m 27s
  • Splitting and consolidating workbooks6m 47s
  • Using date and time as metrics in a PivotTable6m 53s
  • Adding illustrations to your workbook12m 7s
  • Using a pick list, VLOOKUP, table, and chart together8m 5s
  • Using formulas to calculate values across worksheets and workbooks11m 12s
  • Dynamically presenting data via chart slicers7m 15s
  • Parsing your data to create unique lists3m 21s
  • Using the REPT function to represent data visually3m 6s
  • Using source data from a table to make your PivotTable more dynamic7m 8s
  • Accelerating Cut, Copy, Paste, and Insert tasks7m 26s
  • Increasing your productivity with custom lists5m 9s
  • Highlighting PivotTable results with conditional formatting6m 10s
  • Customizing templates to fit your unique needs6m 6s
  • Creating dynamic charts with in-cell conditional formatting3m 26s
  • Enhancing table filtering with slicers5m 23s
  • Converting charts into pictures4m 51s
  • Custom grouping in PivotTables4m 31s
  • Quick formatting tips8m 9s
  • The top five unknown but useful keyboard shortcuts6m 17s
  • Using the TREND and GROWTH functions for projecting future results5m 54s
  • Using scroll bars and spin buttons to facilitate forms creation10m 1s
  • Creating colorful 3D buttons for worksheet annotation and macro buttons6m 52s
  • Calculating with hours, minutes, and times of day11m 2s
  • Tracking down cell dependencies across multiple worksheets and workbooks6m 24s
  • Discovering time-saving tools in the Go To Special feature11m 22s
  • Adding, managing, and printing comments for worksheet documentation6m 1s
  • Reducing data entry time by expanding AutoCorrect options6m 10s
  • Setting up custom views for quick access to different worksheet displays6m 30s
  • Using hyperlinks for rapidly switching worksheet locations and jumping to websites7m 18s
  • Controlling worksheet security by allowing selected users to edit specific cell ranges7m 22s
  • Using option buttons, group boxes, and checkboxes to facilitate forms creation8m 7s
  • Exploring what-if scenarios using Goal Seek9m 55s
  • Creating text, numerical, date, and time lists in a flash6m 54s
  • Creating variable conditional formatting rules8m 4s
  • Handling dates with unusual formats6m 5s
  • Using wildcards (asterisk, tilde, and question mark)11m
  • Custom formats using asterisk, semicolon, and brackets13m
  • Meeting unusual filtering needs via Advanced Filter5m 28s
  • Create an organization chart8m 56s
  • Two-way lookup using the MATCH and INDEX functions11m 28s
  • Using Excel error-checking functions10m 37s
  • Custom formats, relative addressing, and conditional formatting8m 26s
  • Auditing9m 1s
  • Adding comments and shapes7m 35s
  • Drawing borders and border grids5m 45s
  • Building a flexible monthly table using functions11m 44s
  • Adding pictures as worksheet backgrounds4m 15s
  • ADDRESS, ROW, and COLUMN functions8m 8s
  • Join data with new CONCAT and TEXTJOIN functions6m 15s
  • Working with formulas in tables13m 2s
  • Locating data validation rules and violations7m 20s
  • Creating an Excel template7m 57s
  • Restoring missing column titles6m 41s
  • Creating a pick list dependent on another pick list6m 59s
  • Using command shortcuts with the Alt key5m 51s
  • Set up a macro for sorting dynamic data8m 42s
  • Use random number functions for sorting and creating sample data9m 57s
  • Use calcuated fields and calculated items in a PivotTable8m 57s
  • Replace characters by position with the REPLACE function5m 46s
  • Work with formulas in tables9m 3s
  • 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 data6m 42s
  • Creating an Excel template to simplify updating a monthly file7m 10s
  • Calculate dates efficiently using Excel's hidden function - DATEDIF7m 36s
  • Create dynamic sheet name references with the INDIRECT function6m 45s
  • Avoid errors and hidden data with the powerful AGGREGATE function7m 8s
  • Hide worksheets, row, columns, cells and other Excel elements7m 26s
  • Use slicers and charts together for dynamic presentations9m 4s
  • Save a chart as a template: Use the template for current or new charts6m 2s
  • MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions8m 12s
  • Adjust a chart's source data and adjust its series order9m 7s
  • 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 objects6m 32s
  • How and when to use the 10 rounding functions in Excel13m 26s
  • Calculate faster with the AutoSum button and AutoSum keystroke shortcut6m 54s
  • How to use mixed cell references8m 25s
  • Activate the Speak On Enter and Speak Cells features5m 38s
  • Accelerate data entry with five special techniques12m 8s
  • Insert a text box or shape and link a cell's content to it6m 58s
  • Use Watch Window and other techniques to track changing cells8m 21s
  • How to create time interval entries11m 39s
  • How to create frequency tabulations and distributions8m 10s
  • Create an expanded list from a summary using PivotTable techniques7m 25s
  • Solve matching issues with matching phone numbers and SS numbers10m
  • Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative7m 27s
  • Use outlining tools to quickly expand and collapse data for dynamic presentations9m 19s
  • Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting9m 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 formats8m 18s
  • Use the Subtotal command to analyze data with single- or multiple-level subtotals9m 15s
  • Work with MAX, MAXIFS, LARGE, and related functions8m 14s
  • Use the dynamic TODAY and NOW functions for real-time up-to-date calculations9m 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 columns8m 18s
  • Working with hidden data when copying cells and creating charts10m 58s
  • Use conditional formatting data bars to accentuate negative data4m 16s
  • Creative use of sparklines in merged cells with axes7m 1s
  • Copy formats quickly using dragging techniques and the Format Painter5m 25s
  • Displaying multiple worksheets and workbooks together10m 13s
  • Tips for creating and updating sample data11m 1s
  • Use conditional formatting to overcome formatting limitations of the IF function8m 54s
  • Use VLOOKUP, MATCH, and INDEX functions with array formulas10m 38s
  • Summarize data from different worksheets with a PivotTable7m 20s
  • AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas6m 59s
  • Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions8m 40s
  • Use custom formulas in data validation to keep out bad data13m 18s
  • Dealing with circular errors8m 20s
  • Tips for creating charts quickly6m 56s
  • Creating heat maps using conditional formatting8m 31s
  • Using the INDEX function to extract data by row and column11m 1s
  • Displaying tips when using Excel in presentations6m 23s
  • The Wrap Text, Merge and Center, and Indent options9m 2s
  • Using fill effects (gradients, patterns, styles) for colorful cell background variations5m 10s
  • Working with multiple worksheets simultaneously8m 42s
  • Exploring font choices not found on the Home tab4m 2s
  • Using WordArt for special titles and headings4m 33s
  • Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions7m 34s
  • Borders and gridlines: Exploring variations, options, and differences8m 24s
  • New Excel 2016 chart types: Tree map and sunburst7m 29s
  • Freezing column and row titles7m 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 3654m 3s
  • Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character6m 1s
  • Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!9m 39s
  • Creating cross-totals with the SUMIFS function and mixed references5m 50s
  • New Excel 2016 chart types: Histogram, Pareto, and box, and whisker10m 8s
  • Using the AND and OR functions independently or within IF functions9m 58s
  • Vertical and horizontal alignment settings and orientation options7m 12s
  • Sorting tips and shortcuts8m 40s
  • A look at new chart types in Excel 2016: Waterfall6m 57s
  • Work with formulas and formats: Decimals and fractions5m 42s
  • Creating mixed reference formulas; converting to a table; applying conditional formatting8m 6s
  • Control gridlines in charts and on worksheets7m 45s
  • Use the INDIRECT function with intersection formulas and range names to extract data6m 34s
  • Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes7m 14s
  • Control phone number and postal code formats using built-in options or customized formats7m 40s
  • Change the default Excel chart type; create and use chart templates6m 13s
  • Create your own customized date and time formats7m 31s
  • Create on-screen warnings and reminders with comments or data validation messages6m 18s
  • Use REPLACE for formats only, for data only, or for both6m 11s
  • Create numeric formats: Display in thousands or millions11m 40s
  • Converting dates like 20102006 into usable date entries4m 25s
  • Create custom lists for letter series like A to Z6m 26s
  • Freeze Panes and Split5m 30s
  • NETWORKDAYS.INTL and WORKDAY.INTL5m 29s
  • Calculate % of change5m 41s
  • Fill in all blank cells within a range with either formatting or data4m 13s
  • Use the COUNT and COUNTA functions4m 19s
  • Use workbook protection to prevent use of sheet commands5m 27s
  • Rank data with the RANK and RANK.AVG functions5m 37s
  • Use nonstandard fiscal years and quarters in PivotTables5m 35s
  • Identify or extract unique entries in a list5m 22s
  • Keyboard, mouse, and command techniques for viewing worksheets5m 18s
  • Create artistic charts with random numbers7m 23s
  • Extract day, month, and year from date fields5m 7s
  • Compare data with EXACT, FIND, and SEARCH functions4m 58s
  • How to covert ROMAN numberals4m 25s
  • Use range names for more readable formulas5m 38s
  • Customize your Quick Access Toolbar6m 7s
  • Conditional formatting based on date proximity4m 51s
  • How to adjust names5m 45s
  • Differences and limitations of converting data to a table5m 17s
  • Avoid the #DIV/0 error message4m 56s
  • Explore formatting options not available on the Home tab4m 25s
  • Control table formatting with custom formats3m 12s
  • Use date functions for age and tenure calculations5m 23s
  • Avoid unintentional entries when typing code numbers4m 29s
  • Sorting by moving columns4m 16s
  • Calculating cumulative totals3m 52s
  • Using the CONVERT function for different numbering systems4m 56s
  • Creating an automatically expanding chart by basing it on a table4m 24s
  • Keystroke shortcuts using the Alt key5m 20s
  • Using the Solver Add-in4m 29s
  • Column widths, row heights, merging cells, and related formatting issues5m 1s
  • Adjusting default layouts and date grouping in PivotTables4m 14s
  • Auditing cell content with Watch Window and dependent cell formulas4m 21s
  • Use the LEN and REPT functions for specialized cell testing and display options4m 4s
  • Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters5m 6s
  • Create double-spaced and triple-spaced printouts while repeating column headings4m 13s
  • Helpful keystroke shortcuts5m 3s
  • Identify weekdays and weekend days in data4m 50s
  • Use chart and filter for presentations4m 9s
  • Create picture links5m 37s
  • How to use the error-checking rules in Excel4m 59s
  • Protect worksheets and lock cells5m 24s
  • Use mixed addresses in Excel formulas5m 35s
  • Rapid filtering with Filter by Selection3m 45s
  • Display large values5m 16s
  • Tracking down conditional formatting and data validation rules5m 42s
  • Transposing data and using the TRANSPOSE function5m 43s
  • Displaying gridlines, borders, and column/row headings when printing4m 37s
  • Exploring some of the 200-plus SmartArt graphic options4m 1s
  • Using the CEILING and FLOOR functions for specialized rounding needs5m 16s
  • Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners5m 39s
  • Tabulating totals with the VLOOKUP function and array constants5m 12s
  • Working with array formulas more easily4m 23s
  • Using the new UNIQUE function to count and copy unique list entries3m 36s
  • Creating and updating sample data5m 43s
  • Format macros to make you a more efficient Excel user5m 23s
  • Use the new SORT and SORTBY functions to extract sorted lists5m 44s
  • Use themes to adjust worksheet colors, fonts, and effects3m 42s
  • Calculate loan payments and investments with PMT and FV functions6m 16s
  • Use the XLOOKUP function to replace VLOOKUP5m 23s
  • Chart display options with blank cells in source data4m 25s
  • Adjust Conditional Formatting rules by altering percentage breakpoints4m 36s
  • Discover new formula capabilities with new functions and dynamic arrays5m 6s
  • Sort or filter data based on color font or cell color background5m 50s
  • Simplify the use of special characters and symbols5m 24s
  • Select from over 800 icons to enliven worksheets6m 29s
  • Use the new RANDARRAY function that replaces RAND and RANDBETWEEN6m 26s
  • How and when to use an area chart4m 16s
  • Insert colorful images with the People Graph Add-in5m 37s
  • Use formulas to create interactive charts5m 32s
  • Track variables using the Scenario Manager4m 43s
  • Get totals quickly without creating formulas5m 2s
  • Use column or row references to create dynamic formulas4m 31s
  • Overcoming obstacles when working with dates in charts4m 45s
  • Create map-type charts based on geographical locations4m 20s
  • Techniques for creating date series4m 42s
  • Extract filtered data with data validation and the FILTER function4m 34s
  • Use Find and Replace to change cell contents and formats6m 12s
  • Add formula tools and symbols to the Quick Access Toolbar5m 12s
  • Change PivotTable settings for titles and summaries5m 58s
  • Use the Excel filtering capability for dates4m 57s
  • Use worksheet names in formulas5m 31s
  • Use data validation rules with special phone and social security formats5m 44s
  • Work with time calculations in formulas5m 14s
  • Prevent and locate duplicate worksheet entries4m 41s
  • Look forward and backward using EDATE and other date functions5m 37s
  • Display and highlight worksheet formula cells5m 46s
  • Split or join columnar data with Text to Columns or Flash Fill4m 55s
  • Highlight milestone data with conditional formatting and cumulative formulas5m 38s
  • Use the XMATCH function to replace MATCH3m 43s
  • Work with hidden and visible data in filtered and subtotaled lists5m 54s

Recommended video tutorials from YouTube.

  • Becoming more productive with these ten tiny tips | Excel Tips | lynda.com
  • Want to be even more productive in Excel? Dennis Taylor reveals 10 tiny tips to speed up your workflow and your workday. Watch more Excel tutorials at ...

  • DateTime : 2015-06-22 18:21:05
  • Source : LinkedIn Learning
  • Quick formatting tips | Excel tips | lynda.com
  • Increase your efficiency in Excel! Dennis Taylor shows you various shortcuts for formatting in this tutorial. Watch the follow-up movies within this series at ...

  • DateTime : 2015-01-20 19:00:00
  • Source : LinkedIn Learning
  • How to Make a Weekly Schedule in Excel - Tutorial
  • Excel tutorial on how to make a weekly schedule in Excel to keep you organized. We'll make a weekly planner so that you can schedule meetings by selecting ...

  • DateTime : 2019-03-25 11:45:01
  • Source : YAcosta Solutions
HELP THE AUTHOR

Please consider buying this course - Excel Tips Weekly directly from the author - Dennis Taylor. This way you could help the author create more great content, also you may get personal help.

The links being shared are only for poor students who really cannot afford to pay. So, if you are capable of paying please do consider it once before trying the free download links.

Categorised in: , , , , ,

Kindly note, we have recently migrated to a new server. In case of download links not working at all it means that we are undergoing maintenance at the backend. In such case please try after 24 hours. Also make sure your internet connection is persistant else the file may endup corrupted.