コース: Excel Tips Weekly
無料トライアルでこのコースを視聴する
今すぐ登録して、23,100件以上登録されている、業界エキスパート指導のコースを受講しましょう。
Using Conditional Formatting for analysis and data emphasis - Microsoft Excelのチュートリアル
コース: Excel Tips Weekly
Using Conditional Formatting for analysis and data emphasis
- In this week's weekly tip, we're going to show you 2 how you can use conditional formatting, 3 not simply as a presentation tool, 4 although it's certainly valuable in that sense, 5 but also as an analytical tool. 6 As we look at this particular worksheet, 7 notice how it's covering sales entries month by month, 8 starting in 2010, all the way into 2023. 9 It is handy to know, it's useful to know 10 for any given month. 11 We know if it's larger than the previous month. 12 And it gives us some insight into this operation. 13 Imagine a small business, 14 maybe you started out of your home, 15 maybe it's gotten a bit bigger now, 16 you've got an office and so on, 17 and you just want to keep track of things. 18 And you also want to know for any given year, 19 which month is the highest. 20 And rather than writing complex formulas, 21 we can do this with conditional formatting. 22 And so the rules are in effect here…
エクササイズファイルを使って実践してみましょう。
インストラクターがコースで使用しているファイルはダウンロードできます。見て、聞いて、練習することで、理解度を深めることができます。
- 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
目次
-
-
-
(ロック済み)
Hide and unhide worksheets securely6分6秒
-
(ロック済み)
Resizing, moving, copying, and manipulating charts and other objects10分17秒
-
(ロック済み)
Using list boxes and combo boxes to facilitate forms creation7分36秒
-
(ロック済み)
Using the FORMULATEXT and N functions for worksheet and formula documentation5分53秒
-
(ロック済み)
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells7分55秒
-
(ロック済み)
Summarizing data from diverse ranges with Data > Consolidate9分33秒
-
(ロック済み)
Using check boxes and conditional formatting together for dynamic displays5分58秒
-
(ロック済み)
Becoming more productive with these 10 tiny tips you'll use often8分
-
(ロック済み)
Transposing data and charts for a different perspective on your data8分57秒
-
(ロック済み)
Applying conditional formatting across rows of data6分43秒
-
(ロック済み)
Exploring various layouts for your PivotTable4分27秒
-
(ロック済み)
Splitting and consolidating workbooks6分47秒
-
(ロック済み)
Using date and time as metrics in a PivotTable6分53秒
-
(ロック済み)
Adding illustrations to your workbook12分7秒
-
(ロック済み)
Using a pick list, VLOOKUP, table, and chart together8分5秒
-
(ロック済み)
Using formulas to calculate values across worksheets and workbooks11分12秒
-
(ロック済み)
Dynamically presenting data via chart slicers7分15秒
-
(ロック済み)
Parsing your data to create unique lists3分21秒
-
(ロック済み)
Using the REPT function to represent data visually3分6秒
-
(ロック済み)
Using source data from a table to make your PivotTable more dynamic7分8秒
-
(ロック済み)
Accelerating Cut, Copy, Paste, and Insert tasks7分26秒
-
(ロック済み)
Increasing your productivity with custom lists5分9秒
-
(ロック済み)
Highlighting PivotTable results with conditional formatting6分10秒
-
(ロック済み)
Customizing templates to fit your unique needs6分6秒
-
(ロック済み)
Creating dynamic charts with in-cell conditional formatting3分26秒
-
(ロック済み)
Enhancing table filtering with slicers5分23秒
-
(ロック済み)
Converting charts into pictures4分51秒
-
(ロック済み)
Custom grouping in PivotTables4分31秒
-
(ロック済み)
Quick formatting tips8分9秒
-
(ロック済み)
The top five unknown but useful keyboard shortcuts6分17秒
-
(ロック済み)
Using the TREND and GROWTH functions for projecting future results5分54秒
-
(ロック済み)
Using scroll bars and spin buttons to facilitate forms creation10分1秒
-
(ロック済み)
Creating colorful 3D buttons for worksheet annotation and macro buttons6分52秒
-
(ロック済み)
Calculating with hours, minutes, and times of day11分2秒
-
(ロック済み)
Tracking down cell dependencies across multiple worksheets and workbooks6分24秒
-
(ロック済み)
Discovering time-saving tools in the Go To Special feature11分22秒
-
(ロック済み)
Using Go To Special6分1秒
-
(ロック済み)
Reducing data entry time by expanding AutoCorrect options6分10秒
-
(ロック済み)
Setting up custom views for quick access to different worksheet displays6分30秒
-
(ロック済み)
Using hyperlinks for rapidly switching worksheet locations and jumping to websites7分18秒
-
(ロック済み)
Controlling worksheet security by allowing selected users to edit specific cell ranges7分22秒
-
(ロック済み)
Using option buttons, group boxes, and checkboxes to facilitate forms creation8分7秒
-
(ロック済み)
Exploring what-if scenarios using Goal Seek9分55秒
-
(ロック済み)
Creating text, numerical, date, and time lists in a flash6分54秒
-
(ロック済み)
Creating variable conditional formatting rules8分4秒
-
(ロック済み)
Handling dates with unusual formats6分5秒
-
(ロック済み)
Ten quick tips to use daily: formulas, formatting, and accessing commands6分32秒
-
(ロック済み)
Using wildcards (asterisk, tilde, and question mark)11分
-
(ロック済み)
Custom formats using asterisk, semicolon, and brackets13分
-
(ロック済み)
Meeting unusual filtering needs via Advanced Filter5分28秒
-
(ロック済み)
Create an organization chart8分56秒
-
(ロック済み)
Two-way lookup using the MATCH and INDEX functions11分28秒
-
(ロック済み)
Using Excel error-checking functions10分37秒
-
(ロック済み)
Custom formats, relative addressing, and conditional formatting8分26秒
-
(ロック済み)
Auditing9分1秒
-
(ロック済み)
Adding comments and shapes7分35秒
-
(ロック済み)
Drawing borders and border grids5分45秒
-
(ロック済み)
Building a flexible monthly table using functions11分44秒
-
(ロック済み)
Adding pictures as worksheet backgrounds4分15秒
-
(ロック済み)
ADDRESS, ROW, and COLUMN functions8分8秒
-
(ロック済み)
Join data with new CONCAT and TEXTJOIN functions6分15秒
-
(ロック済み)
Working with formulas in tables13分2秒
-
(ロック済み)
Locating data validation rules and violations7分20秒
-
(ロック済み)
Creating an Excel template7分57秒
-
(ロック済み)
Restoring missing column titles6分41秒
-
(ロック済み)
Creating a pick list dependent on another pick list6分59秒
-
(ロック済み)
Using command shortcuts with the Alt key5分51秒
-
(ロック済み)
Set up a macro for sorting dynamic data8分42秒
-
(ロック済み)
Use random number functions for sorting and creating sample data9分57秒
-
(ロック済み)
Use calcuated fields and calculated items in a PivotTable8分57秒
-
(ロック済み)
Replace characters by position with the REPLACE function5分46秒
-
(ロック済み)
Work with formulas in tables9分3秒
-
(ロック済み)
Keystroke shortcuts from A to Z: Using the Ctrl key16分16秒
-
(ロック済み)
Use special tricks for working with dates in charts11分36秒
-
(ロック済み)
Use a data form for data entry and exploring data6分42秒
-
(ロック済み)
Creating an Excel template to simplify updating a monthly file7分10秒
-
(ロック済み)
Calculate dates efficiently using Excel's hidden function - DATEDIF7分36秒
-
(ロック済み)
Create dynamic sheet name references with the INDIRECT function6分45秒
-
(ロック済み)
Avoid errors and hidden data with the powerful AGGREGATE function7分8秒
-
(ロック済み)
Hide worksheets, row, columns, cells and other Excel elements7分26秒
-
(ロック済み)
Use slicers and charts together for dynamic presentations9分4秒
-
(ロック済み)
Save a chart as a template: Use the template for current or new charts6分2秒
-
(ロック済み)
MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions8分12秒
-
(ロック済み)
Adjust a chart's source data and adjust its series order9分7秒
-
(ロック済み)
Use the OFFSET function for tabulating moving data11分23秒
-
(ロック済み)
Alter numeric data without formulas10分19秒
-
(ロック済み)
Use Flash Fill to rapidly combine or separate columnar data10分28秒
-
(ロック済み)
Adjust banded-row formatting14分35秒
-
(ロック済み)
Change the shape of comment boxes and other objects6分32秒
-
(ロック済み)
How and when to use the 10 rounding functions in Excel13分26秒
-
(ロック済み)
Calculate faster with the AutoSum button and AutoSum keystroke shortcut6分54秒
-
(ロック済み)
How to use mixed cell references8分25秒
-
(ロック済み)
Activate the Speak On Enter and Speak Cells features5分38秒
-
(ロック済み)
Accelerate data entry with five special techniques12分8秒
-
(ロック済み)
Insert a text box or shape and link a cell's content to it6分58秒
-
(ロック済み)
Use Watch Window and other techniques to track changing cells8分21秒
-
(ロック済み)
How to create time interval entries11分39秒
-
(ロック済み)
How to create frequency tabulations and distributions8分10秒
-
(ロック済み)
Create an expanded list from a summary using PivotTable techniques7分25秒
-
(ロック済み)
Solve matching issues with matching phone numbers and SS numbers10分
-
(ロック済み)
Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative7分27秒
-
(ロック済み)
Use outlining tools to quickly expand and collapse data for dynamic presentations9分19秒
-
(ロック済み)
Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting9分59秒
-
(ロック済み)
Create lists of all 2nd Tuesdays, last Tuesdays. and other date series10分44秒
-
(ロック済み)
Create linkage formulas that refer to other worksheets and workbooks11分49秒
-
(ロック済み)
Formula nesting: Using multiple functions in the same formula13分22秒
-
(ロック済み)
Keyboard shortcuts for numeric formats8分18秒
-
(ロック済み)
Use the Subtotal command to analyze data with single- or multiple-level subtotals9分15秒
-
(ロック済み)
Work with MAX, MAXIFS, LARGE, and related functions8分14秒
-
(ロック済み)
Use the dynamic TODAY and NOW functions for real-time up-to-date calculations9分24秒
-
(ロック済み)
Use the FIND, MID, LEFT, and RIGHT functions10分38秒
-
(ロック済み)
Flip the left-to-right order of columns with the INDEX function or sort by columns8分18秒
-
(ロック済み)
Working with hidden data when copying cells and creating charts10分58秒
-
(ロック済み)
Use conditional formatting data bars to accentuate negative data4分16秒
-
(ロック済み)
Creative use of sparklines in merged cells with axes7分1秒
-
(ロック済み)
Copy formats quickly using dragging techniques and the Format Painter5分25秒
-
(ロック済み)
Displaying multiple worksheets and workbooks together10分13秒
-
(ロック済み)
Tips for creating and updating sample data11分1秒
-
(ロック済み)
Use conditional formatting to overcome formatting limitations of the IF function8分54秒
-
(ロック済み)
Use VLOOKUP, MATCH, and INDEX functions with array formulas10分38秒
-
(ロック済み)
Summarize data from different worksheets with a PivotTable7分20秒
-
(ロック済み)
AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas6分59秒
-
(ロック済み)
Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions8分40秒
-
(ロック済み)
Use custom formulas in data validation to keep out bad data13分18秒
-
(ロック済み)
Dealing with circular errors8分20秒
-
(ロック済み)
Tips for creating charts quickly6分56秒
-
(ロック済み)
Creating heat maps using conditional formatting8分31秒
-
(ロック済み)
Using the INDEX function to extract data by row and column11分1秒
-
(ロック済み)
Displaying tips when using Excel in presentations6分23秒
-
(ロック済み)
The Wrap Text, Merge and Center, and Indent options9分2秒
-
(ロック済み)
Using fill effects (gradients, patterns, styles) for colorful cell background variations5分10秒
-
(ロック済み)
Working with multiple worksheets simultaneously8分42秒
-
(ロック済み)
Exploring font choices not found on the Home tab4分2秒
-
(ロック済み)
Using WordArt for special titles and headings4分33秒
-
(ロック済み)
Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions7分34秒
-
(ロック済み)
Borders and gridlines: Exploring variations, options, and differences8分24秒
-
(ロック済み)
New Excel 2016 chart types: Tree map and sunburst7分29秒
-
(ロック済み)
Freezing column and row titles7分48秒
-
(ロック済み)
Use data validation to force entries to be uppercase or lowercase10分48秒
-
(ロック済み)
Avoiding common chart distortions11分49秒
-
(ロック済み)
Use the new funnel chart available in Excel 3654分3秒
-
(ロック済み)
Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character6分1秒
-
(ロック済み)
Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!9分39秒
-
(ロック済み)
Creating cross-totals with the SUMIFS function and mixed references5分50秒
-
(ロック済み)
New Excel 2016 chart types: Histogram, Pareto, and box, and whisker10分8秒
-
(ロック済み)
Using the AND and OR functions independently or within IF functions9分58秒
-
(ロック済み)
Vertical and horizontal alignment settings and orientation options7分12秒
-
(ロック済み)
Sorting tips and shortcuts8分40秒
-
(ロック済み)
A look at new chart types in Excel 2016: Waterfall6分57秒
-
(ロック済み)
Work with formulas and formats: Decimals and fractions5分42秒
-
(ロック済み)
Creating mixed reference formulas; converting to a table; applying conditional formatting8分6秒
-
(ロック済み)
Control gridlines in charts and on worksheets7分45秒
-
(ロック済み)
Use the INDIRECT function with intersection formulas and range names to extract data6分34秒
-
(ロック済み)
Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes7分14秒
-
(ロック済み)
Control phone number and postal code formats using built-in options or customized formats7分40秒
-
(ロック済み)
Change the default Excel chart type; create and use chart templates6分13秒
-
(ロック済み)
Create your own customized date and time formats7分31秒
-
(ロック済み)
Create on-screen warnings and reminders with comments or data validation messages6分18秒
-
(ロック済み)
Use REPLACE for formats only, for data only, or for both6分11秒
-
(ロック済み)
Create numeric formats: Display in thousands or millions11分40秒
-
(ロック済み)
Converting dates like 20102006 into usable date entries4分25秒
-
(ロック済み)
Create custom lists for letter series like A to Z6分26秒
-
(ロック済み)
Freeze Panes and Split5分30秒
-
(ロック済み)
NETWORKDAYS.INTL and WORKDAY.INTL5分29秒
-
(ロック済み)
Calculate % of change5分41秒
-
(ロック済み)
Fill in all blank cells within a range with either formatting or data4分13秒
-
(ロック済み)
Use the COUNT and COUNTA functions4分19秒
-
(ロック済み)
Use workbook protection to prevent use of sheet commands5分27秒
-
(ロック済み)
Rank data with the RANK and RANK.AVG functions5分37秒
-
(ロック済み)
Use nonstandard fiscal years and quarters in PivotTables5分35秒
-
(ロック済み)
Identify or extract unique entries in a list5分22秒
-
(ロック済み)
Keyboard, mouse, and command techniques for viewing worksheets5分18秒
-
(ロック済み)
Create artistic charts with random numbers7分23秒
-
(ロック済み)
Extract day, month, and year from date fields5分7秒
-
(ロック済み)
Compare data with EXACT, FIND, and SEARCH functions4分58秒
-
(ロック済み)
How to covert ROMAN numberals4分25秒
-
(ロック済み)
Use range names for more readable formulas5分38秒
-
(ロック済み)
Customize your Quick Access Toolbar6分7秒
-
(ロック済み)
Conditional formatting based on date proximity4分51秒
-
(ロック済み)
How to adjust names5分45秒
-
(ロック済み)
Differences and limitations of converting data to a table5分17秒
-
(ロック済み)
Avoid the #DIV/0 error message4分56秒
-
(ロック済み)
Explore formatting options not available on the Home tab4分25秒
-
(ロック済み)
Control table formatting with custom formats3分12秒
-
(ロック済み)
Use date functions for age and tenure calculations5分23秒
-
(ロック済み)
Avoid unintentional entries when typing code numbers4分29秒
-
(ロック済み)
Sorting by moving columns4分16秒
-
(ロック済み)
Calculating cumulative totals3分52秒
-
(ロック済み)
Using the CONVERT function for different numbering systems4分56秒
-
(ロック済み)
Creating an automatically expanding chart by basing it on a table4分24秒
-
(ロック済み)
Keystroke shortcuts using the Alt key5分20秒
-
(ロック済み)
Using the Solver Add-in4分29秒
-
(ロック済み)
Column widths, row heights, merging cells, and related formatting issues5分1秒
-
(ロック済み)
Adjusting default layouts and date grouping in PivotTables4分14秒
-
(ロック済み)
Auditing cell content with Watch Window and dependent cell formulas4分21秒
-
(ロック済み)
Use the LEN and REPT functions for specialized cell testing and display options4分4秒
-
(ロック済み)
Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters5分6秒
-
(ロック済み)
Create double-spaced and triple-spaced printouts while repeating column headings4分13秒
-
(ロック済み)
Helpful keystroke shortcuts5分2秒
-
(ロック済み)
Identify weekdays and weekend days in data4分50秒
-
(ロック済み)
Use chart and filter for presentations4分9秒
-
(ロック済み)
Create picture links5分37秒
-
(ロック済み)
How to use the error-checking rules in Excel4分59秒
-
(ロック済み)
Protect worksheets and lock cells5分24秒
-
(ロック済み)
Use mixed addresses in Excel formulas5分35秒
-
(ロック済み)
Rapid filtering with Filter by Selection3分45秒
-
(ロック済み)
Display large values5分16秒
-
(ロック済み)
Tracking down conditional formatting and data validation rules5分42秒
-
(ロック済み)
Transposing data and using the TRANSPOSE function5分43秒
-
(ロック済み)
Displaying gridlines, borders, and column/row headings when printing4分37秒
-
(ロック済み)
Exploring some of the 200-plus SmartArt graphic options4分1秒
-
(ロック済み)
Using the CEILING and FLOOR functions for specialized rounding needs5分16秒
-
(ロック済み)
Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners5分39秒
-
(ロック済み)
Tabulating totals with the VLOOKUP function and array constants5分12秒
-
(ロック済み)
Working with array formulas more easily4分23秒
-
(ロック済み)
Using the new UNIQUE function to count and copy unique list entries3分36秒
-
(ロック済み)
Creating and updating sample data5分43秒
-
(ロック済み)
Format macros to make you a more efficient Excel user5分23秒
-
(ロック済み)
Use the new SORT and SORTBY functions to extract sorted lists5分44秒
-
(ロック済み)
Use themes to adjust worksheet colors, fonts, and effects3分42秒
-
(ロック済み)
Calculate loan payments and investments with PMT and FV functions6分16秒
-
(ロック済み)
Chart display options with blank cells in source data4分25秒
-
(ロック済み)
Adjust Conditional Formatting rules by altering percentage breakpoints4分36秒
-
(ロック済み)
Discover new formula capabilities with new functions and dynamic arrays5分6秒
-
(ロック済み)
Sort or filter data based on color font or cell color background5分50秒
-
(ロック済み)
Simplify the use of special characters and symbols5分24秒
-
(ロック済み)
Select from over 800 icons to enliven worksheets6分29秒
-
(ロック済み)
Use the new RANDARRAY function that replaces RAND and RANDBETWEEN6分26秒
-
(ロック済み)
How and when to use an area chart4分16秒
-
(ロック済み)
Insert colorful images with the People Graph Add-in5分37秒
-
(ロック済み)
Use formulas to create interactive charts5分32秒
-
(ロック済み)
Track variables using the Scenario Manager4分43秒
-
(ロック済み)
Get totals quickly without creating formulas5分2秒
-
(ロック済み)
Use column or row references to create dynamic formulas4分31秒
-
(ロック済み)
Overcoming obstacles when working with dates in charts4分45秒
-
(ロック済み)
Create map-type charts based on geographical locations4分19秒
-
(ロック済み)
Techniques for creating date series4分42秒
-
(ロック済み)
Extract filtered data with data validation and the FILTER function4分34秒
-
(ロック済み)
Use Find and Replace to change cell contents and formats6分12秒
-
(ロック済み)
Add formula tools and symbols to the Quick Access Toolbar5分12秒
-
(ロック済み)
Use the XLOOKUP function to replace VLOOKUP5分23秒
-
(ロック済み)
Change PivotTable settings for titles and summaries5分58秒
-
(ロック済み)
Use the Excel filtering capability for dates4分57秒
-
(ロック済み)
Use worksheet names in formulas5分31秒
-
(ロック済み)
Use data validation rules with special phone and social security formats5分44秒
-
(ロック済み)
Work with time calculations in formulas5分14秒
-
(ロック済み)
Prevent and locate duplicate worksheet entries4分41秒
-
(ロック済み)
Look forward and backward using EDATE and other date functions5分37秒
-
(ロック済み)
Display and highlight worksheet formula cells5分46秒
-
(ロック済み)
Split or join columnar data with Text to Columns or Flash Fill4分55秒
-
(ロック済み)
Highlight milestone data with conditional formatting and cumulative formulas5分38秒
-
(ロック済み)
Use the XMATCH function to replace MATCH3分43秒
-
(ロック済み)
Create a powerful macro4分40秒
-
(ロック済み)
Work with hidden and visible data in filtered and subtotaled lists5分54秒
-
(ロック済み)
Use TODAY, NOW, YEARFRAC, and DATEDIF6分17秒
-
(ロック済み)
Use data validation rules to prevent duplicate entries in a range4分38秒
-
(ロック済み)
Use various techniques to hide cells, rows, columns, and worksheets4分56秒
-
(ロック済み)
Align, arrange, and rotate shapes in worksheets5分40秒
-
(ロック済み)
File documentation with the Workbook Statistics button4分22秒
-
(ロック済み)
Avoid misleading visuals when rescaling5分16秒
-
(ロック済み)
Use the Fill Justify feature to wrap long text4分2秒
-
(ロック済み)
Create range names from Column and Row headings3分51秒
-
(ロック済み)
Use the SUBSTITUTE and REPLACE functions4分47秒
-
(ロック済み)
Accelerate Conditional Formatting with the Quick Access Toolbar4分15秒
-
(ロック済み)
Use wildcard symbols in functions5分14秒
-
(ロック済み)
Use wildcard symbols in filtering and commands6分7秒
-
(ロック済み)
Condense lengthy nested IF functions with the newer IFS function4分43秒
-
(ロック済み)
Add flair to charts with these formatting options: Gap width, shadow, glow, 3D, and more6分18秒
-
(ロック済み)
Control worksheet security by allowing selected users to edit specific cell ranges5分43秒
-
(ロック済み)
Retrieve vital data based on location using the Geography tool5分2秒
-
(ロック済み)
Use the new SEQUENCE function to quickly build numeric and date arrays5分46秒
-
(ロック済み)
Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions6分19秒
-
(ロック済み)
Create a list box to facilitate selection of data from a list5分35秒
-
(ロック済み)
Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more5分36秒
-
(ロック済み)
Enhance readability with banded rows via conditional formatting5分25秒
-
(ロック済み)
Seven different ways to drag data using the Ctrl, Shift, and Alt keys6分3秒
-
(ロック済み)
Use the SWITCH function: Compare with IFS, CHOOSE, and other lookup functions5分48秒
-
(ロック済み)
Adjust charts quickly with quick layout, change colors, and chart styles options4分39秒
-
(ロック済み)
Analyze PivotTable data with 13 different Show Values As options5分10秒
-
(ロック済み)
Expand/collapse or sort displayed results when using the SUBTOTAL command5分18秒
-
(ロック済み)
Use the AGGREGATE function to circumvent errors and ignore hidden data5分17秒
-
(ロック済み)
Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration6分11秒
-
(ロック済み)
Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH4分29秒
-
(ロック済み)
Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more5分54秒
-
(ロック済み)
Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect5分56秒
-
(ロック済み)
Using the LET function to simplify formulas via programming concepts5分4秒
-
(ロック済み)
Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash4分35秒
-
(ロック済み)
Create moving averages with formulas and chart trendlines5分47秒
-
(ロック済み)
Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR6分5秒
-
(ロック済み)
Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability5分26秒
-
(ロック済み)
Work with cell colors, patterns, and effects to emphasize data and provide visual flair4分34秒
-
(ロック済み)
Dynamic array formulas, new ways to calculate: One formula displays results in multiple cells5分27秒
-
(ロック済み)
Fonts such as Arial and Calibri and a rundown of various available fonts in Excel6分5秒
-
(ロック済み)
Use 3D formulas to tabulate data from multiple worksheets with the same layout6分36秒
-
(ロック済み)
Multiple built-in date formats as well as tons of self-defined variations; m/d/y and mmm-d-yyyy6分24秒
-
(ロック済み)
Where does that cell get its data from?: Tracking down cell precedents4分15秒
-
(ロック済み)
Controlling date entry restrictions using data validation3分59秒
-
(ロック済み)
Remove duplicates from a list vs. creating a new list without duplicates4分26秒
-
(ロック済み)
New data types: Extract valuable online data into your worksheets5分9秒
-
(ロック済み)
Use the FILTER and UNIQUE functions together for dynamic extractions5分1秒
-
(ロック済み)
Adjusting text entries with the UPPER, LOWER, and PROPER functions4分55秒
-
(ロック済み)
Refine filtering needs via custom filter options5分55秒
-
(ロック済み)
Comparing column charts and bar charts: Pros and cons6分28秒
-
(ロック済み)
How to use exponentiation (powers and roots) in Excel formulas5分50秒
-
(ロック済み)
Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions4分18秒
-
(ロック済み)
Tips for saving time when typing function names6分38秒
-
(ロック済み)
SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted6分37秒
-
(ロック済み)
Conversion of values into binary, octal, decimal, and hexadecimal equivalents4分30秒
-
(ロック済み)
Quick number formatting with keystroke shortcuts and icon buttons7分7秒
-
(ロック済み)
Date calculation and formatting issues related to the 2029/2030 switch4分34秒
-
(ロック済み)
Using wildcards in the new XLOOKUP and XMATCH functions5分56秒
-
(ロック済み)
Using slicers as analytical tools6分2秒
-
(ロック済み)
Conditional formatting using contrasting heat maps on multiple vs.single ranges5分44秒
-
(ロック済み)
Create dynamic pick lists using the UNIQUE and SORT functions, and data validation6分11秒
-
(ロック済み)
Contrasting uses of clustered column and stacked column charts6分57秒
-
(ロック済み)
Use the XLOOKUP function with multiple column criteria and multiple column results4分39秒
-
(ロック済み)
Tips for updating entire columns of date entries when using real or sample data4分15秒
-
(ロック済み)
Filtering lists with AND and OR criteria when using the FILTER function4分29秒
-
(ロック済み)
Using TRIM, CLEAN and other functions to clean up text data5分47秒
-
(ロック済み)
Create multiple range names from the top row and/or left column5分47秒
-
(ロック済み)
Use dragging techniques to extend dates by weekdays only, month, or year3分55秒
-
(ロック済み)
Use the LAMBDA function to create worksheet functions6分27秒
-
(ロック済み)
Get the formula results you want using Goal Seek5分7秒
-
(ロック済み)
Sort your data based on a Custom List that you define5分43秒
-
(ロック済み)
Create a dynamic sheet name reference with the INDIRECT function4分41秒
-
(ロック済み)
Calculate dates and/or days of the week for selected future holidays4分6秒
-
(ロック済み)
Use dragging techniques for faster Paste Special options5分12秒
-
(ロック済み)
How to use and not use SS numbers; fake SS numbers; display as XXX-XX-99994分51秒
-
(ロック済み)
Five indispensable keystroke shortcuts for Windows and Mac users5分35秒
-
(ロック済み)
Using new formula-writing techniques to simplify wide-ranging formulas6分6秒
-
(ロック済み)
Calculate time differences within days and across multiple days6分26秒
-
(ロック済み)
Use keyboard, mouse, and commands to zoom in/out quickly in Excel Windows and Mac versions5分45秒
-
(ロック済み)
Make dynamic presentations with rapid expand/collapse detail features in outlining5分54秒
-
(ロック済み)
Get data analysis suggestions with the Analyze Data (formerly Ideas) tool5分41秒
-
(ロック済み)
Using the Distinct vs. Unique options when using the UNIQUE function4分58秒
-
(ロック済み)
Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it4分29秒
-
(ロック済み)
Exploring Excel's Sunburst chart to display hierarchical data5分5秒
-
(ロック済み)
Creating floating text boxes with shadow, reflection, glow, and other shape effects4分27秒
-
(ロック済み)
Page Setup tip: Print repeating titles, shrink-to-fit, landscape/portrait, double-spaced layout6分4秒
-
(ロック済み)
Use Data Validation based on multiple criteria5分38秒
-
(ロック済み)
Customize the Quick Access Toolbar using the Alt key or a mouse5分44秒
-
(ロック済み)
Exploring treemap charts to display hierarchical data6分5秒
-
(ロック済み)
Use the Quick Analysis tool for easy access to power tools3分36秒
-
(ロック済み)
Create a number series with the Ctrl key and left/right mouse button5分56秒
-
(ロック済み)
Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales4分51秒
-
(ロック済み)
Unhide multiple worksheets at once and use the very hidden option5分5秒
-
(ロック済み)
Use the Fill Justify command to quickly rewrap text into different cells3分45秒
-
(ロック済み)
Create a 15th day or end-of-month series and adjust to weekdays only4分27秒
-
(ロック済み)
Use the Go To Special option to select and populate blank cells5分4秒
-
(ロック済み)
Accentuate values with conditional formatting and sparklines6分10秒
-
(ロック済み)
Transpose data with formula substitution and the TRANSPOSE function4分34秒
-
(ロック済み)
Use emojis and other symbols in formulas and charts5分50秒
-
(ロック済み)
Use the Advanced Filter for specialized filtering needs5分48秒
-
(ロック済み)
Combo charts: Combine different chart types to present data more clearly5分33秒
-
(ロック済み)
Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells6分29秒
-
(ロック済み)
Exploring Edit Default Layout options when using PivotTables4分28秒
-
(ロック済み)
Navigation tips: Shortcuts to jump within and between worksheets and workbooks5分44秒
-
(ロック済み)
Use DATEDIF to calculate months or days after yearly or monthly anniversaries5分18秒
-
(ロック済み)
WordArt Transform: Special text character layouts5分24秒
-
(ロック済み)
Sort data based on months and weekdays, even when entered as text5分36秒
-
(ロック済み)
Use formulas to calculate values across worksheets and workbooks6分32秒
-
(ロック済み)
Use XLOOKUP instead of complex combinations of VLOOKUP, INDEX, and MATCH5分41秒
-
(ロック済み)
Use dragging techniques to create a forecast based on TREND and GROWTH functions5分25秒
-
(ロック済み)
Stock charts: Adding Open, High, Low, Close, and Volume values4分49秒
-
(ロック済み)
Control gridlines: Change colors, turn them on/off, and assign to a macro button4分50秒
-
(ロック済み)
Examples of TRANSPOSE and other functions working differently with the new calculation engine5分18秒
-
(ロック済み)
Locate formula dependencies via keystroke shortcuts and the Trace Dependents command4分48秒
-
(ロック済み)
Replace text based on formats, like cell attributes (bold, text color, etc.)5分2秒
-
(ロック済み)
Create forms using check boxes and option buttons to simplify data entry5分47秒
-
(ロック済み)
Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data6分2秒
-
(ロック済み)
Create a moving average with a chart or by using a formula4分22秒
-
(ロック済み)
Redesigned Data Validation feature: Now more efficient when using large lists4分43秒
-
(ロック済み)
Link pictures of data ranges to changing data4分14秒
-
(ロック済み)
Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas5分29秒
-
(ロック済み)
Create multiple PivotTables from a single source6分47秒
-
(ロック済み)
Explore icon sets in the Excel Conditional Formatting feature4分46秒
-
(ロック済み)
Use the IMAGE function to paste an image into a cell4分40秒
-
(ロック済み)
Use TOCOL and TOROW to realign array data into single columns and rows5分28秒
-
(ロック済み)
Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows5分3秒
-
(ロック済み)
Use bubble charts to show relationships between sets of values5分35秒
-
(ロック済み)
Contrast TEXTJOIN, CONCAT, and TEXTSPLIT to gather and split data5分47秒
-
(ロック済み)
Use shrink-to-fit options to adjust the display of cell content and compress printed output4分22秒
-
(ロック済み)
Locate formula precedents via keystroke shortcuts and the Trace Precedents command4分5秒
-
(ロック済み)
Try these editing tips and keystroke shortcuts to use with long formulas5分38秒
-
(ロック済み)
Customize and utilize status bar displays and copy/paste its data4分57秒
-
(ロック済み)
Command and keystroke shortcuts for sorting frequently used data4分57秒
-
(ロック済み)
Extract text from cells using the new TEXTBEFORE and TEXTAFTER functions4分14秒
-
(ロック済み)
Quickly link cell content for main titles and axis titles for selected chart types4分
-
(ロック済み)
Use the TAKE, DROP, FILTER and SORTBY functions to build dependent lists6分9秒
-
(ロック済み)
Create new lists by changing the PivotTable Report Layout to Tabular and adding repeating labels4分10秒
-
(ロック済み)
Rapid filtering by content, cell color, or font color via right-clicking3分31秒
-
(ロック済み)
Restructure column/row data using new WRAPROWS and WRAPCOLS functions6分2秒
-
(ロック済み)
Working with date and time-based data and the over-24-hour display issue5分25秒
-
(ロック済み)
Multiple tips for creating charts quickly5分44秒
-
(ロック済み)
Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions5分16秒
-
(ロック済み)
Overcoming rounding concerns in formulas with functions and decimal displays4分13秒
-
(ロック済み)
Highlighting PivotTable results with conditional formatting4分42秒
-
(ロック済み)
An overview of the 12 database functions in Excel5分21秒
-
(ロック済み)
Advantages and disadvantages of using pie charts to display data4分20秒
-
(ロック済み)
Rapid sorting via right-clicking options3分20秒
-
(ロック済み)
Converting charts into pictures3分50秒
-
(ロック済み)
Using three functions to track worksheet cells that are text, numbers, or formulas6分44秒
-
(ロック済み)
Using new BYROW and BYCOL functions to analyze data6分25秒
-
(ロック済み)
Create formulas rapidly with these shortcuts6分50秒
-
(ロック済み)
Exploring 3-D Column and 3-D Bar charts5分55秒
-
(ロック済み)
New VSTACK and HSTACK functions6分35秒
-
(ロック済み)
Calculating day of the week totals from a large transaction list5分27秒
-
(ロック済み)
Contrasating uses of the newer functions: XMATCH and XLOOKUP7分11秒
-
(ロック済み)
Various techniques for highlighting (selecting) cell ranges quickly7分25秒
-
(ロック済み)
Inserting special symbols using AutoCorrect options and the Insert Symbol command6分39秒
-
(ロック済み)
Reviewing Excel Information functions - ISBLANK, ISNUMBER, ISTEXT, etc.6分31秒
-
(ロック済み)
Manipulating text functions LEFT, MID, and TEXT to create new ID numbers5分10秒
-
(ロック済み)
Discovering timesaving tools in the Go To Special feature6分13秒
-
(ロック済み)
Calculating chronological and fiscal quarters6分10秒
-
(ロック済み)
Sorting by moving columns left/right - in tables, Pivot Tables, SORT and SORTBY5分37秒
-
(ロック済み)
Using Conditional Formatting for analysis and data emphasis6分11秒
-
(ロック済み)
Using Indent buttons to control text displays and currency formatting3分32秒
-
(ロック済み)
Create shapes and text boxes with content linked to worksheet cells5分2秒
-
(ロック済み)
Dynamically presenting data via chart slicers5分6秒
-
(ロック済み)
Sorting by day of month for birthday and anniversary lists3分34秒
-
(ロック済み)
Using wildcards (asterisk, question mark, and tilde) in formulas and commands7分32秒
-
(ロック済み)
Using SEARCH, FIND, and COUNT to tabulate data occurrences4分30秒
-
(ロック済み)
Comparing the Data Analysis Histogram feature and Excel's Histogram chart5分9秒
-
(ロック済み)
Using the AND and OR functions independently or within IF functions6分25秒
-
(ロック済み)
Use various techniques to flip lists upside-down or left-to-right4分52秒
-
(ロック済み)
Combine data with the TEXTJOIN, CONCAT, and CONCATENATE5分9秒
-
(ロック済み)
Use Excel's Advanced Options to fine-tune settings and increase efficiency5分19秒
-
(ロック済み)
Use ALT and other shortcuts when working with AutoComplete, Data Validation, etc.4分5秒
-
(ロック済み)
Use the powerful COUNTIF family—8 functions—for statistical analysis7分18秒
-
(ロック済み)
Show relationships between sets of values with a Scatter(XY) Chart7分4秒
-
(ロック済み)
Locate and track a worksheet's Data Validation rules and violations5分40秒
-
(ロック済み)
Use AGGREGATE to avoid errors and ignore hidden data5分52秒
-
(ロック済み)
Explore multiple approaches for locating, preventing, and deleting duplicate data5分20秒
-
(ロック済み)
Use a single SEQUENCE function to create various date layouts5分24秒
-
(ロック済み)
Combine a Validation list, XLOOKUP function, table, and chart to build a presentation model5分10秒
-
(ロック済み)
Pros and cons of using Stacked Area charts and Stacked Column Charts5分7秒
-
(ロック済み)
Nested use of FILTER, SORT, and CHOOSECOLS functions for selective column retrieval6分41秒
-
(ロック済み)
Learn about the new Office Theme, the default Aptos Font and new colors in M365 apps5分7秒
-
(ロック済み)
Analyze data using TOCOL, TOROW, LARGE, and SMALL4分49秒
-
(ロック済み)
Refine chart elements quickly with the powerful and overlooked Quick Layout button5分43秒
-
(ロック済み)
Tips and techniques for displaying Excel worksheets effectively during presentations6分51秒
-
(ロック済み)
Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions6分39秒
-
(ロック済み)
Using entire column (or row) references to create more dynamic formulas6分51秒
-
(ロック済み)
Using Excel's Accessibility Checker to follow best practices for those with disabilities5分10秒
-
(ロック済み)
Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data6分28秒
-
(ロック済み)
Create dynamic presentations with Slicers, Filters, and Charts6分39秒
-
(ロック済み)
Compare and contrast multiple column sorting with SORT and SORTBY9分8秒
-
(ロック済み)
Use keystroke and mouse shortcuts to display and navigate worksheets7分35秒
-
(ロック済み)
Show gain/loss in census figures with the RANK, IF, and LET functions7分28秒
-
(ロック済み)
Apply conditional formatting across data rows7分43秒
-
(ロック済み)
Expand and collapse date displays in PivotTables4分19秒
-
(ロック済み)
Use TODAY and NOW for real-time up-to-date calculations5分9秒
-
(ロック済み)
Use Freeze Panes and Split to view different worksheet portions7分19秒
-
(ロック済み)
Use CEILING and FLOOR for specialized numeric rounding needs6分31秒
-
(ロック済み)
Highlight negative positive values with Conditional Formatting and Data Bars5分56秒
-
(ロック済み)
Use AutoSum to simplify and accelerate formula creations4分44秒
-
(ロック済み)
Dynamic sheet name reference with INDIRECT5分27秒
-
(ロック済み)
Create custom and built-in lists to sort and fill in sequences8分11秒
-
(ロック済み)
Consolidate and split workbooks5分51秒
-
(ロック済み)
Expand, collapse and sort displayed results when using Subtotal6分39秒
-
(ロック済み)
Random number functions: RAND, RANDBETWEEN, and RANDARRAY5分48秒
-
(ロック済み)
Using the new GROUPBY and PIVOTBY functions6分28秒
-
(ロック済み)
Creating 3D and other formulas that use data from different worksheets7分34秒
-
(ロック済み)
Quick searching for menu commands with the right mouse button3分41秒
-
(ロック済み)
Using the new Checkbox button on the Insert tab4分13秒
-
(ロック済み)