Microsoft Excel Tips – Part Three | Cornerstone Business Solutions https://www.cornerstoneresults.com Results for Business Wed, 26 May 2021 13:45:01 +0000 en-US hourly 1 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 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 Using VBA to Generate a List of Sheet Names https://www.cornerstoneresults.com/using-vba-to-generate-a-list-of-sheet-names/ Wed, 26 May 2021 13:45:01 +0000 https://www.cornerstoneresults.com/?p=4176 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