{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Excel","Access"],"not_rendered":{"charts":0,"images":187,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Excel","index":0,"n_rows":179,"n_cols":11,"rows_kept":179,"cut":false,"hidden":false,"merged":[]}
[]
[null,"تصویر","عنوان","تاریخ انتشار","تاریخ آپدیت","گروه","برچسب","نظرات","لینک تصویر","لینک مطلب","روز پیش"]
[null,{"$f":"_xlfn.IMAGE(I3)","v":{"$error":"#VALUE!"}},"سند خروج از انبار بر اساس محصول",14030501,14030501,"آموزش اکسل","انبارداری","N/A","https://officebaz.ir/ex/wp-content/uploads/2024/07/Warehouse1-1.jpg","https://officebaz.ir/ex/%d8%a7%d9%86%d8%a8%d8%a7%d8%b1%d8%af%d8%a7%d8%b1%db%8c-%d9%be%db%8c%d8%b4%d8%b1%d9%81%d8%aa%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E3,shamsi())","v":10}]
[null,{"$f":"_xlfn.IMAGE(I4)","v":{"$error":"#VALUE!"}},"تابع LET در اکسل ، استفاده از متغیر در فرمول نویسی",14030424,14030501,"توابع اکسل","LET","N/A","https://officebaz.ir/ex/wp-content/uploads/2024/07/Let6.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-let-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d8%8c-%d9%86%d8%a7%d9%85%da%af%d8%b0%d8%a7%d8%b1%db%8c-%d9%85%d8%ad%d8%a7%d8%b3%d8%a8%d8%a7%d8%aa-%d9%88-%d8%ae%d9%84%d8%a7%d8%b5/",{"$f":"diff(E4,shamsi())","v":10}]
[null,{"$error":"#VALUE!"},"انبارداری ساده در اکسل و پیشنهادات دیگر و آموزش",14010416,14030501,"پروژه های اکسل","SUMIFS, انبارداری, فایلهای کاربردی اکسل","100 comments","https://officebaz.ir/ex/wp-content/uploads/2022/07/Anbar4.png","https://officebaz.ir/ex/%d8%a7%d9%86%d8%a8%d8%a7%d8%b1%d8%af%d8%a7%d8%b1%db%8c-%d8%b3%d8%a7%d8%af%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-1401/",{"$f":"diff(E5,shamsi())","v":10}]
[null,{"$error":"#VALUE!"},"فاکتور فروش رایگان تحت اکسل و استفاده در موبایل",14000702,14030428,"پروژه های اکسل","فاکتور فروش","42 comments","https://officebaz.ir/ex/wp-content/uploads/2021/09/Invoice3.png","https://officebaz.ir/ex/24-%d9%81%d8%a7%da%a9%d8%aa%d9%88%d8%b1-%d9%81%d8%b1%d9%88%d8%b4-%d8%b3%d8%a7%d8%af%d9%87-%d8%a7%da%a9%d8%b3%d9%84-%d9%82%d8%a7%d8%a8%d9%84%db%8c%d8%aa-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87/",{"$f":"diff(E6,shamsi())","v":14}]
[null,{"$error":"#VALUE!"},"یکی کردن شیتهای اکسل با 2 روش",14030411,14030411,"آموزش اکسل","FILTER","N/A","https://officebaz.ir/ex/wp-content/uploads/2024/07/SheetsCombine.jpg","https://officebaz.ir/ex/%db%8c%da%a9%db%8c-%da%a9%d8%b1%d8%af%d9%86-%d8%b4%db%8c%d8%aa%d9%87%d8%a7%db%8c-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d8%a7-2-%d8%b1%d9%88%d8%b4-%d9%85%d8%aa%d9%81%d8%a7%d9%88%d8%aa/",{"$f":"diff(E7,shamsi())","v":24}]
[null,{"$error":"#VALUE!"},"دو روش ساده برای تبدیل عدد به حروف در اکسل",14000302,14030407,"آموزش اکسل","ابزارهای فارسی, فایلهای کاربردی اکسل","86 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/ABH-1.jpg","https://officebaz.ir/ex/%d8%aa%d8%a8%d8%af%db%8c%d9%84-%d8%b9%d8%af%d8%af-%d8%a8%d9%87-%d8%ad%d8%b1%d9%88%d9%81-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E8,shamsi())","v":28}]
[null,{"$error":"#VALUE!"},"تابع SWITCH اکسل جایگزین تابع IF",14030321,14030322,"توابع اکسل","IF, SWITCH","N/A","https://officebaz.ir/ex/wp-content/uploads/2024/06/SWITCH.png","https://officebaz.ir/ex/switch/",{"$f":"diff(E9,shamsi())","v":51}]
[null,{"$error":"#VALUE!"},"ایجاد یک دفترچه اقساط در اکسل",14000307,14030320,"پروژه های اکسل","ابزارهای فارسی, تاریخ شمسی","81 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/AghsatMain.png","https://officebaz.ir/ex/aghsat/",{"$f":"diff(E10,shamsi())","v":46}]
[null,{"$error":"#VALUE!"},"تابع SUMIFS اکسل",14011018,14030306,"توابع اکسل","SUMIFS","5 comments","https://officebaz.ir/ex/wp-content/uploads/2023/01/SUMIFS.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-sumifs-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E11,shamsi())","v":60}]
[null,{"$error":"#VALUE!"},"نمایش فروش ماهانه در اکسل از تاریخ شمسی",14021111,14030228,"تاریخ شمسی",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2024/01/Filter2.jpg","https://officebaz.ir/ex/%d9%81%d8%b1%d9%88%d8%b4-%d9%85%d8%a7%d9%87%d8%a7%d9%86%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E12,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"آموزش ساخت تقویم شمسی در اکسل",14020709,14030228,"پروژه های اکسل, تاریخ شمسی","TEXT, TEXTJOIN, ابزارهای فارسی, تاریخ شمسی","17 comments","https://officebaz.ir/ex/wp-content/uploads/2023/10/Taghvim4.png","https://officebaz.ir/ex/%d8%aa%d9%82%d9%88%db%8c%d9%85-%d8%b4%d9%85%d8%b3%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-1402/",{"$f":"diff(E13,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"جمع بین دو تاریخ در اکسل با 5 روش مختلف",14020412,14030228,"آموزش اکسل, تاریخ شمسی","FILTER, INDEX, SUMIFS, XLOOKUP","3 comments","https://officebaz.ir/ex/wp-content/uploads/2023/07/SumIfs2.png","https://officebaz.ir/ex/%d8%ac%d9%85%d8%b9-%d8%a8%db%8c%d9%86-%d8%af%d9%88-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E14,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"محاسبه سابقه کار در اکسل ، اختلاف بین دو تاریخ",14020318,14030228,"آموزش اکسل, تاریخ شمسی","FILTER, تاریخ شمسی","7 comments","https://officebaz.ir/ex/wp-content/uploads/2023/06/Sabegheh1.png","https://officebaz.ir/ex/%d9%85%d8%ad%d8%a7%d8%b3%d8%a8%d9%87-%d8%b3%d8%a7%d8%a8%d9%82%d9%87-%da%a9%d8%a7%d8%b1-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E15,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"اضافه کردن ماه به تاریخ شمسی",14020308,14030228,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/27-Shamsi-2.7.0.jpg","https://officebaz.ir/ex/27-%d8%a7%d8%b6%d8%a7%d9%81%d9%87-%da%a9%d8%b1%d8%af%d9%86-%d9%85%d8%a7%d9%87-%d8%a8%d9%87-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%b4%d9%85%d8%b3%db%8c/",{"$f":"diff(E16,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"به دست آوردن سن افراد در اکسل",14020213,14030228,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/13-Sen.jpg","https://officebaz.ir/ex/13-%d8%b3%d9%86-%d8%a7%d9%81%d8%b1%d8%a7%d8%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E17,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"نکات پیشرفته تاریخ شمسی اکسل",14011226,14030228,"آموزش اکسل","ابزارهای فارسی, تاریخ شمسی","3 comments","https://officebaz.ir/ex/wp-content/uploads/2023/03/ShamsiPro2.jpg","https://officebaz.ir/ex/%d9%86%da%a9%d8%a7%d8%aa-%d9%be%db%8c%d8%b4%d8%b1%d9%81%d8%aa%d9%87-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%b4%d9%85%d8%b3%db%8c-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E18,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"لیست ماههای شمسی و نام روزهای هفته با یک کلیک",14011004,14030228,"آموزش اکسل, تاریخ شمسی","ابزارهای فارسی, تاریخ شمسی","3 comments","https://officebaz.ir/ex/wp-content/uploads/2022/12/MonthName1.png","https://officebaz.ir/ex/%d9%84%db%8c%d8%b3%d8%aa-%d9%85%d8%a7%d9%87%d9%87%d8%a7%db%8c-%d8%b4%d9%85%d8%b3%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-1401/",{"$f":"diff(E19,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"روزهای کاری و تعطیلات در اکسل",14000307,14030228,"آموزش اکسل, تاریخ شمسی","ابزارهای فارسی, تاریخ شمسی","3 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/hollyday.jpg","https://officebaz.ir/ex/%d8%aa%d8%b9%d8%b7%db%8c%d9%84%d8%a7%d8%aa-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d9%88-%d9%85%d8%ad%d8%a7%d8%b3%d8%a8%d9%87-%d8%b1%d9%88%d8%b2%d9%87%d8%a7%db%8c-%da%a9%d8%a7%d8%b1%db%8c/",{"$f":"diff(E20,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"یادآوری تاریخ تولد و سررسید چک در اکسل",14000307,14030228,"آموزش اکسل, تاریخ شمسی","ابزارهای فارسی, تاریخ شمسی, حسابداری در اکسل","3 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Cheque.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%aa%d9%88%d9%84%d8%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E21,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"بررسی صحت تاریخ شمسی در اکسل",14000306,14030228,"آموزش اکسل, تاریخ شمسی","AND, IF, IFERROR, ابزارهای فارسی, تاریخ شمسی","9 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/VAlidDate.jpg","https://officebaz.ir/ex/%d8%b5%d8%ad%d8%aa-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%b4%d9%85%d8%b3%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E22,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"تبدیل تاریخ میلادی به شمسی در اکسل",14000306,14030228,"آموزش اکسل, تاریخ شمسی","ابزارهای فارسی, تاریخ شمسی","8 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Convert.jpg","https://officebaz.ir/ex/%d8%aa%d8%a8%d8%af%db%8c%d9%84-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E23,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"اختلاف بین دو تاریخ شمسی در اکسل",14000306,14030228,"آموزش اکسل, تاریخ شمسی","ابزارهای فارسی, تاریخ شمسی","100 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Shamsi2.jpg","https://officebaz.ir/ex/%d8%a7%d8%ae%d8%aa%d9%84%d8%a7%d9%81-%d8%a8%db%8c%d9%86-%d8%af%d9%88-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%b4%d9%85%d8%b3%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E24,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"توابع مهم ماژول تاریخ شمسی",14000306,14030228,"آموزش اکسل, تاریخ شمسی","ابزارهای فارسی, تاریخ شمسی, دانلود","26 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Shamsi1-2.jpg","https://officebaz.ir/ex/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%b4%d9%85%d8%b3%db%8c-%d8%a7%da%a9%d8%b3%d9%84-%d9%be%d8%b1%da%a9%d8%a7%d8%b1%d8%a8%d8%b1%d8%af-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-%d9%85%d8%ab%d8%a7%d9%84/",{"$f":"diff(E25,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"تاریخ شمسی در اکسل | ورژنهای مختلف",14000306,14030228,"تاریخ شمسی","ابزارهای فارسی, تاریخ شمسی","100 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Shamsi3.jpg","https://officebaz.ir/ex/%d8%a7%d9%81%d8%b2%d9%88%d8%af%d9%86-%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%b4%d9%85%d8%b3%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d9%86%d8%b3%d8%ae%d9%87-2/",{"$f":"diff(E26,shamsi())","v":69}]
[null,{"$error":"#VALUE!"},"تابع IF",14000307,14030227,"توابع اکسل","IF","14 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/IF.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-if-%d9%88-%d9%86%d8%ad%d9%87-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-%d8%a2%d9%86-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-%d9%85%d8%ab%d8%a7%d9%84%d9%87/",{"$f":"diff(E27,shamsi())","v":70}]
[null,{"$error":"#VALUE!"},"کاراکترهای خاص در اکسل ، وایلدکارت",14030222,14030223,"آموزش اکسل","واژه نامه اکسل","N/A","https://officebaz.ir/ex/wp-content/uploads/2024/05/WILDCARD5.png","https://officebaz.ir/ex/wildcard/",{"$f":"diff(E28,shamsi())","v":74}]
[null,{"$error":"#VALUE!"},"استفاده از کد نویسی VLOOKUP در زمان ورود داده تکراری",14010926,14030218,"آموزش اکسل","VLOOKUP","1 comments","https://officebaz.ir/ex/wp-content/uploads/2022/12/VLOOKUPDUPLICATE3.png","https://officebaz.ir/ex/%da%a9%d8%af-%d9%86%d9%88%db%8c%d8%b3%db%8c-vlookup/",{"$f":"diff(E29,shamsi())","v":79}]
[null,{"$error":"#VALUE!"},"ترفند جالب تابع VLOOKUP نمایش داده های ستون قبلی",14010713,14030218,"آموزش اکسل","VLOOKUP, نکات کاربردی اکسل","4 comments","https://officebaz.ir/ex/wp-content/uploads/2022/10/VLOOKUP-CHOOSE3.png","https://officebaz.ir/ex/%d8%aa%d8%b1%d9%81%d9%86%d8%af-vlookup-2-%d8%b3%d8%aa%d9%88%d9%86-%d9%82%d8%a8%d9%84%db%8c/",{"$f":"diff(E30,shamsi())","v":79}]
[null,{"$error":"#VALUE!"},"استفاده از VLOOKUP و نام شیت و دو شرط",14010624,14030218,"آموزش اکسل","VLOOKUP","3 comments","https://officebaz.ir/ex/wp-content/uploads/2022/09/VLOOKUP.png","https://officebaz.ir/ex/%d9%88%db%8c%d9%84%d9%88%da%a9%d8%a7%d9%be-%d8%a8%d8%a7-%d8%af%d9%88-%d8%b4%d8%b1%d8%b7-%d8%b4%d9%87%d8%b1%db%8c%d9%88%d8%b1-401/",{"$f":"diff(E31,shamsi())","v":79}]
[null,{"$error":"#VALUE!"},"استفاده از VLOOKUP با 2 شرط در اکسل",14010408,14030218,"آموزش اکسل","MATCH, VLOOKUP, نکات کاربردی اکسل","2 comments","https://officebaz.ir/ex/wp-content/uploads/2022/06/TwoCriteria.png","https://officebaz.ir/ex/vlookup-%d8%a8%d8%a7-2-%d8%b4%d8%b1%d8%b7/",{"$f":"diff(E32,shamsi())","v":79}]
[null,{"$error":"#VALUE!"},"تابع VLOOKUP اکسل",14000307,14030218,"توابع اکسل","VLOOKUP","21 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/VLOOKUP2-2.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-vlookup/",{"$f":"diff(E33,shamsi())","v":79}]
[null,{"$error":"#VALUE!"},"ایجاد یک فایل حقوق و دستمزد در اکسل",14000307,14030209,"پروژه های اکسل","ابزارهای فارسی, حسابداری در اکسل","19 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Salary.jpg","https://officebaz.ir/ex/%d8%a7%db%8c%d8%ac%d8%a7%d8%af-%db%8c%da%a9-%d9%81%d8%a7%db%8c%d9%84-%d8%ad%d9%82%d9%88%d9%82-%d9%88-%d8%af%d8%b3%d8%aa%d9%85%d8%b2%d8%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E34,shamsi())","v":88}]
[null,{"$error":"#VALUE!"},"تابع FILTER",14000410,14030208,"توابع اکسل","FILTER","44 comments","https://officebaz.ir/ex/wp-content/uploads/2021/07/Filter.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-filter-%d8%a8%d8%a7-%d9%85%d8%ab%d8%a7%d9%84%d9%87%d8%a7%db%8c-%d9%85%d8%ae%d8%aa%d9%84%d9%81/",{"$f":"diff(E35,shamsi())","v":89}]
[null,{"$error":"#VALUE!"},"تابع XLOOKUP با چند شرط و video آموزشی",14030116,14030206,"آموزش اکسل","XLOOKUP","N/A","https://officebaz.ir/ex/wp-content/uploads/2024/04/XLOOKUP1.png","https://officebaz.ir/ex/xlookup-multi-criteria-video/",{"$f":"diff(E36,shamsi())","v":91}]
[null,{"$error":"#VALUE!"},"تابع XLOOKUP",14000412,14030206,"توابع اکسل","XLOOKUP","51 comments","https://officebaz.ir/ex/wp-content/uploads/2021/07/XLOOKUP.jpg","https://officebaz.ir/ex/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%da%a9%d8%a7%d9%85%d9%84-%d8%aa%d8%a7%d8%a8%d8%b9-xlookup-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-10-%d9%85%d8%ab%d8%a7%d9%84/",{"$f":"diff(E37,shamsi())","v":91}]
[null,{"$error":"#VALUE!"},"اضافه کردن امکانات ویژه اکسل Personal Macro",14021011,14030204,"آموزش اکسل","فایلهای کاربردی اکسل, نکات کاربردی اکسل","13 comments","https://officebaz.ir/ex/wp-content/uploads/2023/12/PersonalMacro3.png","https://officebaz.ir/ex/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E38,shamsi())","v":93}]
[null,{"$error":"#VALUE!"},"تبدیل فایلهای PDF به اکسل",14000627,14030204,"آموزش اکسل","نکات کاربردی اکسل","11 comments","https://officebaz.ir/ex/wp-content/uploads/2021/09/PDFTOEXCEL2.jpg","https://officebaz.ir/ex/24-%d8%aa%d8%a8%d8%af%db%8c%d9%84-pdf-%d8%a8%d9%87-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d8%af%d9%88%d9%86-%d8%a8%d9%87%d9%85-%d8%b1%db%8c%d8%ae%d8%aa%da%af%db%8c/",{"$f":"diff(E39,shamsi())","v":93}]
[null,{"$error":"#VALUE!"},"ایجاد تنخواه ساده در اکسل به همراه دانلود رایگان",14001011,14030202,"پروژه های اکسل","فایلهای کاربردی اکسل","20 comments","https://officebaz.ir/ex/wp-content/uploads/2022/01/Tankhah3-1.png","https://officebaz.ir/ex/28-%d8%aa%d9%86%d8%ae%d9%88%d8%a7%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-%d8%a2%d9%85%d9%88%d8%b2%d8%b4/",{"$f":"diff(E40,shamsi())","v":95}]
[null,{"$error":"#VALUE!"},"تابع ADDRESS",14030131,14030131,"توابع اکسل","ADDRESS","N/A","https://officebaz.ir/ex/wp-content/uploads/2024/04/ADDRESS1.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-address/",{"$f":"diff(E41,shamsi())","v":97}]
[null,{"$error":"#VALUE!"},"تقسیم مخارج گروهی در اکسل بسیار ساده و راحت",14000922,14021226,"پروژه های اکسل","ابزارهای فارسی, فایلهای کاربردی اکسل","57 comments","https://officebaz.ir/ex/wp-content/uploads/2021/12/Share1.png","https://officebaz.ir/ex/30-%d8%aa%d9%82%d8%b3%db%8c%d9%85-%d9%85%d8%ae%d8%a7%d8%b1%d8%ac-%da%af%d8%b1%d9%88%d9%87%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E42,shamsi())","v":131}]
[null,{"$error":"#VALUE!"},"ایجاد نرم افزار مادرخرج در اکسل",14000307,14021226,"آموزش اکسل","ابزارهای فارسی, حسابداری در اکسل","19 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Makhrej.jpg","https://officebaz.ir/ex/%d9%85%d8%af%db%8c%d8%b1%db%8c%d8%aa-%d9%85%d8%ae%d8%a7%d8%b1%d8%ac-%d8%b3%d9%81%d8%b1-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E43,shamsi())","v":131}]
[null,{"$error":"#VALUE!"},"ایجاد رمز عبور در اکسل و پسورد استاندارد",14021122,14021122,"آموزش اکسل","CHOOSE, RANDBETWEEN","2 comments","https://officebaz.ir/ex/wp-content/uploads/2024/02/Password2.png","https://officebaz.ir/ex/%d8%b1%d9%85%d8%b2-%d8%b9%d8%a8%d9%88%d8%b1-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E44,shamsi())","v":165}]
[null,{"$error":"#VALUE!"},"روشهای مختلف قرعه کشی در اکسل و اعداد تصادفی",14000325,14021103,"آموزش اکسل","RANDBETWEEN, نکات کاربردی اکسل","22 comments","https://officebaz.ir/ex/wp-content/uploads/2021/06/Lottary.jpg","https://officebaz.ir/ex/%d9%82%d8%b1%d8%b9%d9%87-%da%a9%d8%b4%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E45,shamsi())","v":184}]
[null,{"$error":"#VALUE!"},"تابع CHOOSE",14020116,14021019,"توابع اکسل","CHOOSE","1 comments","https://officebaz.ir/ex/wp-content/uploads/2023/04/CHOOSE.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-choose/",{"$f":"diff(E46,shamsi())","v":198}]
[null,{"$error":"#VALUE!"},"روشهای متفاوت برای یادگیری میانبرهای اکسل",14000309,14021016,"آموزش اکسل","نکات کاربردی اکسل","3 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Shortcut-1.jpg","https://officebaz.ir/ex/%d9%85%db%8c%d8%a7%d9%86%d8%a8%d8%b1%d9%87%d8%a7%db%8c-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E47,shamsi())","v":201}]
[null,{"$error":"#VALUE!"},"ایجاد نمودار پویا در اکسل به همراه تصویر",14021009,14021009,"آموزش اکسل","نمودار","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/12/Nemodar.png","https://officebaz.ir/ex/%d9%86%d9%85%d9%88%d8%af%d8%a7%d8%b1-%d9%be%d9%88%db%8c%d8%a7-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E48,shamsi())","v":208}]
[null,{"$error":"#VALUE!"},"همه چیز در مورد چک باکس در اکسل و استفاده اصولی",14020730,14021009,"آموزش اکسل","COUNTIFS","10 comments","https://officebaz.ir/ex/wp-content/uploads/2023/10/CheckBox3.jpg","https://officebaz.ir/ex/%da%86%da%a9-%d8%a8%d8%a7%da%a9%d8%b3-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E49,shamsi())","v":208}]
[null,{"$error":"#VALUE!"},"آیا شماره کارت 16 رقمی در اکسل درست وارد شده ؟",14000307,14021004,"آموزش اکسل","INDIRECT, SEQUENCE, ابزارهای فارسی","2 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Banki.jpg","https://officebaz.ir/ex/%d8%b4%d9%85%d8%a7%d8%b1%d9%87-%da%a9%d8%a7%d8%b1%d8%aa-16-%d8%b1%d9%82%d9%85%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E50,shamsi())","v":213}]
[null,{"$error":"#VALUE!"},"2 روش سریع برای تشخیص صحت کد ملی در اکسل",14000306,14021004,"آموزش اکسل","IFERROR, REPT, ROW, SEQUENCE, VBA, ابزارهای فارسی","17 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Melli1.jpg","https://officebaz.ir/ex/%da%a9%d8%af-%d9%85%d9%84%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E51,shamsi())","v":213}]
[null,{"$error":"#VALUE!"},"لیست کشویی اکسل ، لیست استانها و شهرستانها",14000306,14021004,"آموزش اکسل","ابزارهای فارسی, فایلهای کاربردی اکسل","18 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/List.jpg","https://officebaz.ir/ex/%d9%84%db%8c%d8%b3%d8%aa-%da%a9%d8%b4%d9%88%db%8c%db%8c-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E52,shamsi())","v":213}]
[null,{"$error":"#VALUE!"},"تابع LEN",14020231,14020922,"توابع اکسل","LEN","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/LEEEEN.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-len/",{"$f":"diff(E53,shamsi())","v":225}]
[null,{"$error":"#VALUE!"},"تابع COLUMN",14020128,14020922,"توابع اکسل","COLUMN","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/COLU12.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-column/",{"$f":"diff(E54,shamsi())","v":225}]
[null,{"$error":"#VALUE!"},"ساخت گزارش کارکرد روزانه در اکسل",14020920,14020920,"آموزش اکسل","FILTER, VBA","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/12/Report.jpg","https://officebaz.ir/ex/%da%a9%d8%a7%d8%b1%da%a9%d8%b1%d8%af-%d8%b1%d9%88%d8%b2%d8%a7%d9%86%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E55,shamsi())","v":227}]
[null,{"$error":"#VALUE!"},"تابع IFS",14020226,14020920,"توابع اکسل","IFS","1 comments","https://officebaz.ir/ex/wp-content/uploads/2023/05/IFS123.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-ifs/",{"$f":"diff(E56,shamsi())","v":227}]
[null,{"$error":"#VALUE!"},"تابع ROWS",14020307,14020919,"توابع اکسل","ROWS","1 comments","https://officebaz.ir/ex/wp-content/uploads/2023/05/ROWS123.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-rows/",{"$f":"diff(E57,shamsi())","v":228}]
[null,{"$error":"#VALUE!"},"تابع AND",14020119,14020918,"توابع اکسل","AND","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/147.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-and/",{"$f":"diff(E58,shamsi())","v":229}]
[null,{"$error":"#VALUE!"},"تابع SORT",14020219,14020917,"توابع اکسل","SORT","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/SORT111.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-sort/",{"$f":"diff(E59,shamsi())","v":230}]
[null,{"$error":"#VALUE!"},"تابع XOR",14020204,14020917,"توابع اکسل","XOR","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/XOR123.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-xor/",{"$f":"diff(E60,shamsi())","v":230}]
[null,{"$error":"#VALUE!"},"تابع MID",14020206,14020915,"توابع اکسل","MID","1 comments","https://officebaz.ir/ex/wp-content/uploads/2023/04/LEEEEN.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-mid/",{"$f":"diff(E61,shamsi())","v":232}]
[null,{"$error":"#VALUE!"},"تابع TEXT",14020205,14020915,"توابع اکسل","TEXT","6 comments","https://officebaz.ir/ex/wp-content/uploads/2023/04/TEXT111.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-text/",{"$f":"diff(E62,shamsi())","v":232}]
[null,{"$error":"#VALUE!"},"تابع ABS",14020129,14020915,"توابع اکسل","ABS","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/ABS111.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-abs/",{"$f":"diff(E63,shamsi())","v":232}]
[null,{"$error":"#VALUE!"},"تابع OR",14020122,14020912,"توابع اکسل","OR","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/OR1.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-or/",{"$f":"diff(E64,shamsi())","v":235}]
[null,{"$error":"#VALUE!"},"ذخیره کردن هر شیت به عنوان یک فایل جدید اکسل",14020910,14020911,"آموزش اکسل","VBA","12 comments","https://officebaz.ir/ex/wp-content/uploads/2023/12/Sheets1.jpg","https://officebaz.ir/ex/%d9%87%d8%b1-%d8%b4%db%8c%d8%aa-%d8%a8%d9%87-%d8%b9%d9%86%d9%88%d8%a7%d9%86-%db%8c%da%a9-%d9%81%d8%a7%db%8c%d9%84-%d8%ac%d8%af%db%8c%d8%af-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E65,shamsi())","v":236}]
[null,{"$error":"#VALUE!"},"تابع NOT",14020218,14020911,"توابع اکسل","NOT","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/NOT-1.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-not/",{"$f":"diff(E66,shamsi())","v":236}]
[null,{"$error":"#VALUE!"},"تابع SUBSTITUTE اکسل",14000618,14020909,"توابع اکسل","SUBSTITUTE","5 comments","https://officebaz.ir/ex/wp-content/uploads/2021/09/Subet.jpg","https://officebaz.ir/ex/21-%d8%aa%d8%a7%d8%a8%d8%b9-substitute-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E67,shamsi())","v":238}]
[null,{"$f":"_xlfn.IMAGE(I68)","v":{"$error":"#VALUE!"}},"محاسبه درصد تخفیف در اکسل ، فروش گروهی",14020829,14020908,"آموزش اکسل","SUMIFS, نکات کاربردی اکسل","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/11/percent4.jpg","https://officebaz.ir/ex/%d8%af%d8%b1%d8%b5%d8%af-%d8%aa%d8%ae%d9%81%db%8c%d9%81-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E68,shamsi())","v":239}]
[null,{"$error":"#VALUE!"},"تابع FIND اکسل و تابع SEARCH اکسل",14000307,14020908,"توابع اکسل","FIND, SEARCH","5 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Search.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-find-%d8%a7%da%a9%d8%b3%d9%84-%d9%88-search/",{"$f":"diff(E69,shamsi())","v":239}]
[null,{"$error":"#VALUE!"},"تابع SUMIF",14000307,14020908,"توابع اکسل","SUMIF","10 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/SUMIF.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-sumif/",{"$f":"diff(E70,shamsi())","v":239}]
[null,{"$error":"#VALUE!"},"ثبت اطلاعات توسط فرم در اکسل و نکات مهم",14020722,14020723,"آموزش اکسل","فایلهای کاربردی اکسل","5 comments","https://officebaz.ir/ex/wp-content/uploads/2023/10/FirstCode.jpg","https://officebaz.ir/ex/%d9%81%d8%b1%d9%85-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E71,shamsi())","v":284}]
[null,{"$error":"#VALUE!"},"استفاده از QrCode در اکسل و انجام پروژه",14020718,14020718,"پروژه های اکسل","VBA, فایلهای کاربردی اکسل","5 comments","https://officebaz.ir/ex/wp-content/uploads/2023/10/Qr2.jpg","https://officebaz.ir/ex/3-%d8%b1%d9%88%d8%b4-qrcode-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E72,shamsi())","v":289}]
[null,{"$error":"#VALUE!"},"آموزش ایجاد دفترتلفن در اکسل با جستجو دیماه1401",14010430,14020715,"پروژه های اکسل","ترکیب توابع, جستجو, فایلهای کاربردی اکسل","55 comments","https://officebaz.ir/ex/wp-content/uploads/2022/07/Phonebook3.png","https://officebaz.ir/ex/phonbook/",{"$f":"diff(E73,shamsi())","v":292}]
[null,{"$error":"#VALUE!"},"برنامه ریزی روزانه و هفتگی در اکسل و لیست انجام کار",14010616,14020714,"پروژه های اکسل","فایلهای کاربردی اکسل","100 comments","https://officebaz.ir/ex/wp-content/uploads/2022/09/Planning1-1.png","https://officebaz.ir/ex/%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-%d8%b1%db%8c%d8%b2%db%8c-%d8%b1%d9%88%d8%b2%d8%a7%d9%86%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-1401/",{"$f":"diff(E74,shamsi())","v":293}]
[null,{"$error":"#VALUE!"},"5 ترفند کاربردی اکسل برای افزایش سرعت کار",14020626,14020626,"آموزش اکسل, ترفندهای اکسل",null,"6 comments","https://officebaz.ir/ex/wp-content/uploads/2023/09/Trick3.jpg","https://officebaz.ir/ex/5-%d8%aa%d8%b1%d9%81%d9%86%d8%af-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1%d8%af%db%8c-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E75,shamsi())","v":312}]
[null,{"$error":"#VALUE!"},"افزودن تصویر به پس زمینه اکسل",14020211,14020626,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/11-PictureInBackGround.jpg","https://officebaz.ir/ex/11-%d8%aa%d8%b5%d9%88%db%8c%d8%b1-%d9%be%d8%b3-%d8%b2%d9%85%db%8c%d9%86%d9%87-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E76,shamsi())","v":312}]
[null,{"$error":"#VALUE!"},"تابع SORTBY",14020620,14020620,"توابع اکسل","SORTBY","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/09/SORTBY.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-sortby/",{"$f":"diff(E77,shamsi())","v":318}]
[null,{"$error":"#VALUE!"},"FIFO و LIFO به چه معناست ؟ فایفو در اکسل",14020619,14020619,"آموزش اکسل","FILTER, IF, SORT, VLOOKUP","2 comments","https://officebaz.ir/ex/wp-content/uploads/2023/09/FIFO2.jpg","https://officebaz.ir/ex/%d9%81%d8%a7%db%8c%d9%81%d9%88-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E78,shamsi())","v":319}]
[null,{"$error":"#VALUE!"},"تابع CONCATENATE",14020610,14020610,"توابع اکسل","CONCATENATE","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/09/Concatinate.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-concatenate/",{"$f":"diff(E79,shamsi())","v":328}]
[null,{"$error":"#VALUE!"},"تابع TEXTJOIN",14020514,14020610,"توابع اکسل","TEXTJOIN","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/08/TEXTJOIN.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-textjoin/",{"$f":"diff(E80,shamsi())","v":328}]
[null,{"$error":"#VALUE!"},"اعمال تغییر گروهی فایلهای اکسل",14020607,14020607,"آموزش اکسل","VBA","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/08/GroupChange.jpg","https://officebaz.ir/ex/%d8%aa%d8%ba%db%8c%db%8c%d8%b1-%da%af%d8%b1%d9%88%d9%87%db%8c-%d9%81%d8%a7%db%8c%d9%84%d9%87%d8%a7%db%8c-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E81,shamsi())","v":331}]
[null,{"$error":"#VALUE!"},"جستجوی پیشرفته در اکسل",14020604,14020604,"آموزش اکسل","FILTER, FIND, توابع جستجو, جستجو","22 comments","https://officebaz.ir/ex/wp-content/uploads/2023/08/AdvancedSearchInexcel.jpg","https://officebaz.ir/ex/%d8%ac%d8%b3%d8%aa%d8%ac%d9%88%db%8c-%d9%be%db%8c%d8%b4%d8%b1%d9%81%d8%aa%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E82,shamsi())","v":334}]
[null,{"$error":"#VALUE!"},"تابع INDIRECT",14020602,14020602,"توابع اکسل","INDIRECT","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/08/INDIRECT.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-indirect/",{"$f":"diff(E83,shamsi())","v":336}]
[null,{"$error":"#VALUE!"},"نمایش خلاصه اعداد بزرگ در اکسل",14020212,14020528,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/12-hemat.jpg","https://officebaz.ir/ex/12-%d9%86%d9%85%d8%a7%db%8c%d8%b4-%d8%ae%d9%84%d8%a7%d8%b5%d9%87-%d8%a7%d8%b9%d8%af%d8%a7%d8%af-%d8%a8%d8%b2%d8%b1%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E84,shamsi())","v":341}]
[null,{"$error":"#VALUE!"},"قیمت لحظه ای ارزهای دیجیتال در اکسل",14000626,14020525,"آموزش اکسل","پاور کوئری, نکات کاربردی اکسل","10 comments","https://officebaz.ir/ex/wp-content/uploads/2021/09/Price.jpg","https://officebaz.ir/ex/23-%d8%a7%d8%b1%d8%b2-%d8%af%db%8c%d8%ac%db%8c%d8%aa%d8%a7%d9%84-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E85,shamsi())","v":344}]
[null,{"$error":"#VALUE!"},"جستجوی لحظه ای و هایلایت کردن نتایج در اکسل",14000620,14020525,"آموزش اکسل","CONDITIONAL FORMATTING, FILTER","28 comments","https://officebaz.ir/ex/wp-content/uploads/2021/09/highlight1.jpg","https://officebaz.ir/ex/22-%d8%ac%d8%b3%d8%aa%d8%ac%d9%88%db%8c-%d9%84%d8%ad%d8%b8%d9%87-%d8%a7%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E86,shamsi())","v":344}]
[null,{"$error":"#VALUE!"},"تبدیل فایلهای اکسل داخل پوشه به PDF",14000612,14020525,"آموزش اکسل","نکات کاربردی اکسل","1 comments","https://officebaz.ir/ex/wp-content/uploads/2021/09/PDF-3.jpg","https://officebaz.ir/ex/16-%d8%aa%d8%a8%d8%af%db%8c%d9%84-%da%af%d8%b1%d9%88%d9%87%db%8c-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-pdf/",{"$f":"diff(E87,shamsi())","v":344}]
[null,{"$error":"#VALUE!"},"تجربه آزمون ماکروسافت اکسل برای اخذ مدرک اکسل",14000522,14020525,"آموزش اکسل","آفیس باز","3 comments","https://officebaz.ir/ex/wp-content/uploads/2021/08/Exam-1.jpg","https://officebaz.ir/ex/10-%d8%a2%d8%b2%d9%85%d9%88%d9%86-%d9%85%d8%a7%da%a9%d8%b1%d9%88%d8%b3%d8%a7%d9%81%d8%aa-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E88,shamsi())","v":344}]
[null,{"$error":"#VALUE!"},"بزرگنمایی سلولهای اکسل ، ترفندی جالب در اکسل",14000324,14020525,"آموزش اکسل","VBA, نکات کاربردی اکسل","9 comments","https://officebaz.ir/ex/wp-content/uploads/2021/06/Magnifier.jpg","https://officebaz.ir/ex/3-%d8%b1%d9%88%d8%b4-%d8%a8%d8%b2%d8%b1%da%af%d9%86%d9%85%d8%a7%db%8c%db%8c-%d8%b3%d9%84%d9%88%d9%84%d9%87%d8%a7%db%8c-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E89,shamsi())","v":344}]
[null,{"$error":"#VALUE!"},"افزونه اکسل چیست و addins چگونه استفاده می شود",14000309,14020525,"آموزش اکسل","VBA, تنظیمات اکسل","4 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Add.jpg","https://officebaz.ir/ex/addins-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E90,shamsi())","v":344}]
[null,{"$error":"#VALUE!"},"اولین ماکرو اکسل خود را به سادگی ایجاد کنید",14000309,14020524,"آموزش اکسل","VBA, تنظیمات اکسل","1 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Macro2.jpg","https://officebaz.ir/ex/%d8%a7%d9%88%d9%84%db%8c%d9%86-%d9%85%d8%a7%da%a9%d8%b1%d9%88-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E91,shamsi())","v":345}]
[null,{"$error":"#VALUE!"},"ماکرو چیست و چگونه اکسل را ماکرواینیبل کنیم",14000309,14020524,"آموزش اکسل","VBA, تنظیمات اکسل, مشکلات اکسل","2 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Macro.jpg","https://officebaz.ir/ex/%d9%81%d8%b9%d8%a7%d9%84-%da%a9%d8%b1%d8%af%d9%86-%d9%85%d8%a7%da%a9%d8%b1%d9%88-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E92,shamsi())","v":345}]
[null,{"$error":"#VALUE!"},"هدر و فوتر اختصاصی و سربرگ در اکسل",14000309,14020524,"آموزش اکسل","VBA, نکات کاربردی اکسل","4 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Header.jpg","https://officebaz.ir/ex/%d8%b3%d8%b1%d8%a8%d8%b1%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E93,shamsi())","v":345}]
[null,{"$error":"#VALUE!"},"مغایرت گیری در اکسل با ابزار رایگان آفیس باز",14000309,14020524,"آموزش اکسل","ابزارهای فارسی, حسابداری در اکسل","18 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Compare.jpg","https://officebaz.ir/ex/%d9%85%d8%ba%d8%a7%db%8c%d8%b1%d8%aa-%da%af%db%8c%d8%b1%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E94,shamsi())","v":345}]
[null,{"$error":"#VALUE!"},"ساده ترین روش مقایسه دو ستون در اکسل",14020220,14020523,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/20-Compare.jpg","https://officebaz.ir/ex/20-%d8%b3%d8%a7%d8%af%d9%87-%d8%aa%d8%b1%db%8c%d9%86-%d8%b1%d9%88%d8%b4-%d9%85%d9%82%d8%a7%db%8c%d8%b3%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E95,shamsi())","v":346}]
[null,{"$error":"#VALUE!"},"مقایسه دو ستون در اکسل",14000309,14020523,"آموزش اکسل","حسابداری در اکسل, نکات کاربردی اکسل","11 comments","https://officebaz.ir/ex/wp-content/uploads/2021/02/06-Compare.jpg","https://officebaz.ir/ex/%d9%85%d9%82%d8%a7%db%8c%d8%b3%d9%87-%d8%af%d9%88-%d8%b3%d8%aa%d9%88%d9%86-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E96,shamsi())","v":346}]
[null,{"$error":"#VALUE!"},"یافتن و حذف ردیف خالی در اکسل",14000308,14020523,"آموزش اکسل","نکات کاربردی اکسل","5 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/empty.jpg","https://officebaz.ir/ex/%d8%ad%d8%b0%d9%81-%d8%b1%d8%af%db%8c%d9%81-%d8%ae%d8%a7%d9%84%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E97,shamsi())","v":346}]
[null,{"$error":"#VALUE!"},"امتیازدهی ستاره ای در اکسل به همراه چالش !",14000308,14020523,"آموزش اکسل","REPT, نکات کاربردی اکسل","1 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Rating.jpg","https://officebaz.ir/ex/%d8%a7%d9%85%d8%aa%db%8c%d8%a7%d8%b2%d8%af%d9%87%db%8c-%d8%b3%d8%aa%d8%a7%d8%b1%d9%87-%d8%a7%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E98,shamsi())","v":346}]
[null,{"$error":"#VALUE!"},"رتبه بندی در اکسل ، دانش آموزان کلاس",14000308,14020523,"آموزش اکسل","IF, RANK, نکات کاربردی اکسل","13 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Ranking.jpg","https://officebaz.ir/ex/%d8%b1%d8%aa%d8%a8%d9%87-%d8%a8%d9%86%d8%af%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E99,shamsi())","v":346}]
[null,{"$error":"#VALUE!"},"طراحی آزمون در اکسل و سوالات چهار گزینه ای",14000308,14020522,"آموزش اکسل","CONDITIONAL FORMATTING, COUNT, نکات کاربردی اکسل","6 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/Quation.jpg","https://officebaz.ir/ex/%d8%b7%d8%b1%d8%a7%d8%ad%db%8c-%d8%a2%d8%b2%d9%85%d9%88%d9%86-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E100,shamsi())","v":347}]
[null,{"$error":"#VALUE!"},"پشتیبانگیری و ارسال ایمیل در اکسل 402",14020521,14020521,"آموزش اکسل","VBA","4 comments","https://officebaz.ir/ex/wp-content/uploads/2023/08/Email2.jpg","https://officebaz.ir/ex/25-email/",{"$f":"diff(E101,shamsi())","v":348}]
[null,{"$error":"#VALUE!"},"خط هدف در نمودار اکسل",14020518,14020518,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/08/35-TargetLine.jpg","https://officebaz.ir/ex/35-%d8%ae%d8%b7-%d9%87%d8%af%d9%81-%d8%af%d8%b1-%d9%86%d9%85%d9%88%d8%af%d8%a7%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E102,shamsi())","v":351}]
[null,{"$error":"#VALUE!"},"ترفند کاربردی مرج کردن در اکسل",14020516,14020516,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/08/36-Merg.jpg","https://officebaz.ir/ex/36-%d8%aa%d8%b1%d9%81%d9%86%d8%af-%d9%85%d8%b1%d8%ac-%da%a9%d8%b1%d8%af%d9%86-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E103,shamsi())","v":353}]
[null,{"$error":"#VALUE!"},"تجمیع متن ها در اکسل با شروط مختلف",14020512,14020514,"ترفندهای کوتاه","IF, TEXTJOIN","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/08/34-TextJoin.jpg","https://officebaz.ir/ex/34-%d8%aa%d8%ac%d9%85%db%8c%d8%b9-%d9%85%d8%aa%d9%86-%d9%87%d8%a7-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E104,shamsi())","v":355}]
[null,{"$error":"#VALUE!"},"نمایش و آپدیت خودکار در اکسل هر 1 دقیقه",14020503,14020503,"آموزش اکسل","ABS, IF, OR","2 comments","https://officebaz.ir/ex/wp-content/uploads/2023/07/Alarm.png","https://officebaz.ir/ex/%d8%a2%d9%be%d8%af%db%8c%d8%aa-%d8%ae%d9%88%d8%af%da%a9%d8%a7%d8%b1-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d9%87%d8%b1-1-%d8%af%d9%82%db%8c%d9%82%d9%87/",{"$f":"diff(E105,shamsi())","v":366}]
[null,{"$error":"#VALUE!"},"جعبه ابزار آموزش اکسل نسخه 2.0.1",14010417,14020429,"آموزش اکسل","دانلود","68 comments","https://officebaz.ir/ex/wp-content/uploads/2022/07/OfficebazExcelToolbox.jpg","https://officebaz.ir/ex/toolbox/",{"$f":"diff(E106,shamsi())","v":371}]
[null,{"$error":"#VALUE!"},"تکرار ردیف اکسل به تعداد دلخواه",14020428,14020428,"آموزش اکسل","INDEX, MATCH, ROW, XLOOKUP","1 comments","https://officebaz.ir/ex/wp-content/uploads/2023/07/Repeat.png","https://officebaz.ir/ex/%d8%aa%da%a9%d8%b1%d8%a7%d8%b1-%d8%a8%d9%87-%d8%aa%d8%b9%d8%af%d8%a7%d8%af-%d8%af%d9%84%d8%ae%d9%88%d8%a7%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d8%a7-2-%d8%b1%d9%88%d8%b4/",{"$f":"diff(E107,shamsi())","v":372}]
[null,{"$error":"#VALUE!"},"محاسبه سود فروش در اکسل با شرط دو بعدی",14020421,14020428,"آموزش اکسل, ترکیب توابع","MATCH, VLOOKUP","2 comments","https://officebaz.ir/ex/wp-content/uploads/2023/07/Profit.png","https://officebaz.ir/ex/%d8%b3%d9%88%d8%af-%d9%81%d8%b1%d9%88%d8%b4-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E108,shamsi())","v":372}]
[null,{"$error":"#VALUE!"},"خلاصه کردن نمایش اعداد و فرمت سلز اکسل",14020413,14020413,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/07/33-FormatCells.jpg","https://officebaz.ir/ex/33-%d9%81%d8%b1%d9%85%d8%aa-%d8%b3%d9%84%d8%b2-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E109,shamsi())","v":387}]
[null,{"$error":"#VALUE!"},"لیست پوشه ها و نام فایلها در اکسل",14020405,14020405,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/06/32-FileList-1.jpg","https://officebaz.ir/ex/32-%d9%86%d8%a7%d9%85-%d9%81%d8%a7%db%8c%d9%84%d9%87%d8%a7-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E110,shamsi())","v":395}]
[null,{"$error":"#VALUE!"},"راهنمای ساخت پوشه در اکسل برای هر فرد با یک کلیک",14020329,14020329,"آموزش اکسل","VBA","11 comments","https://officebaz.ir/ex/wp-content/uploads/2023/06/MakeFolder1.jpg","https://officebaz.ir/ex/%d8%b3%d8%a7%d8%ae%d8%aa-%d9%be%d9%88%d8%b4%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d8%b1%d8%a7%db%8c-%d9%87%d8%b1-%d9%81%d8%b1%d8%af-%d8%a8%d8%a7-%db%8c%da%a9-%da%a9%d9%84%db%8c%da%a9/",{"$f":"diff(E111,shamsi())","v":402}]
[null,{"$error":"#VALUE!"},"استفاده از Spakline در اکسل",14020323,14020323,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/06/31-Sparkline-1.jpg","https://officebaz.ir/ex/31-spakline-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E112,shamsi())","v":408}]
[null,{"$error":"#VALUE!"},"استفاده از ایموجی در اکسل",14020321,14020321,"ترفندهای کوتاه","IF","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/06/30-Emoji-1.jpg","https://officebaz.ir/ex/30-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-%d8%a7%db%8c%d9%85%d9%88%d8%ac%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E113,shamsi())","v":410}]
[null,{"$error":"#VALUE!"},"خط کشیدن دور داده های ناهمخوان در اکسل",14020318,14020318,"ترفندهای کوتاه","CONDITIONAL FORMATTING","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/06/29-LineValidationData.jpg","https://officebaz.ir/ex/29-%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7%db%8c-%d9%86%d8%a7%d9%87%d9%85%d8%ae%d9%88%d8%a7%d9%86-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E114,shamsi())","v":413}]
[null,{"$error":"#VALUE!"},"قرعه کشی ساده در اکسل",14020311,14020311,"ترفندهای کوتاه","INDEX","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/06/28-Lotarry.jpg","https://officebaz.ir/ex/28-%d9%82%d8%b1%d8%b9%d9%87-%da%a9%d8%b4%db%8c-%d8%b3%d8%a7%d8%af%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E115,shamsi())","v":420}]
[null,{"$error":"#VALUE!"},"تابع COUNT",14020310,14020311,"توابع اکسل","COUNT","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/CountPic.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-count/",{"$f":"diff(E116,shamsi())","v":420}]
[null,{"$error":"#VALUE!"},"تابع FILTER و مقایسه دو ستون",14020303,14020303,"ترفندهای کوتاه","COUNTIFS, FILTER","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/Filter.jpg","https://officebaz.ir/ex/26-%d8%aa%d8%a7%d8%a8%d8%b9-filter-%d9%88-%d9%85%d9%82%d8%a7%db%8c%d8%b3%d9%87-%d8%af%d9%88-%d8%b3%d8%aa%d9%88%d9%86/",{"$f":"diff(E117,shamsi())","v":428}]
[null,{"$error":"#VALUE!"},"جدا کردن متون با ابزار فلش فیل اکسل",14020227,14020227,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/25-Seperate.jpg","https://officebaz.ir/ex/%d8%a7%d8%a8%d8%b2%d8%a7%d8%b1-%d9%81%d9%84%d8%b4-%d9%81%db%8c%d9%84-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E118,shamsi())","v":435}]
[null,{"$error":"#VALUE!"},"نکته مهم در مورد جمع ساعت در اکسل",14020225,14020225,"ترفندهای کوتاه","SUM","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/24-TimeTotal.jpg","https://officebaz.ir/ex/24-%d8%ac%d9%85%d8%b9-%d8%b3%d8%a7%d8%b9%d8%aa-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E119,shamsi())","v":437}]
[null,{"$error":"#VALUE!"},"تابع Xlookup تو در تو",14020224,14020224,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/23-Xlookup.jpg","https://officebaz.ir/ex/23-xlookup-%d8%aa%d9%88-%d8%af%d8%b1-%d8%aa%d9%88/",{"$f":"diff(E120,shamsi())","v":438}]
[null,{"$error":"#VALUE!"},"کپی کردن محدوده مخفی شده اکسل",14020223,14020223,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/22-Visible.jpg","https://officebaz.ir/ex/22-%d9%85%d8%ad%d8%af%d9%88%d8%af%d9%87-%d9%85%d8%ae%d9%81%db%8c-%d8%b4%d8%af%d9%87-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E121,shamsi())","v":439}]
[null,{"$error":"#VALUE!"},"جمع با شرط بخشی از متن SUMIFS",14020221,14020221,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/21-SumIfs.jpg","https://officebaz.ir/ex/%d8%ac%d9%85%d8%b9-%d8%a8%d8%a7-%d8%b4%d8%b1%d8%b7-%d8%a8%d8%ae%d8%b4%db%8c-%d8%a7%d8%b2-%d9%85%d8%aa%d9%86-sumifs/",{"$f":"diff(E122,shamsi())","v":441}]
[null,{"$error":"#VALUE!"},"نکته مهم جمع محدوده در اکسل",14020219,14020219,"ترفندهای کوتاه","SUBTOTAL","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/19-SubTotal.jpg","https://officebaz.ir/ex/19-%d8%ac%d9%85%d8%b9-%d9%85%d8%ad%d8%af%d9%88%d8%af%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E123,shamsi())","v":443}]
[null,{"$error":"#VALUE!"},"کپی کردن فرمول اکسل بدون تغییر آدرس",14020218,14020218,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/18-CopyFormula.jpg","https://officebaz.ir/ex/%da%a9%d9%be%db%8c-%da%a9%d8%b1%d8%af%d9%86-%d9%81%d8%b1%d9%85%d9%88%d9%84-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d8%af%d9%88%d9%86-%d8%aa%d8%ba%db%8c%db%8c%d8%b1-%d8%a2%d8%af%d8%b1%d8%b3/",{"$f":"diff(E124,shamsi())","v":444}]
[null,{"$error":"#VALUE!"},"بازرسی فایل اکسل و بررسی مشکلات احتمالی",14020217,14020217,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/17-Inspect.jpg","https://officebaz.ir/ex/17-%d8%a8%d8%a7%d8%b2%d8%b1%d8%b3%db%8c-%d9%81%d8%a7%db%8c%d9%84-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E125,shamsi())","v":445}]
[null,{"$error":"#VALUE!"},"تفاوت CTRL + A و CTRL + * انتخاب محدوده در اکسل",14020216,14020216,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/16-CtrlA.jpg","https://officebaz.ir/ex/16-%d8%a7%d9%86%d8%aa%d8%ae%d8%a7%d8%a8-%d9%85%d8%ad%d8%af%d9%88%d8%af%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E126,shamsi())","v":446}]
[null,{"$error":"#VALUE!"},"جدول ضرب در اکسل با توابع ROW و COLUMN",14020215,14020214,"ترفندهای کوتاه","COLUMN, ROW","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/15-RowAndColumn.jpg","https://officebaz.ir/ex/15-%d8%ac%d8%af%d9%88%d9%84-%d8%b6%d8%b1%d8%a8-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E127,shamsi())","v":448}]
[null,{"$error":"#VALUE!"},"مخفی کردن فرمولها در اکسل",14020214,14020214,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/05/14-Lock.jpg","https://officebaz.ir/ex/14-%d9%85%d8%ae%d9%81%db%8c-%da%a9%d8%b1%d8%af%d9%86-%d9%81%d8%b1%d9%85%d9%88%d9%84%d9%87%d8%a7-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E128,shamsi())","v":448}]
[null,{"$error":"#VALUE!"},"تابع INT",14020211,14020212,"توابع اکسل","INT","2 comments","https://officebaz.ir/ex/wp-content/uploads/2023/05/235.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-int/",{"$f":"diff(E129,shamsi())","v":450}]
[null,{"$error":"#VALUE!"},"پیوست کردن تصویر و هایپرلینک در اکسل",14020210,14020209,"ترفندهای کوتاه","HYPERLINK","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/10-AghsatDoc.jpg","https://officebaz.ir/ex/10-%d8%aa%d8%b5%d9%88%db%8c%d8%b1-%d9%88-%d9%87%d8%a7%db%8c%d9%be%d8%b1%d9%84%db%8c%d9%86%da%a9-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E130,shamsi())","v":453}]
[null,{"$error":"#VALUE!"},"شماره ردیف گروهی در اکسل",14020209,14020208,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/09-GroupRow.jpg","https://officebaz.ir/ex/09-%d8%b4%d9%85%d8%a7%d8%b1%d9%87-%d8%b1%d8%af%db%8c%d9%81-%da%af%d8%b1%d9%88%d9%87%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E131,shamsi())","v":454}]
[null,{"$f":"_xlfn.IMAGE(I132)","v":{"$error":"#VALUE!"}},"چرا اعداد بزرگتر از 15 رقم در اکسل 0 می شود",14020206,14020206,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/08-TextNumber15.jpg","https://officebaz.ir/ex/08-%d8%a7%d8%b9%d8%af%d8%a7%d8%af-%d8%a8%d8%b2%d8%b1%da%af%d8%aa%d8%b1-%d8%a7%d8%b2-15-%d8%b1%d9%82%d9%85-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E132,shamsi())","v":456}]
[null,{"$error":"#VALUE!"},"نمایش نام روز از تاریخ میلادی",14020205,14020205,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/07-WhatDayName.jpg","https://officebaz.ir/ex/07-%d9%86%d8%a7%d9%85-%d8%b1%d9%88%d8%b2-%d8%a7%d8%b2-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d9%85%db%8c%d9%84%d8%a7%d8%af%db%8c/",{"$f":"diff(E133,shamsi())","v":457}]
[null,{"$error":"#VALUE!"},"سوپر مخفی کردن شیت در اکسل",14020204,14020205,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/06-SuperHidden.jpg","https://officebaz.ir/ex/%d9%85%d8%ae%d9%81%db%8c-%da%a9%d8%b1%d8%af%d9%86-%d8%b4%db%8c%d8%aa-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E134,shamsi())","v":457}]
[null,{"$error":"#VALUE!"},"صفحه چند از چند در اکسل",14020203,14020203,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/05-PageNumberOf1.jpg","https://officebaz.ir/ex/05-%d8%b5%d9%81%d8%ad%d9%87-%da%86%d9%86%d8%af-%d8%a7%d8%b2-%da%86%d9%86%d8%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E135,shamsi())","v":459}]
[null,{"$error":"#VALUE!"},"افزودن شماره صفحه در اکسل",14020202,14020202,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/04-PageNumber.jpg","https://officebaz.ir/ex/04-%d8%b4%d9%85%d8%a7%d8%b1%d9%87-%d8%b5%d9%81%d8%ad%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E136,shamsi())","v":460}]
[null,{"$error":"#VALUE!"},"رنگی کردن سطر و ستون اکسل",14020128,14020128,"ترفندهای کوتاه","ROW","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/03-HighLight.jpg","https://officebaz.ir/ex/%d8%b1%d9%86%da%af%db%8c-%da%a9%d8%b1%d8%af%d9%86-%d8%b3%d8%b7%d8%b1-%d9%88-%d8%b3%d8%aa%d9%88%d9%86-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E137,shamsi())","v":465}]
[null,{"$error":"#VALUE!"},"تابع ROW",14020127,14020128,"توابع اکسل","ROW","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/259-1.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-row/",{"$f":"diff(E138,shamsi())","v":465}]
[null,{"$error":"#VALUE!"},"کنترل کردن شماره شبا در اکسل و توضیح الگوریتم",14001202,14020127,"آموزش اکسل","VBA, ابزارهای فارسی","14 comments","https://officebaz.ir/ex/wp-content/uploads/2022/02/Sheba3.png","https://officebaz.ir/ex/29-%d8%b1%d9%82%d9%85%db%8c-%da%a9%d9%86%d8%aa%d8%b1%d9%84-%da%a9%d8%b1%d8%af%d9%86-%d8%b4%d9%85%d8%a7%d8%b1%d9%87-%d8%b4%d8%a8%d8%a7-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d9%88-%d8%aa%d9%88%d8%b6/",{"$f":"diff(E139,shamsi())","v":466}]
[null,{"$error":"#VALUE!"},"مرتب سازی داده های اکسل به صورت افقی",14020126,14020126,"ترفندهای کوتاه","ُSORTBY","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/02-RowSort.jpg","https://officebaz.ir/ex/02-%d9%85%d8%b1%d8%aa%d8%a8-%d8%b3%d8%a7%d8%b2%db%8c-%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7%db%8c-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E140,shamsi())","v":467}]
[null,{"$error":"#VALUE!"},"راست به چپ کردن اکسل و تغییر جهت آن",14020125,14020126,"ترفندهای کوتاه",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/01-Direction.jpg","https://officebaz.ir/ex/%d8%b1%d8%a7%d8%b3%d8%aa-%d8%a8%d9%87-%da%86%d9%be-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%aa%d8%ba%db%8c%db%8c%d8%b1-%d8%ac%d9%87%d8%aa-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E141,shamsi())","v":467}]
[null,{"$error":"#VALUE!"},"کارگاه یک روزه اکسل | نکات مهم و تاریخ و زمان",14020125,14020119,"آموزش اکسل, کلاس آنلاین",null,"N/A","https://officebaz.ir/ex/wp-content/uploads/2023/04/SkyRoom.jpg","https://officebaz.ir/ex/%da%a9%d8%a7%d8%b1%da%af%d8%a7%d9%87-%db%8c%da%a9-%d8%b1%d9%88%d8%b2%d9%87-%d8%a7%da%a9%d8%b3%d9%84-%d9%86%da%a9%d8%a7%d8%aa-%d9%85%d9%87%d9%85-%d9%88-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d9%88-%d8%b2/",{"$f":"diff(E142,shamsi())","v":474}]
[null,{"$error":"#VALUE!"},"داینامیک کردن نمودار با تابع Offset",14011223,14011224,"آموزش اکسل","OFFSET, نمودار","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/03/OFFSET2.png","https://officebaz.ir/ex/%d9%86%d9%85%d9%88%d8%af%d8%a7%d8%b1-%d8%af%d8%a7%db%8c%d9%86%d8%a7%d9%85%db%8c%da%a9-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E143,shamsi())","v":498}]
[null,{"$error":"#VALUE!"},"رسم نمودار به همراه خط هدف در اکسل",14011209,14011209,"آموزش اکسل","نمودار","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/02/Chart.png","https://officebaz.ir/ex/%d8%b1%d8%b3%d9%85-%d9%86%d9%85%d9%88%d8%af%d8%a7%d8%b1-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E144,shamsi())","v":513}]
[null,{"$error":"#VALUE!"},"تابع OFFSET",14011109,14011209,"توابع اکسل","OFFSET","4 comments","https://officebaz.ir/ex/wp-content/uploads/2023/01/OffsetMain.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-offset-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E145,shamsi())","v":513}]
[null,{"$error":"#VALUE!"},"فیلتر کردن چند رنگ همزمان در اکسل",14011128,14011129,"آموزش اکسل","نکات کاربردی اکسل","2 comments","https://officebaz.ir/ex/wp-content/uploads/2023/02/Color.jpg","https://officebaz.ir/ex/%d9%81%db%8c%d9%84%d8%aa%d8%b1-%d8%b1%d9%86%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E146,shamsi())","v":523}]
[null,{"$error":"#VALUE!"},"جمع فروش فصلهای سال با OFFSET",14011121,14011121,"آموزش اکسل","OFFSET, تاریخ شمسی","1 comments","https://officebaz.ir/ex/wp-content/uploads/2023/02/Offset15.png","https://officebaz.ir/ex/%d8%ac%d9%85%d8%b9-%d9%81%d8%b1%d9%88%d8%b4-%d8%b3%d9%87-%d9%85%d8%a7%d9%87%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E147,shamsi())","v":531}]
[null,{"$error":"#VALUE!"},"روشهای مختلف بررسی داده های تکراری در اکسل",14000704,14011102,"آموزش اکسل","CONDITIONAL FORMATTING, COUNTIFS, نکات کاربردی اکسل","11 comments","https://officebaz.ir/ex/wp-content/uploads/2021/09/Tekrar.jpg","https://officebaz.ir/ex/26-%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7%db%8c-%d8%aa%da%a9%d8%b1%d8%a7%d8%b1%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E148,shamsi())","v":550}]
[null,{"$error":"#VALUE!"},"نفرات اول در لیست گروههای مختلف با XLOOKUP",14011101,14011101,"آموزش اکسل","IF, INDEX, LARGE, MATCH, XLOOKUP","N/A","https://officebaz.ir/ex/wp-content/uploads/2023/01/Large.png","https://officebaz.ir/ex/%d9%86%d9%81%d8%b1%d8%a7%d8%aa-%d8%a7%d9%88%d9%84-%d8%af%d8%b1-%d9%84%db%8c%d8%b3%d8%aa/",{"$f":"diff(E149,shamsi())","v":551}]
[null,{"$error":"#VALUE!"},"تابع DGET اکسل",14010619,14011016,"توابع اکسل","DGET, LOOKUP, توابع دیتابیس","5 comments","https://officebaz.ir/ex/wp-content/uploads/2022/09/DGET.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-dget-%d8%a7%da%a9%d8%b3%d9%84-1401/",{"$f":"diff(E150,shamsi())","v":566}]
[null,{"$error":"#VALUE!"},"ارسال پیام مستقیم واتس اپ در اکسل",14000308,14011015,"آموزش اکسل","HYPERLINK, نکات کاربردی اکسل","7 comments","https://officebaz.ir/ex/wp-content/uploads/2021/05/WHATSAPP1.png","https://officebaz.ir/ex/%d8%a7%d8%b1%d8%b3%d8%a7%d9%84-%d9%be%db%8c%d8%a7%d9%85-%d9%88%d8%a7%d8%aa%d8%b3-%d8%a7%d9%be-%d8%a7%d8%b2-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E151,shamsi())","v":567}]
[null,{"$error":"#VALUE!"},"3 روش برای نمایش نام فایلها و پوشه ها در اکسل",14011014,14011014,"آموزش اکسل","FIND, SUBSTITUTE, TEXTSPLIT","4 comments","https://officebaz.ir/ex/wp-content/uploads/2023/01/FilePath1.png","https://officebaz.ir/ex/%d9%86%d8%a7%d9%85-%d9%81%d8%a7%db%8c%d9%84%d9%87%d8%a7-%d9%88-%d9%be%d9%88%d8%b4%d9%87-%d9%87%d8%a7-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E152,shamsi())","v":568}]
[null,{"$error":"#VALUE!"},"تابع TEXTSPLIT",14010925,14011005,"توابع اکسل","TEXTSPLIT","2 comments","https://officebaz.ir/ex/wp-content/uploads/2022/12/TEXTSPLIT1.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-textsplit/",{"$f":"diff(E153,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"جام جهانی 2022 در اکسل با امکان پیش بینی",14010822,14011005,"آموزش اکسل","سرگرمی در اکسل","2 comments","https://officebaz.ir/ex/wp-content/uploads/2022/11/WorldCup2022-2.png","https://officebaz.ir/ex/%d8%ac%d8%a7%d9%85-%d8%ac%d9%87%d8%a7%d9%86%db%8c-2022-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E154,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"آموزش 3 روش برای تبدیل عدد به درصد در اکسل",14010820,14011005,"آموزش اکسل","نکات کاربردی اکسل","1 comments","https://officebaz.ir/ex/wp-content/uploads/2022/11/Perce.png","https://officebaz.ir/ex/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-3-%d8%b1%d9%88%d8%b4-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d8%a8%d8%af%db%8c%d9%84-%d8%b9%d8%af%d8%af-%d8%a8%d9%87-%d8%af%d8%b1%d8%b5%d8%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3/",{"$f":"diff(E155,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"ایجاد پسورد در اکسل به صورت خودکار",14010814,14011005,"آموزش اکسل","CHOOSE, RANDBETWEEN, امنیت","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/11/Password.png","https://officebaz.ir/ex/401-%d8%a7%db%8c%d8%ac%d8%a7%d8%af-%d9%be%d8%b3%d9%88%d8%b1%d8%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E156,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تابع LOOKUP",14010808,14011005,"توابع اکسل","LOOKUP","1 comments","https://officebaz.ir/ex/wp-content/uploads/2022/10/241.jpg","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-lookup-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-2-%d9%85%d8%ab%d8%a7%d9%84-%d9%85%d8%aa%d9%81%d8%a7%d9%88%d8%aa-%d9%88-%da%a9%d8%a7%d8%b1%d8%a8/",{"$f":"diff(E157,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"استخراج اولین و آخرین تاریخ فروش از محدوده نا مرتب",14010724,14011005,"آموزش اکسل","SORT, SORTBY, XLOOKUP","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/10/Xlookup-1.png","https://officebaz.ir/ex/%d8%a7%d9%88%d9%84%db%8c%d9%86-%d9%88-%d8%a2%d8%ae%d8%b1%db%8c%d9%86-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d9%81%d8%b1%d9%88%d8%b4-21/",{"$f":"diff(E158,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تابع INDEX",14010614,14011005,"توابع اکسل","INDEX","10 comments","https://officebaz.ir/ex/wp-content/uploads/2022/09/index3.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-index-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E159,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"نمایش حروف فارسی در اکسل به هم ریخته و نامفهوم",14010609,14011005,"آموزش اکسل","مشکلات اکسل","2 comments","https://officebaz.ir/ex/wp-content/uploads/2022/08/pERSAN4.jpg","https://officebaz.ir/ex/%d8%ad%d8%b1%d9%88%d9%81-%d9%81%d8%a7%d8%b1%d8%b3%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-2-%d8%b1%d9%88%d8%b4/",{"$f":"diff(E160,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تابع N",14010421,14011005,"توابع اکسل","N, توابع اطلاع رسانی","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/07/n1.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-n-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-%d9%87%d9%85%d8%b1%d8%a7%d9%87-%d9%85%d8%ab%d8%a7%d9%84/",{"$f":"diff(E161,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"لیست باکس چندتایی در اکسل 2 روش",14010328,14011005,"آموزش اکسل","KuTools, نکات کاربردی اکسل","1 comments","https://officebaz.ir/ex/wp-content/uploads/2022/06/ListBox1.png","https://officebaz.ir/ex/%d9%84%db%8c%d8%b3%d8%aa-%d8%a8%d8%a7%da%a9%d8%b3-%da%86%d9%86%d8%af%d8%aa%d8%a7%db%8c%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-2-%d8%b1%d9%88%d8%b4-%d8%b3%d8%a7%d8%af%d9%87-%d9%88-%da%a9%d8%af/",{"$f":"diff(E162,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"kuTools اکسل نسخه 24 دانلود رایگان و فعالسازی",14010327,14011005,"آموزش اکسل","KuTools","8 comments","https://officebaz.ir/ex/wp-content/uploads/2022/06/Kutools.png","https://officebaz.ir/ex/%d8%af%d8%a7%d9%86%d9%84%d9%88%d8%af-kutools-%d8%a7%da%a9%d8%b3%d9%84-24/",{"$f":"diff(E163,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تابع ISEVEN",14010311,14011005,"توابع اکسل","ISEVEN","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/06/ISEVEN2.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-iseven-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E164,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تابع EVEN",14010311,14011005,"توابع اکسل","EVEN","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/06/EVEN2.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-even-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E165,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تابع ISODD",14010307,14011005,"توابع اکسل","ISODD","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/05/isodd2.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-isodd-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E166,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تابع ODD",14010224,14011005,"توابع اکسل","ODD","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/05/ODD1-1.png","https://officebaz.ir/ex/%d8%aa%d8%a7%d8%a8%d8%b9-odd-%d8%a7%da%a9%d8%b3%d9%84-1401/",{"$f":"diff(E167,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"یکسان سازی شماره موبایل در اکسل",14010209,14011005,"آموزش اکسل","RIGHT, ابزارهای فارسی","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/04/mobile-1.png","https://officebaz.ir/ex/%db%8c%da%a9%d8%b3%d8%a7%d9%86-%d8%b3%d8%a7%d8%b2%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d8%b4%d9%85%d8%a7%d8%b1%d9%87-%d9%85%d9%88%d8%a8%d8%a7%db%8c%d9%84-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E168,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"درک نقش هشتگ در اکسل 2021 به همراه مثال",14010118,14011005,"آموزش اکسل","آرایه, آفیس 2021","2 comments","https://officebaz.ir/ex/wp-content/uploads/2022/04/Hashtag.jpg","https://officebaz.ir/ex/56-%d9%85%d8%ab%d8%a7%d9%84%d9%87%d8%a7%db%8c-%d9%85%d8%ae%d8%aa%d9%84%d9%81-%d8%a8%d8%b1%d8%a7%db%8c-%d8%af%d8%b1%da%a9-%d9%87%d8%b4%d8%aa%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-2021/",{"$f":"diff(E169,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تبدیل لیست عمودی به افقی در اکسل و تجمیع داده",14001206,14011005,"آموزش اکسل","TEXTJOIN","1 comments","https://officebaz.ir/ex/wp-content/uploads/2022/02/Transpose.png","https://officebaz.ir/ex/%d8%aa%d8%a8%d8%af%db%8c%d9%84-%d9%84%db%8c%d8%b3%d8%aa-%d8%b9%d9%85%d9%88%d8%af%db%8c-%d8%a8%d9%87-%d8%a7%d9%81%d9%82%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-102/",{"$f":"diff(E170,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"ایجاد لیست هایپرلینک خودکار از نام شیتها",14001117,14011005,"آموزش اکسل","HYPERLINK","3 comments","https://officebaz.ir/ex/wp-content/uploads/2022/02/HYPERLINK5-1.png","https://officebaz.ir/ex/%da%a9%d9%85%d8%aa%d8%b1-%d8%a7%d8%b2-5-%d8%af%d9%82%db%8c%d9%82%d9%87-%d9%87%d8%a7%db%8c%d9%be%d8%b1%d9%84%db%8c%d9%86%da%a9-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d8%b1%d8%a7-%d8%a8%d9%87-%d8%b5/",{"$f":"diff(E171,shamsi())","v":586}]
[null,{"$error":"#VALUE!"},"تابع SEQUENCE اکسل",14001113,14011005,"توابع اکسل","SEQUENCE","4 comments","https://officebaz.ir/ex/wp-content/uploads/2022/02/SEQUENCE.png","https://officebaz.ir/ex/30-%d8%aa%d8%a7%d8%a8%d8%b9-sequence-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E172,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تبدیل شیت اکسل به PDF به روشهای مختلف",14001023,14011005,"آموزش اکسل","VBA, نکات کاربردی اکسل","16 comments","https://officebaz.ir/ex/wp-content/uploads/2022/01/PDF.jpg","https://officebaz.ir/ex/30-%d8%aa%d8%a8%d8%af%db%8c%d9%84-%d8%b4%db%8c%d8%aa-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-pdf/",{"$f":"diff(E173,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"تغییر رنگ خطوط اکسل ، تنظیمات یا کدنوسی ساده",14001012,14011005,"آموزش اکسل","VBA, تنظیمات اکسل","N/A","https://officebaz.ir/ex/wp-content/uploads/2022/01/GridLine.png","https://officebaz.ir/ex/29-%d8%aa%d8%ba%db%8c%db%8c%d8%b1-%d8%b1%d9%86%da%af-%d8%ae%d8%b7%d9%88%d8%b7-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E174,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"جدا کردن عدد از متن در اکسل",14000924,14011005,"آموزش اکسل","ابزارهای فارسی, نکات کاربردی اکسل","11 comments","https://officebaz.ir/ex/wp-content/uploads/2021/12/split.png","https://officebaz.ir/ex/50-%d8%ac%d8%af%d8%a7-%da%a9%d8%b1%d8%af%d9%86-%d8%b9%d8%af%d8%af-%d8%a7%d8%b2-%d9%85%d8%aa%d9%86-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E175,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"آموزش رأس گیری چک به همراه دانلود رایگان",14000918,14011005,"آموزش اکسل","IF, ابزارهای فارسی, تاریخ شمسی","13 comments","https://officebaz.ir/ex/wp-content/uploads/2021/12/Cheque.png","https://officebaz.ir/ex/26-%d8%b1%d8%a3%d8%b3-%da%af%db%8c%d8%b1%db%8c-%da%86%da%a9-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d9%88-%d8%af%d8%a7%d9%86%d9%84%d9%88%d8%af-%d8%b1%d8%a7%db%8c%da%af%d8%a7%d9%86/",{"$f":"diff(E176,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"جمع محدوده عددی در اکسل بر اساس رنگ",14000807,14011005,"آموزش اکسل","VBA, نکات کاربردی اکسل","5 comments","https://officebaz.ir/ex/wp-content/uploads/2021/10/COLOR.jpg","https://officebaz.ir/ex/28-%d8%ac%d9%85%d8%b9-%d9%85%d8%ad%d8%af%d9%88%d8%af%d9%87-%d8%a8%d8%a7-%d8%b4%d8%b1%d8%b7-%d8%b1%d9%86%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E177,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"پشتیبان گیری خودکار از فایل اکسل",14000727,14011005,"آموزش اکسل","امنیت, نکات کاربردی اکسل","22 comments","https://officebaz.ir/ex/wp-content/uploads/2021/10/Backup2.jpg","https://officebaz.ir/ex/26-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%da%af%db%8c%d8%b1%db%8c-%d8%a7%d8%b2-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E178,shamsi())","v":577}]
[null,{"$error":"#VALUE!"},"رنگی کردن بخشی از متن داخل سلول",14000723,14011005,"آموزش اکسل","VBA, نکات کاربردی اکسل","9 comments","https://officebaz.ir/ex/wp-content/uploads/2021/10/Highlight.png","https://officebaz.ir/ex/25-%d8%b1%d9%86%da%af%db%8c-%da%a9%d8%b1%d8%af%d9%86-%d8%a8%d8%ae%d8%b4%db%8c-%d8%a7%d8%b2-%d9%85%d8%aa%d9%86-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84/",{"$f":"diff(E179,shamsi())","v":577}]

{"sheet":"Access","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"تصویر","عنوان","تاریخ انتشار","تاریخ آپدیت","گروه","برچسب","نظرات","لینک تصویر","لینک مطلب","روز گذشته"]
[null,{"$f":"_xlfn.IMAGE(I3)","v":{"$error":"#VALUE!"}},"شماره ردیف در اکسس گزارشات و فرمها و و کوئری",14000621,14011103,"ترفندهای اکسس","فرمها, کوئریها, گزارشات","2 comments","https://officebaz.ir/ac/wp-content/uploads/2021/09/11.jpg","https://officebaz.ir/ac/11-%d8%b4%d9%85%d8%a7%d8%b1%d9%87-%d8%b1%d8%af%db%8c%d9%81-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d8%b3/",{"$f":"diff(E3,shamsi())","v":549}]
[null,{"$f":"_xlfn.IMAGE(I4)","v":{"$error":"#VALUE!"}},"چک کردن صحت کارت بانکی وارد شده",14000505,14010426,"فارسی زبانان","نمونه فایلهای اکسس","1 comments","https://officebaz.ir/ac/wp-content/uploads/2021/07/BankCard-1.jpg","https://officebaz.ir/ac/10-%da%a9%d8%a7%d8%b1%d8%aa-%d8%a8%d8%a7%d9%86%da%a9%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d8%b3-%d9%88-%d9%86%d8%a7%d9%85-%d8%a8%d8%a7%d9%86%da%a9/",{"$f":"diff(E4,shamsi())","v":739}]
[null,{"$error":"#VALUE!"},"تبدیل عدد به حروف در اکسس",14000502,14010427,"فارسی زبانان","نمونه فایلهای اکسس","N/A","https://officebaz.ir/ac/wp-content/uploads/2021/07/9-1.jpg","https://officebaz.ir/ac/%d8%aa%d8%a8%d8%af%db%8c%d9%84-%d8%b9%d8%af%d8%af-%d8%a8%d9%87-%d8%ad%d8%b1%d9%88%d9%81-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d8%b3/",{"$f":"diff(E5,shamsi())","v":738}]
[null,{"$error":"#VALUE!"},"بررسی صحت کد ملی وارد شده در اکسس",14000501,14010426,"فارسی زبانان","نمونه فایلهای اکسس","N/A","https://officebaz.ir/ac/wp-content/uploads/2021/07/8-1.jpg","https://officebaz.ir/ac/%da%a9%d8%af-%d9%85%d9%84%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d8%b3/",{"$f":"diff(E6,shamsi())","v":739}]
[null,{"$error":"#VALUE!"},"افزودن امکانات تاریخ شمسی به اکسس",14000431,14010426,"فارسی زبانان","تاریخ شمسی","10 comments","https://officebaz.ir/ac/wp-content/uploads/2021/07/7-1.jpg","https://officebaz.ir/ac/%d8%aa%d8%a7%d8%b1%db%8c%d8%ae-%d8%b4%d9%85%d8%b3%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d8%b3/",{"$f":"diff(E7,shamsi())","v":739}]
[null,{"$error":"#VALUE!"},"آشنایی با جداول اکسس و اصول طراحی و ایجاد اولین جدول",14000430,14010426,"اکسس مقدماتی",null,"N/A","https://officebaz.ir/ac/wp-content/uploads/2021/07/6-1.jpg","https://officebaz.ir/ac/%d8%ac%d8%af%d8%a7%d9%88%d9%84-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d8%b3/",{"$f":"diff(E8,shamsi())","v":739}]
[null,{"$error":"#VALUE!"},"اشیاء و یا آبجکتهای اکسس + وظایف و نکات مهم هر کدام",14000430,14010426,"اکسس مقدماتی","شروع اکسس","N/A","https://officebaz.ir/ac/wp-content/uploads/2021/07/5-1.jpg","https://officebaz.ir/ac/%d8%a2%d8%a8%d8%ac%da%a9%d8%aa%d9%87%d8%a7%db%8c-%d8%a7%da%a9%d8%b3%d8%b3/",{"$f":"diff(E9,shamsi())","v":739}]
[null,{"$error":"#VALUE!"},"شروع کار با اکسس و ایجاد یک دیتابیس",14000430,14010427,"اکسس مقدماتی","شروع اکسس","N/A","https://officebaz.ir/ac/wp-content/uploads/2021/07/4-1.jpg","https://officebaz.ir/ac/%d8%b4%d8%b1%d9%88%d8%b9-%d8%a7%da%a9%d8%b3%d8%b3/",{"$f":"diff(E10,shamsi())","v":738}]
[null,{"$error":"#VALUE!"},"دیتابیس چیست و چرا ما DataBase اکسس را انتخاب کردیم؟",14000430,14010427,"اکسس مقدماتی","شروع اکسس","N/A","https://officebaz.ir/ac/wp-content/uploads/2021/07/3-1.jpg","https://officebaz.ir/ac/%d8%af%db%8c%d8%aa%d8%a7%d8%a8%db%8c%d8%b3-%da%86%db%8c%d8%b3%d8%aa-03/",{"$f":"diff(E11,shamsi())","v":738}]
[null,{"$error":"#VALUE!"},"کدام نسخه آفیس برای استفاده از اکسس مناسب است ؟",14000430,14010427,"اکسس مقدماتی","شروع اکسس","1 comments","https://officebaz.ir/ac/wp-content/uploads/2021/07/2-1.jpg","https://officebaz.ir/ac/%d8%a8%d9%87%d8%aa%d8%b1%db%8c%d9%86-%d9%86%d8%b3%d8%ae%d9%87-%d8%a2%d9%81%db%8c%d8%b3/",{"$f":"diff(E12,shamsi())","v":738}]
[null,{"$error":"#VALUE!"},"اکسس چیست و چه تفاوتهایی با اکسل دارد؟",14000429,14010427,"اکسس مقدماتی","شروع اکسس","N/A","https://officebaz.ir/ac/wp-content/uploads/2021/07/1-1.jpg","https://officebaz.ir/ac/%d8%a7%da%a9%d8%b3%d8%b3-%da%86%db%8c%d8%b3%d8%aa/",{"$f":"diff(E13,shamsi())","v":738}]