MS Excel | Cornerstone Business Solutions https://www.cornerstoneresults.com Results for Business Wed, 04 Mar 2020 15:22:30 +0000 en-US hourly 1 10 Steps to Creating a Scrolling Excel Chart https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_10_steps_creating_scrolling_excel_chart.pdf#new_tab Sun, 20 Mar 2016 03:49:03 +0000 http://www.cornerstoneresults.com/?p=2452 10 Steps to Creating a Simple Break-Even Template in Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_10_steps_to_breakeven_template.pdf#new_tab Sun, 20 Mar 2016 03:50:59 +0000 http://www.cornerstoneresults.com/?p=2454 20 Principles for Good Spreadsheet Practice – PDF Document https://www.cornerstoneresults.com/20-principles-for-good-spreadsheet-practice/ Thu, 05 Jul 2018 00:54:05 +0000 https://www.cornerstoneresults.com/?p=3954 3 Tips for Using Excel’s Conditional Formatting More Efficiently https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_three_tips_conditional_formatting.pdf#new_tab Sun, 20 Mar 2016 03:44:31 +0000 http://www.cornerstoneresults.com/?p=2448 3 Ways to Fill Blank Cells in an Excel Spreadsheet https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_three_ways_to_fill_blankcells.pdf#new_tab Sun, 20 Mar 2016 03:46:38 +0000 http://www.cornerstoneresults.com/?p=2450 5 Tips for Enhancing MS Excel Charts https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_five_tips_excel_charts.pdf#new_tab Sun, 20 Mar 2016 22:01:03 +0000 http://www.cornerstoneresults.com/?p=2515 75 Essential Excel Tips https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_75_excel_tips.pdf#new_tab Sun, 20 Mar 2016 03:56:43 +0000 http://www.cornerstoneresults.com/?p=2456 85 Excel Keyboard Shortcuts https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_85_keyboard_shortcuts.pdf#new_tab Sun, 20 Mar 2016 03:58:30 +0000 http://www.cornerstoneresults.com/?p=2458 Add a Chart to a MS Excel Comment https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_chart_to_excel_comment.pdf#new_tab Sun, 20 Mar 2016 15:06:53 +0000 http://www.cornerstoneresults.com/?p=2460 ASAP Utilities – Simply a “Must Have” Add In for Serious MS Excel Users https://www.cornerstoneresults.com/asap-utilities-simply-a-must-have-add-in-for-serious-ms-excel-users/ Sun, 20 Mar 2016 15:12:32 +0000 http://www.cornerstoneresults.com/?p=2464 Calculate Conditional Running Totals in MS Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_calculate_conditional_running_totals_in_excel.pdf#new_tab Sun, 20 Mar 2016 15:23:01 +0000 http://www.cornerstoneresults.com/?p=2469 Choosing between Vlookup and Index-Match formulas https://www.cornerstoneresults.com/choosing-between-vlookup-and-index-match-formulas/ Wed, 04 Mar 2020 15:22:13 +0000 https://www.cornerstoneresults.com/?p=4122 Clean Up MS Excel Data of Printable Artifacts https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_clean_function.pdf#new_tab Sun, 20 Mar 2016 15:27:15 +0000 http://www.cornerstoneresults.com/?p=2472 Combine Text and Dates in the Same Cell https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_combine_text_and_date_in_same_cell.pdf#new_tab Sun, 20 Mar 2016 20:28:58 +0000 http://www.cornerstoneresults.com/?p=2475 Conditional Formatting to Find Locked and Unlocked Cells https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_conditional_formatting_locked_unlocked_cells.htm.pdf#new_tab Sun, 20 Mar 2016 20:32:05 +0000 http://www.cornerstoneresults.com/?p=2479 Copy Hundreds of Rows of Excel Formulas in Three Steps https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_copy_row_formulas_in_3_steps.pdf#new_tab Sun, 20 Mar 2016 20:41:53 +0000 http://www.cornerstoneresults.com/?p=2484 Count If Functions for Two Conditions https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_countif-function_for_2_conditions.pdf#new_tab Sun, 20 Mar 2016 20:40:01 +0000 http://www.cornerstoneresults.com/?p=2481 Create a List Box in MS Excel to Ensure Data Entry Accuracy https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_create_a_list_box.PDF#new_tab Sun, 20 Mar 2016 21:10:11 +0000 http://www.cornerstoneresults.com/?p=2492 Create a MS Excel Chart That Automatically Updates with New Data https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_auto_update_excel_chart.pdf#new_tab Sun, 20 Mar 2016 15:20:45 +0000 http://www.cornerstoneresults.com/?p=2466 Creating a Floating Column Chart in MS Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_creating_floating_column_chart.pdf#new_tab Sun, 20 Mar 2016 20:43:43 +0000 http://www.cornerstoneresults.com/?p=2486 Creating a Summary Report in MS Excel with Data Consolidation https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_create_summary_report_with_data_consolidation.pdf#new_tab Sun, 20 Mar 2016 20:45:06 +0000 http://www.cornerstoneresults.com/?p=2488 Creating an Index Sheet for a MS Excel Workbook https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_create_index_sheets_for_excel_workbook.pdf#new_tab Sun, 20 Mar 2016 21:02:38 +0000 http://www.cornerstoneresults.com/?p=2490 Cross Footing Logic – Avoiding Costly Errors https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_cross-footing_logic.pdf#new_tab Sun, 20 Mar 2016 21:21:17 +0000 http://www.cornerstoneresults.com/?p=2496 Customizing Workbook Printing in MS Excel https://www.cornerstoneresults.com/customize-workbook-printing-in-ms-excel/ Sun, 20 Mar 2016 21:29:43 +0000 http://www.cornerstoneresults.com/?p=2498 Data Entry: Built-In Functions to Simplify Data Entry https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_built-In_features_to_simplify_excel_data_entry.pdf#new_tab Sun, 20 Mar 2016 21:33:55 +0000 http://www.cornerstoneresults.com/?p=2501 Delete Duplicate Rows in a MS Excel Worksheet https://www.cornerstoneresults.com/deleting-duplicate-rows-in-a-ms-excel-worksheet/ Sun, 20 Mar 2016 21:42:21 +0000 http://www.cornerstoneresults.com/?p=2503 Documenting MS Excel Formulas https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_documenting_excel_formulas.pdf#new_tab Sun, 20 Mar 2016 21:49:33 +0000 http://www.cornerstoneresults.com/?p=2508 Enter MS Excel Data in Multiple Worksheets Simultaneously https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_enter_data_in_multiple_worksheets_simultaneously.pdf#new_tab Sun, 20 Mar 2016 21:52:25 +0000 http://www.cornerstoneresults.com/?p=2511 Find Matching MS Excel Data in Just Three Clicks https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_find_matching_records_in_excel.pdf#new_tab Sun, 20 Mar 2016 21:54:30 +0000 http://www.cornerstoneresults.com/?p=2513 Forecast the Future with MS Excel Trendlines http://www.techrepublic.com/article/forecast-the-future-with-excel-trendlines/#new_tab Sun, 20 Mar 2016 22:34:23 +0000 http://www.cornerstoneresults.com/?p=2527 Format MS Excel Sparklines to Expose Details https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_format_Excel_%202010_sparklines.pdf#new_tab Sun, 20 Mar 2016 22:04:26 +0000 http://www.cornerstoneresults.com/?p=2517 Formula Auditing Better in MS Excel with the Explode Add-In https://www.cornerstoneresults.com/formula-auditing-better-in-ms-excel-with-the-explode-add-in/ Sun, 20 Mar 2016 22:42:50 +0000 http://www.cornerstoneresults.com/?p=2529 Free MS Excel Template Listing – Lots of Good Ones! http://www.exinfm.com/free_spreadsheets.html#new_tab Sun, 20 Mar 2016 22:48:28 +0000 http://www.cornerstoneresults.com/?p=2531 Give Your MS Excel Charts a Makeover https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_give_your_charts_a_makeover.pdf#new_tab Sun, 20 Mar 2016 22:50:22 +0000 http://www.cornerstoneresults.com/?p=2534 Hidden Gems in MS Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_hidden_gems_in_excel_2007.pdf#new_tab Sun, 20 Mar 2016 22:07:29 +0000 http://www.cornerstoneresults.com/?p=2520 How to Add a Dropdown List to MS Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_how_to_add_dropdown_list_to_excel.pdf#new_tab Sun, 20 Mar 2016 22:10:35 +0000 http://www.cornerstoneresults.com/?p=2522 How to Find Duplicates in MS Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_how_find_duplicates.pdf#new_tab Sun, 20 Mar 2016 22:11:54 +0000 http://www.cornerstoneresults.com/?p=2524 How to Prevent MS Excel from Turning Fractions Into Dates https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_prevent_excel_from_turning_fractions_into_dates.pdf#new_tab Sun, 20 Mar 2016 22:53:14 +0000 http://www.cornerstoneresults.com/?p=2536 Inserting and Using the Calendar Control Object https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_calendar_object.pdf#new_tab Sun, 20 Mar 2016 23:11:57 +0000 http://www.cornerstoneresults.com/?p=2538 Integrating MS Excel Into a MS Word Document https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_word_integrating_Excel_into_Word.pdf#new_tab Wed, 23 Mar 2016 23:21:47 +0000 http://www.cornerstoneresults.com/?p=2639 Keyboard Shortcut List for MS Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_keyboard_shortcuts.pdf#new_tab Sun, 20 Mar 2016 23:16:11 +0000 http://www.cornerstoneresults.com/?p=2541 Making Subtotal Values Standout in MS Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_make_subtotal_values_stand_out.pdf#new_tab Sun, 20 Mar 2016 23:27:09 +0000 http://www.cornerstoneresults.com/?p=2543 Manipulating Data with MS Excel Pivot Tables https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_manipulate_data_with_excel_%20pivot_tables.PDF#new_tab Sun, 20 Mar 2016 23:29:28 +0000 http://www.cornerstoneresults.com/?p=2545 Pivot Table Magic https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_pivot_table_magic.pdf#new_tab Sun, 20 Mar 2016 23:31:23 +0000 http://www.cornerstoneresults.com/?p=2547 Placing Multiple Charts on a MS Excel Chart Sheet https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_place_multiple_charts.pdf#new_tab Sun, 20 Mar 2016 23:34:03 +0000 http://www.cornerstoneresults.com/?p=2549 Populate a Dynamic Dropdown List https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_populate_combo_box_w_dynamic_dropdown_list.pdf#new_tab Sun, 20 Mar 2016 23:36:35 +0000 http://www.cornerstoneresults.com/?p=2551 Power Pivot and Power Query in MS Excel 2013 https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_power_bi_in_excel_2013_redefines_the_spreadsheet.pdf#new_tab Sun, 20 Mar 2016 23:42:21 +0000 http://www.cornerstoneresults.com/?p=2554 Putting MS Excel’s Table Feature to Work for You https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_putting_tables_to_work_for_you.pdf#new_tab Sun, 20 Mar 2016 23:47:02 +0000 http://www.cornerstoneresults.com/?p=2556 Reduce Repetitive Worksheet Typing by Using Formulas https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_reduce_typing_w_excel_formulas.pdf#new_tab Sun, 20 Mar 2016 23:50:32 +0000 http://www.cornerstoneresults.com/?p=2559 Sort Four or More Columns of Data – Another Approach https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_sorting_4_or_more.pdf#new_tab Mon, 21 Mar 2016 00:40:15 +0000 http://www.cornerstoneresults.com/?p=2565 Sort Four or More Columns of Data Simultaneously https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_sort_4_or_more_columns_of_excel_Data_simultaneously.pdf#new_tab Sun, 20 Mar 2016 23:56:32 +0000 http://www.cornerstoneresults.com/?p=2563 Sum Subtotals in a Filtered MS Excel List https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_sum_values_in_filtered_list.pdf#new_tab Mon, 21 Mar 2016 00:41:55 +0000 http://www.cornerstoneresults.com/?p=2567 Trapping Errors in MS Excel Formulas https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_trapping_errors.pdf#new_tab Mon, 21 Mar 2016 00:43:26 +0000 http://www.cornerstoneresults.com/?p=2569 Two Dynamic MS Excel Chart Enhancements https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_two_dynamic_chart_enhancements.pdf#new_tab Mon, 21 Mar 2016 00:45:59 +0000 http://www.cornerstoneresults.com/?p=2571 Understanding Excel’s Conditional Formatting Rules Can Help Prevent Unintended Results http://www.techrepublic.com/blog/microsoft-office/learn-how-excel-applies-conditional-formatting-rules-to-avoid-unintended-results/?ftag=TREe331754&bhid=20245482075908281169200638744010#new_tab Tue, 06 Jun 2017 18:25:57 +0000 http://www.cornerstoneresults.com/?p=3807 Use a Function to Count Cells Between Two Values in MS Excel https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_use_function_to_count_%20cells_between_two_values.pdf#new_tab Mon, 21 Mar 2016 00:48:16 +0000 http://www.cornerstoneresults.com/?p=2573 Use Editing, Fill and Justify to Add Instructions to a MS Excel Worksheet https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_use_editing_fill_&_justify_to_add_instr_to_excel.pdf#new_tab Mon, 21 Mar 2016 00:51:19 +0000 http://www.cornerstoneresults.com/?p=2575 Use SUM in an Array Function to Count Values that Match Multiple Criteria https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_use_SUM_in_array_funct_to_count_values_with_multiple_criteria.pdf#new_tab Mon, 21 Mar 2016 00:57:52 +0000 http://www.cornerstoneresults.com/?p=2578 Using the COUNTBLANK Function in Building Financial Statements https://www.cornerstoneresults.com/using-the-countblank-function-in-building-financial-statements/ Mon, 21 Mar 2016 01:01:52 +0000 http://www.cornerstoneresults.com/?p=2580 Using the COUNTIF Function to Break Ties https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_using_countif_to_break_ties.pdf#new_tab Mon, 21 Mar 2016 01:04:15 +0000 http://www.cornerstoneresults.com/?p=2583 What is a MS Excel Macro and Why Should You Care? https://www.cornerstoneresults.com/RefLib/KnlgeBk/mso_ms_excel_what_is_a_macro.pdf#new_tab Mon, 21 Mar 2016 01:06:46 +0000 http://www.cornerstoneresults.com/?p=2585