Differences

This shows you the differences between two versions of the page.

--- generalreference:excel [2018/11/12 17:55]
shinoh [How to use Pivot table for consistency check - by Tanya]
+++ generalreference:excel [2020/07/06 20:59] (current)
@@ Line 1: / Line 1: @@
-//**[[:start|Go to cApStAn HOME]]**//
+//**[[:start|Go to cApStAn HOME]]**// \\
+//**[[generalreference:start#general_reference|Go To General Reference Home]]**//
 ===== EXCEL QUICK REFERENCE =====
-Good tutorial sites:
+  * [[+tab|:generalreference:excel_datavalid|Inserting drop-down - Data Validation]]
+  * [[+tab|:generalreference:excel_formulas|Frequently used Excel formulas]]
-http://www.excel-easy.com
+  * [[+tab|:generalreference:excel_freeze|Freeze/unfreeze rows/colums]]
+  * [[+tab|:generalreference:excel_countif|Count unique texts in a range with COUNTIF]]
-https://exceljet.net/
+  * [[+tab|:generalreference:excel_pivotconcistency|How to use Pivot table for consistency check]]
+  * [[+tab|:generalreference:excel_links|EXCEL Tutorials and useful links]]
-VBA (Visual Basic Application): https://www.youtube.com/watch?v=ABXPb0qnKUY
-==== Frequently Used FORMULA ====
-  * IF
-  * COUNTIF
-  * =COUNTIF(rng,">200"): Count cells greater than 200
-  * =WORKDAY (start_date, days, [holidays])
-  * =end_date-TODAY(): Calculate days remaining
-==== Count unique texts in a range with COUNTIF ====
-Formula: **SUMPRODUCT(1/COUNTIF(data range,data range))**
-{{ :generalreference:excel:excel_count_unique_text_1.png |}}
 ===== Stop rows being inserted or deleted in Excel =====
+<color #ed1c24>**NOT MOVED TO ODOO, DOES NOT SEEM VERY HELPFUL (AND COULD NOT EVEN FIGURE OUT HOW THIS WORKS). FOR THIS PURPOSE, ONE CAN USE PROTECTION, SEE ARTICLE BELOW.**</color>
 {{:generalreference:excel:stop_rows_being_inserted_or_deleted_in_excel.png|}}
@@ Line 32: / Line 20: @@
 ----
-==== Freezing/Unfreezing Panes ====
-On the View tab, in the Window group, click the arrow below Freeze Panes.
-{{:generalreference:excel:excel_freeze_1.gif|}}
-//VIDEO clip to be inserted//
-----
-==== Data > List (drop down menu) ====
-**Data > Data Validation**
-{{:generalreference:excel:excel_drop_down_data_validation.png|}}
-----
 ==== Data > Group/Ungroup ====
+<color #ed1c24>**NO CONTENT TO TRANSFER**</color>
 //VIDEO clip on to be inserted//
@@ Line 56: / Line 29: @@
 ==== Locking cells: Home > Font ====
+**<color #ed1c24>TRANSFERRED TO ODOO IN UPDATED FORM. IF YOU WISH TO MAKE CHANGES, PLEASE CONTACT LAURA OR SHINOH.</color>**
 Step 1
@@ Line 83: / Line 56: @@
 ==== Protect sheet: Review> Protect sheet ====
+<color #ed1c24>**NO CONTENT TO TRANSFE**R</color>
 ----
 ==== How to remove the password encryption ====
+**<color #ed1c24>NOT TRANSFERRED AS NOT CLEAR IF THIS IS HELPFUL - IS THIS ONLY ABOUT UNPROTECTING THE SHEET?</color>**
 In the workbook you want to remove the password encryption, click **File > Info**, click the Protect Workbook button, and select Encrypt with Password in the drop-down menu.
@@ Line 100: / Line 74: @@
 ----
-==== Data > Data Validation =====
-----
 ==== Combine data from 2 cells (e.g. text) =====
+<color #ed1c24>**MOVED TO ODOO. IF YOU WISH TO MAKE CHANGES, CONTACT LAURA OR SHINOH.**</color>
 You can combine data from multiple cells into a single cell using the Ampersand symbol (&).
@@ Line 116: / Line 89: @@
 ----
 ===== Input message =====
+<color #ed1c24>**THIS AND THE TWO BELOW HAVE NO CONTENT TO TRANSFER.**</color>
 ----
@@ Line 129: / Line 102: @@
 ==== How to convert CSV ====
+**<color #ed1c24>THE BELOW ARTICLE HAS BEEN MOVED TO ODOO. IF YOU WISH TO MAKE CHANGES, PLEASE CONTACT SHINOH OR LAURA</color>.**
 [[tecdoc:csv2xls|How to save CSV as Excel]]
@@ Line 134: / Line 108: @@
 ===== Pivot Tables =====
+<color #ed1c24>**MOVED TO ODOO UNDER 'USEFUL RESOURCES FOR EXCEL'**.</color>
 There are many tutorials on the Web explaining what a pivot table is and how to create one.
@@ Line 141: / Line 116: @@
 [[http://www.excelfunctions.net/Excel-Pivot-Table-Tutorial.html|External Link]]
-====How to use Pivot table for consistency check - by Tanya====
-{{ :generalreference:excel:excel_pivot_consistency_instructions_video_part_1.mp4 |PART 1}}
-PART 1
-{{ :generalreference:excel:excel_pivot_consistency_instructions_video_part_2.mp4 |PART 2}}
-PART 2
-{{ :generalreference:excel:excel_pivot_consistency_instructions_video_part_3.mp4 |PART 3}}
-PART 3
-Excel files used in the video clips:
-  * {{ :generalreference:excel:pivot_tables_adaptations.xlsx |Adaptations}}
-  * {{ :generalreference:excel:pivot_tables_attribute.xlsx |Attribute}}
-  * {{ :generalreference:excel:pivot_tables_identical_segments.xlsx |Identical segments}}
-The PowerPoint used in the video clips
-----
 ==== Extra Quotation Marks ====
+<color #ed1c24>**MOVED TO ODOO. IF YOU WISH TO MAKE CHANGES, PLEASE CONTACT LAURA OR SHINOH.**</color>
 When copying cells that contain multiple lines separated by one or several line breaks, the pasted text will have extra quotation marks.