دانلود و آموزش نرم افزار های حسابداری

دانلود و آموزش نرم افزار های حسابداری همکاران سیستم هلو رافع

دانلود و آموزش نرم افزار های حسابداری

دانلود و آموزش نرم افزار های حسابداری همکاران سیستم هلو رافع

دانلود و آموزش نرم افزار های حسابداری همکاران سیستم هلو رافع-اکانت سایت آپلودباز،اپلودبوی،اپتوباکس

بایگانی

۱۹ مطلب در دی ۱۳۹۴ ثبت شده است

  • ۰
  • ۰

fklgjlk

Latest

Europa 1991 DVDRip

  StoryLine: Just after W.W.II, an American takes a railway job in Germany, but finds his position politically sensitive with various people trying to use him.  
Read More

Epidemic 1987 DVDRip

StoryLine: A film director and a script writer (performed by Lars von Trier and Niels Vørsel themselves) write a screenplay, in which an epidemic spreads about the whole
Read More

Eden 2014 720p

StoryLine: Paul, a teenager in the underground scene of early-nineties Paris, forms a DJ collective with his friends and together they plunge into the nightlife of sex, drugs,
Read More

Creed 2015 DVDScr X265 HEVC CMRAY

Story Line: The former World Heavyweight Champion Rocky Balboa serves as a trainer and mentor to Adonis Johnson, the son of his late friend and former rival Apollo Creed.
Read More

Latest

The Confession 1970 720p BRRip

            The film is about Artur Ludvik, alias Gerard, vice-minister of Foreign Affairs of Czechoslovakia. He realizes he is being watched and followed.
Read More

Latest

Sicario (2015) 720p BluRay

      An idealistic FBI agent is enlisted by an elected government task force to aid in the escalating war against drugs at the border area between

Latest

Gomorra Season 1 COMPLETE 720p BluRay

Ciro disregards tradition in his attempt to become the next mafia mob boss. The internal power struggle puts him and his entire family’s life at risk.   Gomorrah
Read More

Latest

Uprising 2001 720p x265

    Jews rise up in the Warsaw Ghetto against the Nazis in 1943. Uprising 2001 720p WEB-DL https://mega.co.nz/#!i843TDAZ!xd-sJktQGs-sD0KCDjB7EnFoYVOlGvN2vjsPHEw0p_o http://uploadboy.com/qeb9y9nb8pv1.html http://www.uploadbaz.com/uetymm38bp8l http://4upld.com/4exI2
Read More

  • mohamad ali
  • ۰
  • ۰

di

Latest

suits s05 720p x264

  Suits follows college drop-out Mike Ross, who accidentally lands a job with one of New York’s best legal closers, Harvey Specter. They soon become a winning team
Read More

Suits s05 720p x265

  Suits follows college drop-out Mike Ross, who accidentally lands a job with one of New York’s best legal closers, Harvey Specter. They soon become a winning team
Read More

House of Cards s03 480p

  Ruthless and cunning, Congressman Francis Underwood and his wife Claire stop at nothing to conquer everything. This wicked political drama penetrates the shadowy world of greed, sex
Read More

Latest

Daredevil s01 480p

Blinded as a young boy, Matt Murdock fights injustice by day as a lawyer and by night as the Super Hero Daredevil in New York City. Matt Murdock,
Read More

Bloodline s01 720p x265

The Rayburns are hard-working pillars of their Florida Keys community. But when the black sheep son comes home for the 45th anniversary of his parents’ hotel, he threatens
Read More

love 2015 720p bluray hevc x265 381 mb

  StoryLine: Murphy is an American living in Paris who enters a highly sexually and emotionally charged relationship with the unstable Electra. Unaware of the effect it will
Read More

Latest



  • mohamad ali
  • ۰
  • ۰

d7

Latest

1944 (2015) 720p BRRip

The events of the war in 1944, from the Blue Hills to Sõrve Peninsula. Shown through the eyes of Estonian soldiers who had to pick sides and fight
Read More

Latest



Latest

Jeune & jolie (2013) 720p

After losing her virginity, Isabelle takes up a secret life as a call girl, meeting her clients for hotel-room trysts. Throughout, she remains curiously aloof, showing little interest
Read More

SHAMELESS US S06E01 720P X265 HEVC CMRAY

Story Line: An alcoholic man lives in a perpetual stupor while his six children with whom he lives cope as best they can.
Read More

Latest

A Frozen Flower 2008 720p

StoryLine: A historical drama set in the Koryo dynasty and focused on the relationship between a king and his bodyguard. —————————————————– Information: Director:Ha Yoo (as Ha Yu) Writer:Ha
Read More

Burnt 2015 720p BrRip

Adam Jones (Bradley Cooper) is a chef who destroyed his career with drugs and diva behavior. He cleans up and returns to London, determined to redeem himself by
Read More

Mr Holmes 2015 720p BrRip MkvCage

An aged, retired Sherlock Holmes, deals with early dementia, as he tries to remember his final case and a woman, the memory of whom still haunts him. He
Read More

Latest






  • mohamad ali
  • ۰
  • ۰

d5

test

Mustang (2015) dvdrip

Early summer. In a village in northern Turkey, Lale and her four sisters are walking home from school, playing innocently with some boys. The immorality of their play
Read More

The Big Combo 1955 1080p

A police lt. is ordered to stop investigating deadly crime boss Mr. Brown, because he hasn’t been able to get any hard evidence against him. He then goes
Read More


Latest



Latest

Mammon S01 HC Eng mp4

    A newspaper journalist revealing fraud in a large multinational company, finds his family involved, ruining his career, family relations, and entangles him in a following mystery.
Read More

Karakter (1997)

  Jacob Katadreuffe lives mute with his mother, has no contact with his father who only works against him and wants to become a lawyer, at all costs.
Read More

A Pigeon Sat on a Branch Reflecting on Existence 2014 720p BluRay AVC-mfcorrea

Sam and Jonathan, a pair of hapless novelty salesman, embark on a tour of the human condition in reality and fantasy that unfold in a series of absurdist
Read More


atest



  • mohamad ali
  • ۰
  • ۰

download3

  • mohamad ali
  • ۰
  • ۰

download

atest

  • mohamad ali
  • ۰
  • ۰

دانلود2


The Leftovers S02 720p x265

Revolves around mysterious disappearances, world-wide, and specifically follows a group of people who are left behind in the suburban community of Mapleton. They must begin to rebuild their
Read More
  • mohamad ali
  • ۰
  • ۰

دانلود

Latest

Basic Instinct 2 2006 720p BrRip

Novelist Catherine Tramell is once again in trouble with the law, and Scotland Yard appoints psychiatrist Dr. Michael Glass to evaluate her. Though, like Detective Nick Curran before
Read More


Latest




  • mohamad ali
  • ۰
  • ۰

Latest

Blindspot s01 480p

A vast international plot explodes when a beautiful Jane Doe is discovered naked in Times Square, completely covered in mysterious, intricate tattoos with no memory of who she
Read More
  • mohamad ali
  • ۰
  • ۰

برای یافتن مقادیر تکراری در یک ستون از Excel

۱- ابتدا ستون یا محدوده مورد نظر خود را انتخاب کنید.

۲- در سربرگ Home از  نوار ابزار Excel  (به این نوار در Excel 2007 به بعد Ribbon می‌گویند)

گزینه Conditiona Formatting را بزنید.

3- در لیست باز شده، گزینه Highlight Cell Ruls را بزنید.

4- در این لیست گزینه Duplicate Value  را بزنید.

5 – در پنجره آخر، از شما پرسیده می‌شود که سلولهای تکراری چه رنگی شوند.

 

 آموزش جلوگیری ورود اعداد تکراری در Exel

 اعداد تکراری excel

چگونه در Excel از ورود اعداد یا مقادیر تکراری توسط کاربر جلوگیری کنیم؟

همانطور که شاید از قبل بدانید ، شما می‌توانید روی سلولهای Excel ابزار Validation را فعال کنید، ابزار Excel Validation مقادیری را که شما در سلول وارد می‌کنید چک می‌کند و در صورتیکه که معتبر باشد آنرا قبول می‌نماید.

معتبر بودن با شرطی که شما قبلا روی این سلول گذاشته اید سنجیده می‌شود.

ابتدا ستون مورد نظر را انتخاب نمایید.

1- دقت نماید که آدرس سلول فعال شما چیست، مثلادر شکل زیر سلول فعال A1 است.

2- از Ribbon به سربرگ Data بروید و سپس گزینه Validation را انتخاب کنید.

3- مطابق با شکل تنظمات را انجام دهید.

data Validation در Excel

تابع  COUNTIF(A:A,A1) در اکسل مشخص می کند که در ستون A ، چند بار مقادر سلول A1 تکرار شده است و هدف ما این است که این مقدار تکراری نباشد، بنابراین باید این تعداد برابر با یک باشد ، که تکراری نشود.

  • mohamad ali