Differences

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

--- generalreference:excel [2020/04/09 18:31]
shinoh [Data > Data Validation]
+++ generalreference:excel [2020/07/06 20:59] (current)
@@ Line 5: / Line 5: @@
 ===== EXCEL QUICK REFERENCE =====
+  * [[+tab|:generalreference:excel_datavalid|Inserting drop-down - Data Validation]]
+  * [[+tab|:generalreference:excel_formulas|Frequently used Excel formulas]]
+  * [[+tab|:generalreference:excel_freeze|Freeze/unfreeze rows/colums]]
+  * [[+tab|:generalreference:excel_countif|Count unique texts in a range with COUNTIF]]
+  * [[+tab|:generalreference:excel_pivotconcistency|How to use Pivot table for consistency check]]
+  * [[+tab|:generalreference:excel_links|EXCEL Tutorials and useful links]]
 ===== 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|}}
 {{:generalreference:excel:dialogue.png|}}
-----
-==== 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 > Group/Ungroup ====
+<color #ed1c24>**NO CONTENT TO TRANSFER**</color>
 //VIDEO clip on to be inserted//
@@ Line 32: / 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 59: / 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 78: / Line 76: @@
 ==== 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 90: / Line 89: @@
 ----
 ===== Input message =====
+<color #ed1c24>**THIS AND THE TWO BELOW HAVE NO CONTENT TO TRANSFER.**</color>
 ----
@@ Line 103: / 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 108: / 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 115: / 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}}
-{{ :generalreference:excel:using_pivot_tables_for_consistency_check.pptx |
-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.