تبلیغات
هرچه که میخواهددل تنگت... - آموزش اکسل
چهارشنبه 17 آذر 1395  02:57 ب.ظ

اکسل ( Excel ) یك نرم افزار جامع برای كار با صفحات گسترده (Spread Sheet) است.

با كمك آموزش اکسل میتوانید انواع جداول حاوی متون و اعداد را ایجاد كرده و از فرمولها و توابع ریاضی، آماری و منطقی جهت محاسبات مربوط به آنها استفاده كنید. همچنین، امكان ایجاد نمودارهای متنوع از مقادیر موجود آموزش در جدولها نیز امكانپذیر است. در صورت استفاده از قابلیتهای آموزش حرفه ای مانند ماكروها و زبان VBA میتوان گفت كه Excel تقریباً برای ایجاد تمام كاربرگها و نرم افزارهای مالی و آماری راه حل مناسبی به شمار می آید.

بخش اول آموزش  اکسل از ویرا به ادرس http://www.vira20.ir/excel-learning آشنایی با Excel اجرای Excel 2016 در ویندوز 10 چگونه یک کتاب کاری (Workbook) را باز کنیم آموزش اکسل آشنایی با محیط Excel 2016 آشنایی با Ribbon بزرگنمایی و کوچک نمایی صفحه حرکت در صفحات در Excel 2016 ذخیره کردن یک کتاب کاری بستن یک کتاب کاری باز کردن یک کتاب کاری اخیراً استفاده شده استفاده از کمک (Help) خروج از Excel 2016

روش کار با کتابهای کاری آموزش اکسل (Workbook) ایجاد کتابهای کاری در Excel 2016 روش وارد کردن داده‌ها آشنایی با فرمولها افزودن سطر یا ستون جدید تابع sum حذف سطر یا ستون جابجایی سطر یا ستون آشنایی با آموزش اکسل Cut، Copy و Paste دستوارت Undo و Redo دستورات Find و Replace مدیریت صفحات) Sheetها( ذخیره سازی فایل در Excel 2016 بخش چهارم : روش پیکربندی یا Format کتابهای کاری تنظیم اندازه سطرها و ستونها ادغام سلولها در Excel 2016 نحوه نمایش اعداد (Number Format) پیکربندی متن در Excel 2016 کار با Style یا فرمتهای آماده کار با غلط یاب (Spell Checker) آشنایی با تصحیح کننده خودکار (AutoCorrect) استفاده از ابزار AutoFill کار با ابزار Conditional formatting و Format Painter فرمتبندی شرطی در اکسل 2016 کار با ابزار Quick Analysis

انواع نماها و چاپ صفحات روشهای مشاهده صفحات کاری در Excel 2016 دستور Split دستور Freeze ابزار Auto Filter افزودن سربرگ و پاورقی تنظیم صفحه با Page Setup تنظیم محدوده قابل چاپ پیش نمایش چاپ و تنظیمات آن در Excel 2016

آشنایی با توابع و فرمولها در Excel 2016 کپی کردن فرمول اتصال به محتوای یک سلول استفاده از محاسبه‌گر خودکار (AutoCalculate) تابع sum عملگرها در Excel 2016 توابع حداقل، حداکثر، تعداد و میانگین ابزار AutoSUM ( دانلود : dl.pooryab.ir/files/LearnExcelFullBook.pdf) کار با قابلیت Manual Calculation
فرمول ها و توابع تابع FV تابع PMT کار با تابع شرطی IF استفاده از تاریخ در توابع در آموزش اکسل Excel کار با توابع آماری تابع آزمون T تصحیح خودکار ورودی تابع تابع پیرسون بخش هشتم : نمودارها، تصاویر و جلوه ویژه ایجاد یک نمودار در Excel 2016 تعیین شکل نمودار تغییر داده‌های نمودار تغییر نوع نمودار تغییر ظاهر نمودار تیتر نمودار محل قرارگیری راهنما ایجاد جلوه ویژه رسم اشکال آماده درج تصویر نمودارهای Sparklines

بسته نرم افزاری آفیس (Microsoft Office) یکی از مجموعه نرم افزارهای پرکاربرد بین کاربران کامپیوتر می باشد

می توان گفت کمتر افرادی پیدا می شوند که به این نرم افزارها نیازی نداشته باشند. یکی از نرم افزارهای پرکاربرد بسته نرم افزاری آفیس، نرم افزار صفحه گسترده اکسل یا Excel می باشد. آموزش اکسل این نرم افزار با توجه به قابلیت هایی که دارد، نیاز است تا آن را به عنوان اولین نرم افزارهایی که نیاز داریم، یاد بگیریم. در این آموزش ابتدا با محیط اکسل ۲۰۱۳ و سپس با وارد کردن داده ها و قالب بندی آن آشنا می شویم. در ادامه در رابطه با مدیریت کاربرگ ها نکاتی گفته می شود. سپس به مباحث فرمول نویسی، توابع و رسم نمودار در اکسل می رسیم. در این آموزش اکسل از سایت ویرا سعی شده نکات ساده کار با اکسل به صورت خیلی کوتاه ارائه شود.


  • آخرین ویرایش:-
نظرات()   
   
www.healthaim.org
پنجشنبه 24 مرداد 1398 01:28 ب.ظ
Greetings! Very useful advice within this article!
It is the little changes that make the greatest changes.
Thanks a lot for sharing!
Jerilyn
یکشنبه 30 تیر 1398 08:46 ب.ظ
Ok, so you’re judge, nevertheless the reason why can i contact him if I’m certainly not thinking about him?
Admiringly, most of persons next persons be present at pace engagement experiences
simply because they wish to get back together into rendezvous
otherwise live out timing. The point connected with tempo night out
should be to dig up several work-in to state of course for your requirements in order to probably
hand them over a accidental later and also lead to give rise to brunette before feast with them.
If they subsist repugnant as a consequence you recognize for certain people don’t desire to observe them
once more, produce a notice of the usb ports never-endingly your cheat slip.

While he or she wishes to drop a line to an individual, you realize the him after that
people don’t.
A NO-NO In relation to Pace Dating Los Angeles
Ariel
دوشنبه 20 خرداد 1398 03:27 ق.ظ
I enjoy what you guys are usually up too. Such clever work and coverage!

Keep up the superb works guys I've added you guys to my blogroll.
http://tinyurl.com/nguc87u
چهارشنبه 15 خرداد 1398 03:11 ب.ظ
Appreciating the hard work you put into your website and in depth information you offer.
It's great to come across a blog every once in a while that isn't the same out of date rehashed
information. Fantastic read! I've saved your site and
I'm adding your RSS feeds to my Google account.
Shavonne
چهارشنبه 8 خرداد 1398 08:34 ب.ظ
I am really enjoying the theme/design of your site.
Do you ever run into any internet browser compatibility problems?

A few of my blog visitors have complained about my
site not working correctly in Explorer but looks great in Safari.
Do you have any solutions to help fix this issue?
Leon
چهارشنبه 8 خرداد 1398 01:19 ب.ظ
Very nice post. I definitely appreciate this site.
Keep it up!
Cristina Boner
سه شنبه 7 خرداد 1398 12:36 ب.ظ
Excellent post. I was checking constantly this blog and I am
impressed! Very useful information particularly the closing part :) I take
care of such information a lot. I used to be looking for this certain information for a very lengthy time.
Thank you and good luck.
tinyurl.com
سه شنبه 31 اردیبهشت 1398 02:46 ق.ظ
Good day! I could have sworn I've been to this site before but
after browsing through some of the post I realized it's new to me.

Anyhow, I'm definitely delighted I found it and I'll be bookmarking and
checking back frequently!
tinyurl.com
دوشنبه 30 اردیبهشت 1398 10:35 ب.ظ
This is my first time visit at here and i am in fact impressed to read everthing at
single place.
Sonia
شنبه 28 اردیبهشت 1398 12:42 ب.ظ
This is a topic that is close to my heart... Take care! Exactly
where are your contact details though?
Daniel Valente Dantas
پنجشنبه 26 اردیبهشت 1398 10:23 ق.ظ
Hey there I am so glad I found your website, I really found you by error, while I was researching
on Aol for something else, Anyhow I am here now and would just like to say many thanks for a incredible post and
a all round exciting blog (I also love the theme/design), I don't have time to browse it all
at the minute but I have saved it and also added in your RSS feeds,
so when I have time I will be back to read more, Please do keep up the fantastic work.
tinyurl.com
سه شنبه 17 اردیبهشت 1398 12:46 ق.ظ
Please let me know if you're looking for a author for
your weblog. You have some really great posts and I think I would be a good asset.
If you ever want to take some of the load off, I'd love to write some articles for your blog in exchange
for a link back to mine. Please blast me an email if interested.
Kudos!
http://tinyurl.com
یکشنبه 15 اردیبهشت 1398 12:31 ب.ظ
Attractive section of content. I just stumbled upon your website and in accession capital
to assert that I acquire actually enjoyed account your blog posts.
Any way I will be subscribing to your feeds and even I achievement you access consistently rapidly.
Itamar Serpa
جمعه 13 اردیبهشت 1398 12:11 ب.ظ
Hi there, just became alert to your blog through Google, and found that it is truly informative.
I'm going to watch out for brussels. I'll be grateful
if you continue this in future. Lots of people will be benefited from your
writing. Cheers!
Nilda
جمعه 13 اردیبهشت 1398 01:14 ق.ظ
I constantly spent my half an hour to read this weblog's content all
the time along with a cup of coffee.
Clara
چهارشنبه 11 اردیبهشت 1398 11:40 ب.ظ
This website was... how do I say it? Relevant!! Finally I have found something
that helped me. Kudos!
Kléber Leite
چهارشنبه 11 اردیبهشت 1398 06:22 ق.ظ
Hurrah, that's what I was seeking for, what a material!

existing here at this blog, thanks admin of this site.
Louis
شنبه 7 اردیبهشت 1398 02:27 ب.ظ
Hi there! This post couldn't be written much better!
Reading through this article reminds me of my previous roommate!
He constantly kept preaching about this. I most certainly
will send this post to him. Fairly certain he's going to have a great read.
Many thanks for sharing!
Carlos Magno Nunes Barcelos
شنبه 7 اردیبهشت 1398 01:34 ق.ظ
Hey there! I know this is kind of off topic but I was wondering which blog platform are you
using for this website? I'm getting sick and tired of Wordpress because I've had problems
with hackers and I'm looking at alternatives for another platform.
I would be awesome if you could point me in the direction of a good platform.
tinyurl.com
جمعه 6 اردیبهشت 1398 09:44 ق.ظ
My spouse and I stumbled over here different web page and thought
I may as well check things out. I like what
I see so now i'm following you. Look forward to checking out your web page repeatedly.
http://tinyurl.com/
پنجشنبه 5 اردیبهشت 1398 05:48 ب.ظ
An impressive share! I have just forwarded this
onto a colleague who was doing a little research on this.

And he in fact ordered me breakfast due to the fact that I stumbled upon it for him...

lol. So allow me to reword this.... Thank YOU for the meal!!
But yeah, thanks for spending some time to talk about this subject here on your website.
Jerri
چهارشنبه 4 اردیبهشت 1398 09:29 ق.ظ
Hi, I check your new stuff regularly. Your story-telling style is awesome, keep
up the good work!
tinyurl.com
دوشنبه 2 اردیبهشت 1398 10:37 ق.ظ
What i do not realize is actually how you're no longer really a lot more smartly-liked than you might be now.
You're very intelligent. You recognize thus considerably in the case
of this subject, produced me in my opinion imagine it from so
many numerous angles. Its like women and men are not fascinated unless it is one thing to accomplish with Woman gaga!

Your own stuffs great. Always maintain it up!
tinyurl.com
دوشنبه 2 اردیبهشت 1398 12:38 ق.ظ
Heya i am for the first time here. I found this board and I to find It truly helpful & it helped me out much.
I hope to provide one thing again and aid others such as you aided me.
Isobel
یکشنبه 1 اردیبهشت 1398 01:40 ق.ظ
Very nice article, totally what I was looking for.
tinyurl.com
شنبه 31 فروردین 1398 03:27 ب.ظ
Wow, marvelous blog layout! How long have you been blogging for?
you make blogging look easy. The overall look of your site is fantastic,
as well as the content!
tinyurl.com
شنبه 31 فروردین 1398 12:16 ب.ظ
Wow that was strange. I just wrote an extremely long comment but
after I clicked submit my comment didn't appear. Grrrr...
well I'm not writing all that over again. Anyway, just
wanted to say great blog!
hamilton dias de souza
جمعه 30 فروردین 1398 02:40 ق.ظ
Fastidious response in return of this difficulty with genuine arguments and telling everything about
that.
Bernadine
پنجشنبه 29 فروردین 1398 04:08 ب.ظ
Hey There. I found your weblog using msn. That is an extremely smartly written article.
I'll make sure to bookmark it and return to learn more of your helpful info.
Thanks for the post. I'll definitely comeback.
Nichole
یکشنبه 25 فروردین 1398 08:40 ب.ظ
This post will assist the internet visitors for creating new website or even a weblog from start to end.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر
نمایش نظرات 1 تا 30