Del curso: Excel Tips Weekly
Desbloquea este curso con un periodo de prueba gratis
Únete hoy para acceder a más de 23.100 cursos impartidos por expertos del sector.
Insert colorful images with the People Graph Add-in - Tutorial de Microsoft Excel
Del curso: Excel Tips Weekly
Insert colorful images with the People Graph Add-in
- [Instructor] What we're seeing on the screen here is a relatively new feature. It's an add-in called People Graph, and it's well outside the scope of the capability of a typical Excel chart. This is a little different. It's called an add-in, and so, if you want to use this feature, you'll need to have the Office 365 version of Excel, and when you got the Insert tab and go to My Add-ins, you probably will not see it at least initially. So, you will see other options here for adding this feature called People Graph. I've added it here. I've got an existing People Graph chart right here. I'm going to click on this border and actually get rid of it, but we're about to see how we can create one of these People Graph charts and associate it with the data like is being done here. So, I'll simply delete this and essentially start over. And we don't highlight the data first as we do with charts. We simply go to that Insert tab…
Practica mientras aprendes con los archivos de ejercicios.
Descarga los archivos que el instructor utiliza para enseñar el curso. Sigue las instrucciones y aprende viendo, escuchando y practicando.
- 164_Percent_change_and_Goal_Seek.zip
- Ex_Files_Excel_Tips_Weekly_2018_Q2.zip
- 166_COUNT_COUNTA_and_Status_Bar.zip
- 165_Fill_in_Blanks.zip
- Ex_Files_Excel_Tips_Weekly_2018_Q3.zip
- 162_Freeze_Panes_and_Split_Screens.zip
- 203_Mixed_Cell_Addresses.zip
- 202_Worksheet_Protection.zip
- 161_Custom_Lists.zip
- 201_Error_Checking_Indicators.zip
- 205_Displaying_Large_Values.zip
- 163_NETWORKDAYS_and_WORKDAY.zip
- 204_Filter_by_Selection.zip
- 160_Date_Format_Conversions.zip
- 159_Number_Formats.zip
- 200_Linking_Pictures.zip
- 199_Charts_and_Filters.zip
- 198_Weekdays_and_Weekends.zip
- 197_Helpful_Keystroke_Shortcuts.zip
- 157_Comments_and_Reminders.zip
- 156_Date_Time_Formats.zip
- 196_Double_and_Triple_Spaced_Printing.zip
- 195_TRIM_and_CLEAN.zip
- 194_LEN_and_REPT.zip
- 158_Replace_Format_or_Content.zip
- 155_Default_Chart_Type_and_Chart_Templates.zip
- 154_Phone_and_ZipCode_Formats.zip
- 192_PivotTable_Settings.zip
- 151_Chart_gridlines_and_borders.zip
- 150_Mixed_References.zip
- 153_Expand_Collapse_PivotTables.zip
- 190_Solver.zip
- 152_INDIRECT_Intersection_RangeNames.zip
- 191_Columns_Widths.zip
- 149_Decimals_and_Fractions.zip
- 194_Watch_Window.zip
- 189_Alt_Key_Shortcuts.zip
- 123_Book1.zip
- 186_Sort_by_Moving_Columns.zip
- 185_Unintentional_Entries.zip
- 188_CONVERT_Function.zip
- 187_Cumulative_Totals.zip
- 184_Date_Calculations.zip
- 124_Quick_Charts.zip
- 183_New_Table_Style.zip
- 180_Table_Differences.zip
- 179_Date_Proximity_Formatting_final.zip
- 182_FormattingOptions.zip
- 181_Avoiding_DIV_Error.zip
- 126_INDEX_Function.zip
- 127_Display_Tips.zip
- 128_Wrap_text_Merge_Indent.zip
- 129_Fill_Effects.zip
- 125_Heat_Maps.zip
- 134_Two_Way_Lookups.zip
- 178_Adjusting_Names.zip
- 130_Multiple_Worksheets.zip
- 131_Other_Font_Options.zip
- 132_WordArt_Variations.zip
- 133_Weekday_Weekend.zip
- 175_ROMAN_ARABIC.zip
- 174_EXACT_FIND_SEARCH_Functions.zip
- 177_Customize_the_Quick_Access_Toolbar.zip
- 176_Range_Names.zip
- 135_Borders_Gridlines.zip
- 173_YEAR_MONTH_DAY_WEEKDAY.zip
- 172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip
- 189_Chart_based_on_a_Table.zip
- 169_PivotTable_Date_Grouping.zip
- 171_Zoom_and_Display_Variations.zip
- 170_Unique_and_Duplicate_Data.zip
- 168_Ranking_Data.zip
- 167_Excel_Sheet_Commands.zip
- Ex_Files_Excel_Tips_Weekly_2018_Q1.zip
- 206_ConditionalFormatting_and_DataValidation.zip
- 207_CheckBox_ConditionalFormatting.zip
- 208_Transpose.zip
- 209_Borders_Gridlines_Printing.zip
- 210_SmartArt.zip
- 211_GoTo_Special.zip
- 212_CEILINGandFLOOR.zip
- 213_Shapes_and_Stars.zip
- 214_Array_Constants_withVLOOKUP.zip
- 215_AdvancedFilter.zip
- 216_ArrayFormulaUpdates.zip
- 217_UNIQUE_function.zip
- 218_Sample_Data.zip
- 219_Utility_Macros.zip
- 220_SORT_and_SORTBY_Functions.zip
- 221_Themes.zip
- 222_Financial_Functions.zip
- 223_BlankCellsInCharts.zip
- 224_CondFormattingBreakpoints.zip
- 225_New_Formulas.zip
- 226_Sort_by_Color.zip
- 227_Special_Characters.zip
- 228_Icons.zip
- 229_Random_Functions.zip
- 230_Area_Charts.zip
- 231_People_Graph.zip
- 232_GrowingChart.zip
- 233_ScenarioManager.zip
- 234_Status_Bar.zip
- 235_Columns_and_Rows.zip
- 236_Dates_in_Charts.zip
- 237_Geographic_Maps.zip
- 238_Date_Time_Series.zip
- 239_Data_Validation_and_Filter.zip
- 240_Find_Select.zip
- 241_AverageCountSubscript.zip
- 242_CopyFormats.zip
- 243_XLOOKUP_Function.zip
- 244_PivotTable_Settings.zip
- 245_FilterYearDay.zip
- 246_Sheet_Names.zip
- 247_Phone_ZipFormats.zip
- 248_Time_Math.zip
- 249_Prevent_Locate_Duplicates.zip
- 250_EDate_EMonth_DatedIF.zip
- 251_Find_Highlight_Formula_cells.zip
- 252_Text_Columns_Flash_Fill.zip
- 253_Cumulative_Formulas.zip
- 254_XMATCH_Function.zip
- 255_Hidden_Visible_Data.zip
- 256_Macro_Highlight_Formula_Cells.zip
- 257_TODAY_NOW_Date_Functions.zip
- 258_Prevent_Duplicates.zip
- 259_Hide_cells_rows_columns_sheets.zip
- 260_Align_Arrange_Rotate_Shapes.zip
- 261_Worksheet_Statistics.zip
- 262_Re_scaling_Column_and_Line_Charts.zip
- 263_Fill_Justify_Wrap_Text.zip
- 264_Names_Based_On_Column_Row_Headings.zip
- 265_SUBSTITUTE_and_REPLACE_Functions.zip
- 266_Buttons_for_Conditional_Formatting.zip
- 267_Wildcards_Part_1_Filter_and_Commands.zip
- 268_Wildcards_Part_2_Functions_.zip
- 269_IFS_Function.zip
- 270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip
- 271_Protect_Cell_Ranges.zip
- 272_Geography_Data.zip
- 273_SEQUENCE_function.zip
- 274_LEN_SUBSTITUTE_and_TRIM_functions.zip
- 275_List_Box.zip
- 276_COUNT_COUNTA_and_COUNTBLANK_functions.zip
- 277_Banded_Rows_or_Columns.zip
- 278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip
- 279_SWITCH_function.zip
- 280_Chart_Design_Tools.zip
- 281_PivotTable_Analysis.zip
- 282_Subtotal.zip
- 283_AGGREGATE_Function.zip
- 284_The_F9_Key.zip
- 285_XLOOKUP_XMATCH.zip
- 286_Paste_Special_Options.zip
- 287_Data_Entry_Tips.zip
- 288_LET_function.zip
- 289_Create_Worksheets_Fast.zip
- 290_MovingAverage.zip
- 291_Error_Checking_Functions.zip
- 292_Line_Wrap_and_Wrap_Text.zip
- 293_Cell_Colors_Patterns_Effects.zip
- 294_Dynamic_Arrays.zip
- 295_Fonts.zip
- 296_3D_Formulas.zip
- 297_Date_Formats.zip
- 298_Cell_Precedents.zip
- 299_Date_Controls_with_Data_Validation.zip
- 300_Managing_Duplicate_Data.zip
- 301_New_Data_Types.zip
- 302_FILTER_and_UNIQUE_functions.zip
- 303_UPPER_lower_Proper.zip
- 304_Custom_Filter.zip
- 26_01_Column_and_Bar_Charts.zip
- 26_02_Powers_and_Roots.zip
- 26_03_ISTEXT_ISNUMBER_ISNONTEXT.zip
- 26_04_Function_Names.zip
- 26_05_SUM_SUMPRODUCT_SUMIF.zip
- 26_06_Binary_Octal_Decimal_Hexadecimal.zip
- 26_07_Numeric_Formatting.zip
- 26_08_Dates_and_the_1930_2029_split.zip
- 26_09_Wildcard_lookups_XLOOKUP_and_XMATCH.zip
- 26_10_Slicers_Analysis.zip
- 26_11_Heat_Maps.zip
- 26_12_Validation_with_UNIQUE_and_SORT_functions.zip
- 26_13_Clustered_vs_Stacked_Chart_Types.zip
- 27_01_XLOOKUP.zip
- 27_02_Update_Date_Entries.zip
- 27_03_Eliminate_Spaces_and_Special_Characters.zip
- 27_04_Create_Range_Names_From_Headings.zip
- 27_05_Date_Series_Creation.zip
- 27_06_LAMBDA_Function.zip
- 27_07_Goal_Seek.zip
- 27_08_Sort_by_Custom_List.zip
- 27_09_INDIRECT_function.zip
- 27_10_Holiday_Calculations.zip
- 27_11_Paste_Special_Drag_Options.zip
- 27_12_SS_Numbers.zip
- 28_01_Five_Invaluable_Keystroke_Shortcuts.zip
- 28_02_New_Formula_Techniques.zip
- 28_03_Time_differencees.zip
- 28_04_Zoom_Techniques.zip
- 28_05_Outlining_Tools.zip
- 28_06_Analyze_Data.zip
- 28_07_UNIQUE_Unique_vs_Distinct.zip
- 28_08_Screen_Snip.zip
- 28_09_Sunburst_Charts.zip
- 28_10_Shadow_Glow_Reflection.zip
- 28_11_Printing_Tips.zip
- 29_01_Data_Validation_Multiple_Criteria.zip
- 29_02_Quick_Access_Toolbar_QAT_Tips.zip
- 29_03_Treemap_Charts.zip
- 29_04_Quick_Analysis_Button.zip
- 29_05_Dragging_Number_Cells.zip
- 29_06_Analyze_Sales_using_the_IF_MAX_and_COUNTIF_functions.zip
- 29_07_Hide_Unhide_Worksheets.zip
- 29_08_Fill_Justify_Re_wrap_text.zip
- 29_09_Date_Series_15th_and_Month_End.zip
- 29_10_Filling_Blank_Cells.zip
- 29_11_Sparklines_and_Conditional_Formatting.zip
- 29_12_Transpose.zip
- 30_01_Emojis_and_Pictures.zip
- 30_02_Advanced_Filter.zip
- 30_03_Combo_Charts.zip
- 30_04_MID_SEQUENCE_LEN_Functions.zip
- 30_05_PivotTable_Settings.zip
- 30_06_Navigation.zip
- 30_07_DATEDIF_Function.zip
- 30_08_Word_Art_Transform.zip
- 30_09_Dates_Months_Weekdays.zip
- 30_10_Linkage_Formulas.zip
- 30_11_XLOOKUP_Solutions.zip
- 30_12_TREND_and_GROWTH.zip
- 30_13_Stock_Charts.zip
- 31_01_Gridlines_On_Off.zip
- 31_02_Formulas_Changes.zip
- 31_03_Dependencies.zip
- 31_04_Replace_Formats.zip
- 31_05_Option_Buttons_and_Check_Boxes.zip
- 31_06_SORT_and_FILTER_Functions.zip
- 31_07_Moving_Average.zip
- 31_08_Data_Validation.zip
- 31_09_Picture_Links.zip
- 31_10_SUMIF_and_SUMIFS.zip
- 31_11_Multiple_PivotTables_from_one_source.zip
- 31_12_Conditional_Formatting_Icons.zip
- IMAGE_Function.zip
- 378_TOROW_and_TOCOL_functions.zip
- 379_Formulas_with_hidden_rows.zip
- 380_Bubble_charts.zip
- 381_CONCAT_TEXTJOIN_TEXTSPLIT_functions.zip
- 382_Shrink_to_fit_options.zip
- 383_Precedent_Cells.zip
- 384_Formula_editing.zip
- 385_Status_Bar_Control.zip
- 386_Sorting_Tips.zip
- 387_TEXTBEFORE_TEXTAFTER.zip
- 388_Quick_Chart_Titles.zip
- 390_TAKE_DROP_FILTER_SORTBY.zip
- 391_Pivot_Table_Detail.zip
- 392_Right_click_Filtering.zip
- 393_WRAPROWS_and_WRAPCOLS_Functions.zip
- 394_Dates_and_Times.zip
- 395_Creating_Charts_Quickly.zip
- 396_CHOOSEROWS_and_CHOOSECOLS_Functions.zip
- 397_Decimals_Rounding_Formulas.zip
- 398_Pivot_Table_Formatting.zip
- 399_DB_Functions.zip
- 400_Pie_Charts.zip
- 401_Quick_Sorting.zip
- 402_Charts_to_Pictures.zip
- 402_Tracking_Cell_Types.zip
- 403_BYROW_and_BYCOL_Functions.zip
- 404_Formula_Shortcuts.zip
- 405_3_D_Column_and_Bar_Chart.zip
- 406 _VSTACK_and_HSTACK_functions.zip
- 407_Calculating_by_Day_of_the_Week.zip
- 408_XMATCH_and_XLOOKUP.zip
- 409_Select_Cell_Ranges.zip
- 410_Inserting_Symbols.zip
- 411_Using_IS_Information_functions.zip
- 412_Using_LEFT_MID_TEXT_functions.zip
- 413_Edit_Go_To_Options.zip
- 414_Fiscal_Year_Calculations.zip
- 415_SORT_Left_Right.zip
- 416_Conditional_Formatting_Analysis.zip
- 417_Indenting.zip
- 418_FILTER_AND_OR_Functions.zip
- 419_Shapes_Linked_to_Worksheet_Cells.zip
- 420_Slicers_with_Charts.zip
- 421_Sort_by_Day_of_Month.zip
- 422_Wildcards.zip
- 423_FIND_SEARCH_COUNT_Functions.zip
- 424_Histogram_Charts.zip
- 425_AND_and_OR_Functions.zip
- 426_Flipping_Lists.zip
- 427_TEXTJOIN_CONCAT.zip
- 428_Excel_Options.zip
- 429_Alt_key_shortcuts.zip
- 430_COUNTIF_family.zip
- 431_Scatter_XY_Charts.zip
- 432_Tracking_Data_Validation.zip
- 433_AGGREGATE_Function.zip
- 434_Duplicate_Data.zip
- 435_SEQUENCE_Function.zip
- 436_Tables_Validation_XLOOKUP_Chart.zip
- 437_Stacked_Column_and_Area_Charts.zip
- 438_FILTER_SORT_and_CHOOSECOLS_functions.zip
- 440_New_Office_Theme.zip
- 441_TOCAL_LARGE_SMALL.zip
- 442_Chart_Quick_Layout_Options.zip
- 443_Display_and_Presentation_Tips.zip
- 444_WORKDAY_NETWORKDAYS_SEQUENCE.zip
- 445_Column_and_Row_References.zip
- 446_Accessibility.zip
- 447_XLOOKUP_multiple_column_return.zip
- 448_Charts_with_Filters_and_Slicers.zip
- 449_SORT_and_SORTBY_functions.zip
- 450_Navigation_Tools.zip
- 451_Using_RANK_and_LET_functions.zip
- 452_Conditional_Formatting_across_Rows.zip
- 453_PivotTable_Dates.zip
- 454_TODAY_and_NOW_Functions.zip
- 455_Freeze_and_Split.zip
- 456_Rounding_functions_CEILING_and_FLOOR.zip
- 457_Data_Bars.zip
- 458_AutoSum_Tips.zip
- 459_INDIRECT_Function.zip
- 460_Custom_Lists.zip
- 461_Split_Consolidate.zip
- 462_Subtotals.zip
- 463_Random_Functions.zip
- 464_Ten_Quick_Tips.zip
- 465_GROUPBY_and_PIVOTBY_Functions.zip
- 466_Formulas_based_on_different_worksheets.zip
- 467_Command_Locator.zip
- 468_Check_Box.zip
- 469_Paste_Values.zip
Contenido
-
-
-
(Bloqueado)
Hide and unhide worksheets securely6 min 6 s
-
(Bloqueado)
Resizing, moving, copying, and manipulating charts and other objects10 min 17 s
-
(Bloqueado)
Using list boxes and combo boxes to facilitate forms creation7 min 36 s
-
(Bloqueado)
Using the FORMULATEXT and N functions for worksheet and formula documentation5 min 53 s
-
(Bloqueado)
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells7 min 55 s
-
(Bloqueado)
Summarizing data from diverse ranges with Data > Consolidate9 min 33 s
-
(Bloqueado)
Using check boxes and conditional formatting together for dynamic displays5 min 58 s
-
(Bloqueado)
Becoming more productive with these 10 tiny tips you'll use often8 min
-
(Bloqueado)
Transposing data and charts for a different perspective on your data8 min 57 s
-
(Bloqueado)
Applying conditional formatting across rows of data6 min 43 s
-
(Bloqueado)
Exploring various layouts for your PivotTable4 min 27 s
-
(Bloqueado)
Splitting and consolidating workbooks6 min 47 s
-
(Bloqueado)
Using date and time as metrics in a PivotTable6 min 53 s
-
(Bloqueado)
Adding illustrations to your workbook12 min 7 s
-
(Bloqueado)
Using a pick list, VLOOKUP, table, and chart together8 min 5 s
-
(Bloqueado)
Using formulas to calculate values across worksheets and workbooks11 min 12 s
-
(Bloqueado)
Dynamically presenting data via chart slicers7 min 15 s
-
(Bloqueado)
Parsing your data to create unique lists3 min 21 s
-
(Bloqueado)
Using the REPT function to represent data visually3 min 6 s
-
(Bloqueado)
Using source data from a table to make your PivotTable more dynamic7 min 8 s
-
(Bloqueado)
Accelerating Cut, Copy, Paste, and Insert tasks7 min 26 s
-
(Bloqueado)
Increasing your productivity with custom lists5 min 9 s
-
(Bloqueado)
Highlighting PivotTable results with conditional formatting6 min 10 s
-
(Bloqueado)
Customizing templates to fit your unique needs6 min 6 s
-
(Bloqueado)
Creating dynamic charts with in-cell conditional formatting3 min 26 s
-
(Bloqueado)
Enhancing table filtering with slicers5 min 23 s
-
(Bloqueado)
Converting charts into pictures4 min 51 s
-
(Bloqueado)
Custom grouping in PivotTables4 min 31 s
-
(Bloqueado)
Quick formatting tips8 min 9 s
-
(Bloqueado)
The top five unknown but useful keyboard shortcuts6 min 17 s
-
(Bloqueado)
Using the TREND and GROWTH functions for projecting future results5 min 54 s
-
(Bloqueado)
Using scroll bars and spin buttons to facilitate forms creation10 min 1 s
-
(Bloqueado)
Creating colorful 3D buttons for worksheet annotation and macro buttons6 min 52 s
-
(Bloqueado)
Calculating with hours, minutes, and times of day11 min 2 s
-
(Bloqueado)
Tracking down cell dependencies across multiple worksheets and workbooks6 min 24 s
-
(Bloqueado)
Discovering time-saving tools in the Go To Special feature11 min 22 s
-
(Bloqueado)
Using Go To Special6 min 1 s
-
(Bloqueado)
Reducing data entry time by expanding AutoCorrect options6 min 10 s
-
(Bloqueado)
Setting up custom views for quick access to different worksheet displays6 min 30 s
-
(Bloqueado)
Using hyperlinks for rapidly switching worksheet locations and jumping to websites7 min 18 s
-
(Bloqueado)
Controlling worksheet security by allowing selected users to edit specific cell ranges7 min 22 s
-
(Bloqueado)
Using option buttons, group boxes, and checkboxes to facilitate forms creation8 min 7 s
-
(Bloqueado)
Exploring what-if scenarios using Goal Seek9 min 55 s
-
(Bloqueado)
Creating text, numerical, date, and time lists in a flash6 min 54 s
-
(Bloqueado)
Creating variable conditional formatting rules8 min 4 s
-
(Bloqueado)
Handling dates with unusual formats6 min 5 s
-
(Bloqueado)
Ten quick tips to use daily: formulas, formatting, and accessing commands6 min 32 s
-
(Bloqueado)
Using wildcards (asterisk, tilde, and question mark)11 min
-
(Bloqueado)
Custom formats using asterisk, semicolon, and brackets13 min
-
(Bloqueado)
Meeting unusual filtering needs via Advanced Filter5 min 28 s
-
(Bloqueado)
Create an organization chart8 min 56 s
-
(Bloqueado)
Two-way lookup using the MATCH and INDEX functions11 min 28 s
-
(Bloqueado)
Using Excel error-checking functions10 min 37 s
-
(Bloqueado)
Custom formats, relative addressing, and conditional formatting8 min 26 s
-
(Bloqueado)
Auditing9 min 1 s
-
(Bloqueado)
Adding comments and shapes7 min 35 s
-
(Bloqueado)
Drawing borders and border grids5 min 45 s
-
(Bloqueado)
Building a flexible monthly table using functions11 min 44 s
-
(Bloqueado)
Adding pictures as worksheet backgrounds4 min 15 s
-
(Bloqueado)
ADDRESS, ROW, and COLUMN functions8 min 8 s
-
(Bloqueado)
Join data with new CONCAT and TEXTJOIN functions6 min 15 s
-
(Bloqueado)
Working with formulas in tables13 min 2 s
-
(Bloqueado)
Locating data validation rules and violations7 min 20 s
-
(Bloqueado)
Creating an Excel template7 min 57 s
-
(Bloqueado)
Restoring missing column titles6 min 41 s
-
(Bloqueado)
Creating a pick list dependent on another pick list6 min 59 s
-
(Bloqueado)
Using command shortcuts with the Alt key5 min 51 s
-
(Bloqueado)
Set up a macro for sorting dynamic data8 min 42 s
-
(Bloqueado)
Use random number functions for sorting and creating sample data9 min 57 s
-
(Bloqueado)
Use calcuated fields and calculated items in a PivotTable8 min 57 s
-
(Bloqueado)
Replace characters by position with the REPLACE function5 min 46 s
-
(Bloqueado)
Work with formulas in tables9 min 3 s
-
(Bloqueado)
Keystroke shortcuts from A to Z: Using the Ctrl key16 min 16 s
-
(Bloqueado)
Use special tricks for working with dates in charts11 min 36 s
-
(Bloqueado)
Use a data form for data entry and exploring data6 min 42 s
-
(Bloqueado)
Creating an Excel template to simplify updating a monthly file7 min 10 s
-
(Bloqueado)
Calculate dates efficiently using Excel's hidden function - DATEDIF7 min 36 s
-
(Bloqueado)
Create dynamic sheet name references with the INDIRECT function6 min 45 s
-
(Bloqueado)
Avoid errors and hidden data with the powerful AGGREGATE function7 min 8 s
-
(Bloqueado)
Hide worksheets, row, columns, cells and other Excel elements7 min 26 s
-
(Bloqueado)
Use slicers and charts together for dynamic presentations9 min 4 s
-
(Bloqueado)
Save a chart as a template: Use the template for current or new charts6 min 2 s
-
(Bloqueado)
MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions8 min 12 s
-
(Bloqueado)
Adjust a chart's source data and adjust its series order9 min 7 s
-
(Bloqueado)
Use the OFFSET function for tabulating moving data11 min 23 s
-
(Bloqueado)
Alter numeric data without formulas10 min 19 s
-
(Bloqueado)
Use Flash Fill to rapidly combine or separate columnar data10 min 28 s
-
(Bloqueado)
Adjust banded-row formatting14 min 35 s
-
(Bloqueado)
Change the shape of comment boxes and other objects6 min 32 s
-
(Bloqueado)
How and when to use the 10 rounding functions in Excel13 min 26 s
-
(Bloqueado)
Calculate faster with the AutoSum button and AutoSum keystroke shortcut6 min 54 s
-
(Bloqueado)
How to use mixed cell references8 min 25 s
-
(Bloqueado)
Activate the Speak On Enter and Speak Cells features5 min 38 s
-
(Bloqueado)
Accelerate data entry with five special techniques12 min 8 s
-
(Bloqueado)
Insert a text box or shape and link a cell's content to it6 min 58 s
-
(Bloqueado)
Use Watch Window and other techniques to track changing cells8 min 21 s
-
(Bloqueado)
How to create time interval entries11 min 39 s
-
(Bloqueado)
How to create frequency tabulations and distributions8 min 10 s
-
(Bloqueado)
Create an expanded list from a summary using PivotTable techniques7 min 25 s
-
(Bloqueado)
Solve matching issues with matching phone numbers and SS numbers10 min
-
(Bloqueado)
Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative7 min 27 s
-
(Bloqueado)
Use outlining tools to quickly expand and collapse data for dynamic presentations9 min 19 s
-
(Bloqueado)
Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting9 min 59 s
-
(Bloqueado)
Create lists of all 2nd Tuesdays, last Tuesdays. and other date series10 min 44 s
-
(Bloqueado)
Create linkage formulas that refer to other worksheets and workbooks11 min 49 s
-
(Bloqueado)
Formula nesting: Using multiple functions in the same formula13 min 22 s
-
(Bloqueado)
Keyboard shortcuts for numeric formats8 min 18 s
-
(Bloqueado)
Use the Subtotal command to analyze data with single- or multiple-level subtotals9 min 15 s
-
(Bloqueado)
Work with MAX, MAXIFS, LARGE, and related functions8 min 14 s
-
(Bloqueado)
Use the dynamic TODAY and NOW functions for real-time up-to-date calculations9 min 24 s
-
(Bloqueado)
Use the FIND, MID, LEFT, and RIGHT functions10 min 38 s
-
(Bloqueado)
Flip the left-to-right order of columns with the INDEX function or sort by columns8 min 18 s
-
(Bloqueado)
Working with hidden data when copying cells and creating charts10 min 58 s
-
(Bloqueado)
Use conditional formatting data bars to accentuate negative data4 min 16 s
-
(Bloqueado)
Creative use of sparklines in merged cells with axes7 min 1 s
-
(Bloqueado)
Copy formats quickly using dragging techniques and the Format Painter5 min 25 s
-
(Bloqueado)
Displaying multiple worksheets and workbooks together10 min 13 s
-
(Bloqueado)
Tips for creating and updating sample data11 min 1 s
-
(Bloqueado)
Use conditional formatting to overcome formatting limitations of the IF function8 min 54 s
-
(Bloqueado)
Use VLOOKUP, MATCH, and INDEX functions with array formulas10 min 38 s
-
(Bloqueado)
Summarize data from different worksheets with a PivotTable7 min 20 s
-
(Bloqueado)
AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas6 min 59 s
-
(Bloqueado)
Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions8 min 40 s
-
(Bloqueado)
Use custom formulas in data validation to keep out bad data13 min 18 s
-
(Bloqueado)
Dealing with circular errors8 min 20 s
-
(Bloqueado)
Tips for creating charts quickly6 min 56 s
-
(Bloqueado)
Creating heat maps using conditional formatting8 min 31 s
-
(Bloqueado)
Using the INDEX function to extract data by row and column11 min 1 s
-
(Bloqueado)
Displaying tips when using Excel in presentations6 min 23 s
-
(Bloqueado)
The Wrap Text, Merge and Center, and Indent options9 min 2 s
-
(Bloqueado)
Using fill effects (gradients, patterns, styles) for colorful cell background variations5 min 10 s
-
(Bloqueado)
Working with multiple worksheets simultaneously8 min 42 s
-
(Bloqueado)
Exploring font choices not found on the Home tab4 min 2 s
-
(Bloqueado)
Using WordArt for special titles and headings4 min 33 s
-
(Bloqueado)
Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions7 min 34 s
-
(Bloqueado)
Borders and gridlines: Exploring variations, options, and differences8 min 24 s
-
(Bloqueado)
New Excel 2016 chart types: Tree map and sunburst7 min 29 s
-
(Bloqueado)
Freezing column and row titles7 min 48 s
-
(Bloqueado)
Use data validation to force entries to be uppercase or lowercase10 min 48 s
-
(Bloqueado)
Avoiding common chart distortions11 min 49 s
-
(Bloqueado)
Use the new funnel chart available in Excel 3654 min 3 s
-
(Bloqueado)
Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character6 min 1 s
-
(Bloqueado)
Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!9 min 39 s
-
(Bloqueado)
Creating cross-totals with the SUMIFS function and mixed references5 min 50 s
-
(Bloqueado)
New Excel 2016 chart types: Histogram, Pareto, and box, and whisker10 min 8 s
-
(Bloqueado)
Using the AND and OR functions independently or within IF functions9 min 58 s
-
(Bloqueado)
Vertical and horizontal alignment settings and orientation options7 min 12 s
-
(Bloqueado)
Sorting tips and shortcuts8 min 40 s
-
(Bloqueado)
A look at new chart types in Excel 2016: Waterfall6 min 57 s
-
(Bloqueado)
Work with formulas and formats: Decimals and fractions5 min 42 s
-
(Bloqueado)
Creating mixed reference formulas; converting to a table; applying conditional formatting8 min 6 s
-
(Bloqueado)
Control gridlines in charts and on worksheets7 min 45 s
-
(Bloqueado)
Use the INDIRECT function with intersection formulas and range names to extract data6 min 34 s
-
(Bloqueado)
Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes7 min 14 s
-
(Bloqueado)
Control phone number and postal code formats using built-in options or customized formats7 min 40 s
-
(Bloqueado)
Change the default Excel chart type; create and use chart templates6 min 13 s
-
(Bloqueado)
Create your own customized date and time formats7 min 31 s
-
(Bloqueado)
Create on-screen warnings and reminders with comments or data validation messages6 min 18 s
-
(Bloqueado)
Use REPLACE for formats only, for data only, or for both6 min 11 s
-
(Bloqueado)
Create numeric formats: Display in thousands or millions11 min 40 s
-
(Bloqueado)
Converting dates like 20102006 into usable date entries4 min 25 s
-
(Bloqueado)
Create custom lists for letter series like A to Z6 min 26 s
-
(Bloqueado)
Freeze Panes and Split5 min 30 s
-
(Bloqueado)
NETWORKDAYS.INTL and WORKDAY.INTL5 min 29 s
-
(Bloqueado)
Calculate % of change5 min 41 s
-
(Bloqueado)
Fill in all blank cells within a range with either formatting or data4 min 13 s
-
(Bloqueado)
Use the COUNT and COUNTA functions4 min 19 s
-
(Bloqueado)
Use workbook protection to prevent use of sheet commands5 min 27 s
-
(Bloqueado)
Rank data with the RANK and RANK.AVG functions5 min 37 s
-
(Bloqueado)
Use nonstandard fiscal years and quarters in PivotTables5 min 35 s
-
(Bloqueado)
Identify or extract unique entries in a list5 min 22 s
-
(Bloqueado)
Keyboard, mouse, and command techniques for viewing worksheets5 min 18 s
-
(Bloqueado)
Create artistic charts with random numbers7 min 23 s
-
(Bloqueado)
Extract day, month, and year from date fields5 min 7 s
-
(Bloqueado)
Compare data with EXACT, FIND, and SEARCH functions4 min 58 s
-
(Bloqueado)
How to covert ROMAN numberals4 min 25 s
-
(Bloqueado)
Use range names for more readable formulas5 min 38 s
-
(Bloqueado)
Customize your Quick Access Toolbar6 min 7 s
-
(Bloqueado)
Conditional formatting based on date proximity4 min 51 s
-
(Bloqueado)
How to adjust names5 min 45 s
-
(Bloqueado)
Differences and limitations of converting data to a table5 min 17 s
-
(Bloqueado)
Avoid the #DIV/0 error message4 min 56 s
-
(Bloqueado)
Explore formatting options not available on the Home tab4 min 25 s
-
(Bloqueado)
Control table formatting with custom formats3 min 12 s
-
(Bloqueado)
Use date functions for age and tenure calculations5 min 23 s
-
(Bloqueado)
Avoid unintentional entries when typing code numbers4 min 29 s
-
(Bloqueado)
Sorting by moving columns4 min 16 s
-
(Bloqueado)
Calculating cumulative totals3 min 52 s
-
(Bloqueado)
Using the CONVERT function for different numbering systems4 min 56 s
-
(Bloqueado)
Creating an automatically expanding chart by basing it on a table4 min 24 s
-
(Bloqueado)
Keystroke shortcuts using the Alt key5 min 20 s
-
(Bloqueado)
Using the Solver Add-in4 min 29 s
-
(Bloqueado)
Column widths, row heights, merging cells, and related formatting issues5 min 1 s
-
(Bloqueado)
Adjusting default layouts and date grouping in PivotTables4 min 14 s
-
(Bloqueado)
Auditing cell content with Watch Window and dependent cell formulas4 min 21 s
-
(Bloqueado)
Use the LEN and REPT functions for specialized cell testing and display options4 min 4 s
-
(Bloqueado)
Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters5 min 6 s
-
(Bloqueado)
Create double-spaced and triple-spaced printouts while repeating column headings4 min 13 s
-
(Bloqueado)
Helpful keystroke shortcuts5 min 2 s
-
(Bloqueado)
Identify weekdays and weekend days in data4 min 50 s
-
(Bloqueado)
Use chart and filter for presentations4 min 9 s
-
(Bloqueado)
Create picture links5 min 37 s
-
(Bloqueado)
How to use the error-checking rules in Excel4 min 59 s
-
(Bloqueado)
Protect worksheets and lock cells5 min 24 s
-
(Bloqueado)
Use mixed addresses in Excel formulas5 min 35 s
-
(Bloqueado)
Rapid filtering with Filter by Selection3 min 45 s
-
(Bloqueado)
Display large values5 min 16 s
-
(Bloqueado)
Tracking down conditional formatting and data validation rules5 min 42 s
-
(Bloqueado)
Transposing data and using the TRANSPOSE function5 min 43 s
-
(Bloqueado)
Displaying gridlines, borders, and column/row headings when printing4 min 37 s
-
(Bloqueado)
Exploring some of the 200-plus SmartArt graphic options4 min 1 s
-
(Bloqueado)
Using the CEILING and FLOOR functions for specialized rounding needs5 min 16 s
-
(Bloqueado)
Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners5 min 39 s
-
(Bloqueado)
Tabulating totals with the VLOOKUP function and array constants5 min 12 s
-
(Bloqueado)
Working with array formulas more easily4 min 23 s
-
(Bloqueado)
Using the new UNIQUE function to count and copy unique list entries3 min 36 s
-
(Bloqueado)
Creating and updating sample data5 min 43 s
-
(Bloqueado)
Format macros to make you a more efficient Excel user5 min 23 s
-
(Bloqueado)
Use the new SORT and SORTBY functions to extract sorted lists5 min 44 s
-
(Bloqueado)
Use themes to adjust worksheet colors, fonts, and effects3 min 42 s
-
(Bloqueado)
Calculate loan payments and investments with PMT and FV functions6 min 16 s
-
(Bloqueado)
Chart display options with blank cells in source data4 min 25 s
-
(Bloqueado)
Adjust Conditional Formatting rules by altering percentage breakpoints4 min 36 s
-
(Bloqueado)
Discover new formula capabilities with new functions and dynamic arrays5 min 6 s
-
(Bloqueado)
Sort or filter data based on color font or cell color background5 min 50 s
-
(Bloqueado)
Simplify the use of special characters and symbols5 min 24 s
-
(Bloqueado)
Select from over 800 icons to enliven worksheets6 min 29 s
-
(Bloqueado)
Use the new RANDARRAY function that replaces RAND and RANDBETWEEN6 min 26 s
-
(Bloqueado)
How and when to use an area chart4 min 16 s
-
(Bloqueado)
Insert colorful images with the People Graph Add-in5 min 37 s
-
(Bloqueado)
Use formulas to create interactive charts5 min 32 s
-
(Bloqueado)
Track variables using the Scenario Manager4 min 43 s
-
(Bloqueado)
Get totals quickly without creating formulas5 min 2 s
-
(Bloqueado)
Use column or row references to create dynamic formulas4 min 31 s
-
(Bloqueado)
Overcoming obstacles when working with dates in charts4 min 45 s
-
(Bloqueado)
Create map-type charts based on geographical locations4 min 19 s
-
(Bloqueado)
Techniques for creating date series4 min 42 s
-
(Bloqueado)
Extract filtered data with data validation and the FILTER function4 min 34 s
-
(Bloqueado)
Use Find and Replace to change cell contents and formats6 min 12 s
-
(Bloqueado)
Add formula tools and symbols to the Quick Access Toolbar5 min 12 s
-
(Bloqueado)
Use the XLOOKUP function to replace VLOOKUP5 min 23 s
-
(Bloqueado)
Change PivotTable settings for titles and summaries5 min 58 s
-
(Bloqueado)
Use the Excel filtering capability for dates4 min 57 s
-
(Bloqueado)
Use worksheet names in formulas5 min 31 s
-
(Bloqueado)
Use data validation rules with special phone and social security formats5 min 44 s
-
(Bloqueado)
Work with time calculations in formulas5 min 14 s
-
(Bloqueado)
Prevent and locate duplicate worksheet entries4 min 41 s
-
(Bloqueado)
Look forward and backward using EDATE and other date functions5 min 37 s
-
(Bloqueado)
Display and highlight worksheet formula cells5 min 46 s
-
(Bloqueado)
Split or join columnar data with Text to Columns or Flash Fill4 min 55 s
-
(Bloqueado)
Highlight milestone data with conditional formatting and cumulative formulas5 min 38 s
-
(Bloqueado)
Use the XMATCH function to replace MATCH3 min 43 s
-
(Bloqueado)
Create a powerful macro4 min 40 s
-
(Bloqueado)
Work with hidden and visible data in filtered and subtotaled lists5 min 54 s
-
(Bloqueado)
Use TODAY, NOW, YEARFRAC, and DATEDIF6 min 17 s
-
(Bloqueado)
Use data validation rules to prevent duplicate entries in a range4 min 38 s
-
(Bloqueado)
Use various techniques to hide cells, rows, columns, and worksheets4 min 56 s
-
(Bloqueado)
Align, arrange, and rotate shapes in worksheets5 min 40 s
-
(Bloqueado)
File documentation with the Workbook Statistics button4 min 22 s
-
(Bloqueado)
Avoid misleading visuals when rescaling5 min 16 s
-
(Bloqueado)
Use the Fill Justify feature to wrap long text4 min 2 s
-
(Bloqueado)
Create range names from Column and Row headings3 min 51 s
-
(Bloqueado)
Use the SUBSTITUTE and REPLACE functions4 min 47 s
-
(Bloqueado)
Accelerate Conditional Formatting with the Quick Access Toolbar4 min 15 s
-
(Bloqueado)
Use wildcard symbols in functions5 min 14 s
-
(Bloqueado)
Use wildcard symbols in filtering and commands6 min 7 s
-
(Bloqueado)
Condense lengthy nested IF functions with the newer IFS function4 min 43 s
-
(Bloqueado)
Add flair to charts with these formatting options: Gap width, shadow, glow, 3D, and more6 min 18 s
-
(Bloqueado)
Control worksheet security by allowing selected users to edit specific cell ranges5 min 43 s
-
(Bloqueado)
Retrieve vital data based on location using the Geography tool5 min 2 s
-
(Bloqueado)
Use the new SEQUENCE function to quickly build numeric and date arrays5 min 46 s
-
(Bloqueado)
Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions6 min 19 s
-
(Bloqueado)
Create a list box to facilitate selection of data from a list5 min 35 s
-
(Bloqueado)
Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more5 min 36 s
-
(Bloqueado)
Enhance readability with banded rows via conditional formatting5 min 25 s
-
(Bloqueado)
Seven different ways to drag data using the Ctrl, Shift, and Alt keys6 min 3 s
-
(Bloqueado)
Use the SWITCH function: Compare with IFS, CHOOSE, and other lookup functions5 min 48 s
-
(Bloqueado)
Adjust charts quickly with quick layout, change colors, and chart styles options4 min 39 s
-
(Bloqueado)
Analyze PivotTable data with 13 different Show Values As options5 min 10 s
-
(Bloqueado)
Expand/collapse or sort displayed results when using the SUBTOTAL command5 min 18 s
-
(Bloqueado)
Use the AGGREGATE function to circumvent errors and ignore hidden data5 min 17 s
-
(Bloqueado)
Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration6 min 11 s
-
(Bloqueado)
Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH4 min 29 s
-
(Bloqueado)
Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more5 min 54 s
-
(Bloqueado)
Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect5 min 56 s
-
(Bloqueado)
Using the LET function to simplify formulas via programming concepts5 min 4 s
-
(Bloqueado)
Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash4 min 35 s
-
(Bloqueado)
Create moving averages with formulas and chart trendlines5 min 47 s
-
(Bloqueado)
Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR6 min 5 s
-
(Bloqueado)
Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability5 min 26 s
-
(Bloqueado)
Work with cell colors, patterns, and effects to emphasize data and provide visual flair4 min 34 s
-
(Bloqueado)
Dynamic array formulas, new ways to calculate: One formula displays results in multiple cells5 min 27 s
-
(Bloqueado)
Fonts such as Arial and Calibri and a rundown of various available fonts in Excel6 min 5 s
-
(Bloqueado)
Use 3D formulas to tabulate data from multiple worksheets with the same layout6 min 36 s
-
(Bloqueado)
Multiple built-in date formats as well as tons of self-defined variations; m/d/y and mmm-d-yyyy6 min 24 s
-
(Bloqueado)
Where does that cell get its data from?: Tracking down cell precedents4 min 15 s
-
(Bloqueado)
Controlling date entry restrictions using data validation3 min 59 s
-
(Bloqueado)
Remove duplicates from a list vs. creating a new list without duplicates4 min 26 s
-
(Bloqueado)
New data types: Extract valuable online data into your worksheets5 min 9 s
-
(Bloqueado)
Use the FILTER and UNIQUE functions together for dynamic extractions5 min 1 s
-
(Bloqueado)
Adjusting text entries with the UPPER, LOWER, and PROPER functions4 min 55 s
-
(Bloqueado)
Refine filtering needs via custom filter options5 min 55 s
-
(Bloqueado)
Comparing column charts and bar charts: Pros and cons6 min 28 s
-
(Bloqueado)
How to use exponentiation (powers and roots) in Excel formulas5 min 50 s
-
(Bloqueado)
Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions4 min 18 s
-
(Bloqueado)
Tips for saving time when typing function names6 min 38 s
-
(Bloqueado)
SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted6 min 37 s
-
(Bloqueado)
Conversion of values into binary, octal, decimal, and hexadecimal equivalents4 min 30 s
-
(Bloqueado)
Quick number formatting with keystroke shortcuts and icon buttons7 min 7 s
-
(Bloqueado)
Date calculation and formatting issues related to the 2029/2030 switch4 min 34 s
-
(Bloqueado)
Using wildcards in the new XLOOKUP and XMATCH functions5 min 56 s
-
(Bloqueado)
Using slicers as analytical tools6 min 2 s
-
(Bloqueado)
Conditional formatting using contrasting heat maps on multiple vs.single ranges5 min 44 s
-
(Bloqueado)
Create dynamic pick lists using the UNIQUE and SORT functions, and data validation6 min 11 s
-
(Bloqueado)
Contrasting uses of clustered column and stacked column charts6 min 57 s
-
(Bloqueado)
Use the XLOOKUP function with multiple column criteria and multiple column results4 min 39 s
-
(Bloqueado)
Tips for updating entire columns of date entries when using real or sample data4 min 15 s
-
(Bloqueado)
Filtering lists with AND and OR criteria when using the FILTER function4 min 29 s
-
(Bloqueado)
Using TRIM, CLEAN and other functions to clean up text data5 min 47 s
-
(Bloqueado)
Create multiple range names from the top row and/or left column5 min 47 s
-
(Bloqueado)
Use dragging techniques to extend dates by weekdays only, month, or year3 min 55 s
-
(Bloqueado)
Use the LAMBDA function to create worksheet functions6 min 27 s
-
(Bloqueado)
Get the formula results you want using Goal Seek5 min 7 s
-
(Bloqueado)
Sort your data based on a Custom List that you define5 min 43 s
-
(Bloqueado)
Create a dynamic sheet name reference with the INDIRECT function4 min 41 s
-
(Bloqueado)
Calculate dates and/or days of the week for selected future holidays4 min 6 s
-
(Bloqueado)
Use dragging techniques for faster Paste Special options5 min 12 s
-
(Bloqueado)
How to use and not use SS numbers; fake SS numbers; display as XXX-XX-99994 min 51 s
-
(Bloqueado)
Five indispensable keystroke shortcuts for Windows and Mac users5 min 35 s
-
(Bloqueado)
Using new formula-writing techniques to simplify wide-ranging formulas6 min 6 s
-
(Bloqueado)
Calculate time differences within days and across multiple days6 min 26 s
-
(Bloqueado)
Use keyboard, mouse, and commands to zoom in/out quickly in Excel Windows and Mac versions5 min 45 s
-
(Bloqueado)
Make dynamic presentations with rapid expand/collapse detail features in outlining5 min 54 s
-
(Bloqueado)
Get data analysis suggestions with the Analyze Data (formerly Ideas) tool5 min 41 s
-
(Bloqueado)
Using the Distinct vs. Unique options when using the UNIQUE function4 min 58 s
-
(Bloqueado)
Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it4 min 29 s
-
(Bloqueado)
Exploring Excel's Sunburst chart to display hierarchical data5 min 5 s
-
(Bloqueado)
Creating floating text boxes with shadow, reflection, glow, and other shape effects4 min 27 s
-
(Bloqueado)
Page Setup tip: Print repeating titles, shrink-to-fit, landscape/portrait, double-spaced layout6 min 4 s
-
(Bloqueado)
Use Data Validation based on multiple criteria5 min 38 s
-
(Bloqueado)
Customize the Quick Access Toolbar using the Alt key or a mouse5 min 44 s
-
(Bloqueado)
Exploring treemap charts to display hierarchical data6 min 5 s
-
(Bloqueado)
Use the Quick Analysis tool for easy access to power tools3 min 36 s
-
(Bloqueado)
Create a number series with the Ctrl key and left/right mouse button5 min 56 s
-
(Bloqueado)
Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales4 min 51 s
-
(Bloqueado)
Unhide multiple worksheets at once and use the very hidden option5 min 5 s
-
(Bloqueado)
Use the Fill Justify command to quickly rewrap text into different cells3 min 45 s
-
(Bloqueado)
Create a 15th day or end-of-month series and adjust to weekdays only4 min 27 s
-
(Bloqueado)
Use the Go To Special option to select and populate blank cells5 min 4 s
-
(Bloqueado)
Accentuate values with conditional formatting and sparklines6 min 10 s
-
(Bloqueado)
Transpose data with formula substitution and the TRANSPOSE function4 min 34 s
-
(Bloqueado)
Use emojis and other symbols in formulas and charts5 min 50 s
-
(Bloqueado)
Use the Advanced Filter for specialized filtering needs5 min 48 s
-
(Bloqueado)
Combo charts: Combine different chart types to present data more clearly5 min 33 s
-
(Bloqueado)
Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells6 min 29 s
-
(Bloqueado)
Exploring Edit Default Layout options when using PivotTables4 min 28 s
-
(Bloqueado)
Navigation tips: Shortcuts to jump within and between worksheets and workbooks5 min 44 s
-
(Bloqueado)
Use DATEDIF to calculate months or days after yearly or monthly anniversaries5 min 18 s
-
(Bloqueado)
WordArt Transform: Special text character layouts5 min 24 s
-
(Bloqueado)
Sort data based on months and weekdays, even when entered as text5 min 36 s
-
(Bloqueado)
Use formulas to calculate values across worksheets and workbooks6 min 32 s
-
(Bloqueado)
Use XLOOKUP instead of complex combinations of VLOOKUP, INDEX, and MATCH5 min 41 s
-
(Bloqueado)
Use dragging techniques to create a forecast based on TREND and GROWTH functions5 min 25 s
-
(Bloqueado)
Stock charts: Adding Open, High, Low, Close, and Volume values4 min 49 s
-
(Bloqueado)
Control gridlines: Change colors, turn them on/off, and assign to a macro button4 min 50 s
-
(Bloqueado)
Examples of TRANSPOSE and other functions working differently with the new calculation engine5 min 18 s
-
(Bloqueado)
Locate formula dependencies via keystroke shortcuts and the Trace Dependents command4 min 48 s
-
(Bloqueado)
Replace text based on formats, like cell attributes (bold, text color, etc.)5 min 2 s
-
(Bloqueado)
Create forms using check boxes and option buttons to simplify data entry5 min 47 s
-
(Bloqueado)
Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data6 min 2 s
-
(Bloqueado)
Create a moving average with a chart or by using a formula4 min 22 s
-
(Bloqueado)
Redesigned Data Validation feature: Now more efficient when using large lists4 min 43 s
-
(Bloqueado)
Link pictures of data ranges to changing data4 min 14 s
-
(Bloqueado)
Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas5 min 29 s
-
(Bloqueado)
Create multiple PivotTables from a single source6 min 47 s
-
(Bloqueado)
Explore icon sets in the Excel Conditional Formatting feature4 min 46 s
-
(Bloqueado)
Use the IMAGE function to paste an image into a cell4 min 40 s
-
(Bloqueado)
Use TOCOL and TOROW to realign array data into single columns and rows5 min 28 s
-
(Bloqueado)
Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows5 min 3 s
-
(Bloqueado)
Use bubble charts to show relationships between sets of values5 min 35 s
-
(Bloqueado)
Contrast TEXTJOIN, CONCAT, and TEXTSPLIT to gather and split data5 min 47 s
-
(Bloqueado)
Use shrink-to-fit options to adjust the display of cell content and compress printed output4 min 22 s
-
(Bloqueado)
Locate formula precedents via keystroke shortcuts and the Trace Precedents command4 min 5 s
-
(Bloqueado)
Try these editing tips and keystroke shortcuts to use with long formulas5 min 38 s
-
(Bloqueado)
Customize and utilize status bar displays and copy/paste its data4 min 57 s
-
(Bloqueado)
Command and keystroke shortcuts for sorting frequently used data4 min 57 s
-
(Bloqueado)
Extract text from cells using the new TEXTBEFORE and TEXTAFTER functions4 min 14 s
-
(Bloqueado)
Quickly link cell content for main titles and axis titles for selected chart types4 min
-
(Bloqueado)
Use the TAKE, DROP, FILTER and SORTBY functions to build dependent lists6 min 9 s
-
(Bloqueado)
Create new lists by changing the PivotTable Report Layout to Tabular and adding repeating labels4 min 10 s
-
(Bloqueado)
Rapid filtering by content, cell color, or font color via right-clicking3 min 31 s
-
(Bloqueado)
Restructure column/row data using new WRAPROWS and WRAPCOLS functions6 min 2 s
-
(Bloqueado)
Working with date and time-based data and the over-24-hour display issue5 min 25 s
-
(Bloqueado)
Multiple tips for creating charts quickly5 min 44 s
-
(Bloqueado)
Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions5 min 16 s
-
(Bloqueado)
Overcoming rounding concerns in formulas with functions and decimal displays4 min 13 s
-
(Bloqueado)
Highlighting PivotTable results with conditional formatting4 min 42 s
-
(Bloqueado)
An overview of the 12 database functions in Excel5 min 21 s
-
(Bloqueado)
Advantages and disadvantages of using pie charts to display data4 min 20 s
-
(Bloqueado)
Rapid sorting via right-clicking options3 min 20 s
-
(Bloqueado)
Converting charts into pictures3 min 50 s
-
(Bloqueado)
Using three functions to track worksheet cells that are text, numbers, or formulas6 min 44 s
-
(Bloqueado)
Using new BYROW and BYCOL functions to analyze data6 min 25 s
-
(Bloqueado)
Create formulas rapidly with these shortcuts6 min 50 s
-
(Bloqueado)
Exploring 3-D Column and 3-D Bar charts5 min 55 s
-
(Bloqueado)
New VSTACK and HSTACK functions6 min 35 s
-
(Bloqueado)
Calculating day of the week totals from a large transaction list5 min 27 s
-
(Bloqueado)
Contrasating uses of the newer functions: XMATCH and XLOOKUP7 min 11 s
-
(Bloqueado)
Various techniques for highlighting (selecting) cell ranges quickly7 min 25 s
-
(Bloqueado)
Inserting special symbols using AutoCorrect options and the Insert Symbol command6 min 39 s
-
(Bloqueado)
Reviewing Excel Information functions - ISBLANK, ISNUMBER, ISTEXT, etc.6 min 31 s
-
(Bloqueado)
Manipulating text functions LEFT, MID, and TEXT to create new ID numbers5 min 10 s
-
(Bloqueado)
Discovering timesaving tools in the Go To Special feature6 min 13 s
-
(Bloqueado)
Calculating chronological and fiscal quarters6 min 10 s
-
(Bloqueado)
Sorting by moving columns left/right - in tables, Pivot Tables, SORT and SORTBY5 min 37 s
-
(Bloqueado)
Using Conditional Formatting for analysis and data emphasis6 min 11 s
-
(Bloqueado)
Using Indent buttons to control text displays and currency formatting3 min 32 s
-
(Bloqueado)
Create shapes and text boxes with content linked to worksheet cells5 min 2 s
-
(Bloqueado)
Dynamically presenting data via chart slicers5 min 6 s
-
(Bloqueado)
Sorting by day of month for birthday and anniversary lists3 min 34 s
-
(Bloqueado)
Using wildcards (asterisk, question mark, and tilde) in formulas and commands7 min 32 s
-
(Bloqueado)
Using SEARCH, FIND, and COUNT to tabulate data occurrences4 min 30 s
-
(Bloqueado)
Comparing the Data Analysis Histogram feature and Excel's Histogram chart5 min 9 s
-
(Bloqueado)
Using the AND and OR functions independently or within IF functions6 min 25 s
-
(Bloqueado)
Use various techniques to flip lists upside-down or left-to-right4 min 52 s
-
(Bloqueado)
Combine data with the TEXTJOIN, CONCAT, and CONCATENATE5 min 9 s
-
(Bloqueado)
Use Excel's Advanced Options to fine-tune settings and increase efficiency5 min 19 s
-
(Bloqueado)
Use ALT and other shortcuts when working with AutoComplete, Data Validation, etc.4 min 5 s
-
(Bloqueado)
Use the powerful COUNTIF family—8 functions—for statistical analysis7 min 18 s
-
(Bloqueado)
Show relationships between sets of values with a Scatter(XY) Chart7 min 4 s
-
(Bloqueado)
Locate and track a worksheet's Data Validation rules and violations5 min 40 s
-
(Bloqueado)
Use AGGREGATE to avoid errors and ignore hidden data5 min 52 s
-
(Bloqueado)
Explore multiple approaches for locating, preventing, and deleting duplicate data5 min 20 s
-
(Bloqueado)
Use a single SEQUENCE function to create various date layouts5 min 24 s
-
(Bloqueado)
Combine a Validation list, XLOOKUP function, table, and chart to build a presentation model5 min 10 s
-
(Bloqueado)
Pros and cons of using Stacked Area charts and Stacked Column Charts5 min 7 s
-
(Bloqueado)
Nested use of FILTER, SORT, and CHOOSECOLS functions for selective column retrieval6 min 41 s
-
(Bloqueado)
Learn about the new Office Theme, the default Aptos Font and new colors in M365 apps5 min 7 s
-
(Bloqueado)
Analyze data using TOCOL, TOROW, LARGE, and SMALL4 min 49 s
-
(Bloqueado)
Refine chart elements quickly with the powerful and overlooked Quick Layout button5 min 43 s
-
(Bloqueado)
Tips and techniques for displaying Excel worksheets effectively during presentations6 min 51 s
-
(Bloqueado)
Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions6 min 39 s
-
(Bloqueado)
Using entire column (or row) references to create more dynamic formulas6 min 51 s
-
(Bloqueado)
Using Excel's Accessibility Checker to follow best practices for those with disabilities5 min 10 s
-
(Bloqueado)
Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data6 min 28 s
-
(Bloqueado)
Create dynamic presentations with Slicers, Filters, and Charts6 min 39 s
-
(Bloqueado)
Compare and contrast multiple column sorting with SORT and SORTBY9 min 8 s
-
(Bloqueado)
Use keystroke and mouse shortcuts to display and navigate worksheets7 min 35 s
-
(Bloqueado)
Show gain/loss in census figures with the RANK, IF, and LET functions7 min 28 s
-
(Bloqueado)
Apply conditional formatting across data rows7 min 43 s
-
(Bloqueado)
Expand and collapse date displays in PivotTables4 min 19 s
-
(Bloqueado)
Use TODAY and NOW for real-time up-to-date calculations5 min 9 s
-
(Bloqueado)
Use Freeze Panes and Split to view different worksheet portions7 min 19 s
-
(Bloqueado)
Use CEILING and FLOOR for specialized numeric rounding needs6 min 31 s
-
(Bloqueado)
Highlight negative positive values with Conditional Formatting and Data Bars5 min 56 s
-
(Bloqueado)
Use AutoSum to simplify and accelerate formula creations4 min 44 s
-
(Bloqueado)
Dynamic sheet name reference with INDIRECT5 min 27 s
-
(Bloqueado)
Create custom and built-in lists to sort and fill in sequences8 min 11 s
-
(Bloqueado)
Consolidate and split workbooks5 min 51 s
-
(Bloqueado)
Expand, collapse and sort displayed results when using Subtotal6 min 39 s
-
(Bloqueado)
Random number functions: RAND, RANDBETWEEN, and RANDARRAY5 min 48 s
-
(Bloqueado)
Using the new GROUPBY and PIVOTBY functions6 min 28 s
-
(Bloqueado)
Creating 3D and other formulas that use data from different worksheets7 min 34 s
-
(Bloqueado)
Quick searching for menu commands with the right mouse button3 min 41 s
-
(Bloqueado)
Using the new Checkbox button on the Insert tab4 min 13 s
-
(Bloqueado)