آموزش ایجاد یک ابزار حسابداری با Excel
آموزش ایجاد یک ابزار حسابداری با Excel
در این آموزش تصویری با ایجاد یک ابزار حسابداری با استفاده از نرم افزار Excel آشنا می شوید.
این دوره آموزشی محصول موسسه Udemy می باشد.
سرفصل های دوره:
دانلود فایل Excel
انواع داده ها در Excel
ساخت نوار ابزار
تمرین در Excel
کار با متن در Excel
طراحی و ساخت تب و متن
کار با برگه ها در Excel
کار با توابع
ساخت گراف
کار با برگه Excel توسط Udemology
و…
عنوان دوره: Udemy Excellence in Excel Create a bookkeeping tools by doing
مدرس : Nicky Wong
این فیلم آموزشی اوریجینال بوده و به زبان انگلیسی ساده و روان ، در محیط نرم افزار و قابل درک برای همه تدریس می گردد
Excel, create by Doing! Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool? This course is for you!
This course will teach you how to use Excel functions and create a useful Bookkeeping tool. Many people learn Excel functions and all the possible options that you can do with Excel. The real thing is that you will probably not use 80% of the power of Excel.
Excel is powerful but if you do not understand how to use it, your knowledge remains powerless. This course will show you how to use just a few functions and create in the meanwhile a very useful tool. This learning method is named CREATE BY DOING!
If you feel intimidated by Excel do not worry! The real issue is not Excel or You but by the method of learning it! Yes, the way you learn something can be successful or unsuccessful. This course uses the SPEED LEARNING methods of the learning cone. What is that? This is a method development make sure you truly remember 90% of everything you learn. How? Just by doing and following the exercises.
This course is active, and you have to do the exercises and follow along.
Why should I take this course? Your competitor has a bigger course!
I understand you point, but do you know the difference between have a toolbox and understanding to use just only 2 tools. I can teach you every tool you want that you can add all the tools in your toolbox. But would you be able to see the practical value out of it? I do not think so.
What if I give you just 2 tools, a screwdriver and a saw and teach you how to create a great piece of furniture? That would be 100% more valuable and that is what I do! I teach you to make useful tools that you can use for your personal life. By doing you create your furniture! That has a lifelong value!
There is a real difference between knowledge and power. Knowledge is only potential power, without the practical use of it, it becomes powerless. Power is the knowledge that you apply in your daily life! This course is powerful because you use the tools and put it into great use.
I never succeeded in Excel, is this course suitable for me?
Success is a path you walk. Learning Excel is exactly the same. Did you fail before; perhaps you took the wrong path. You learned from a bad teacher or a boring book. If you took the wrong path all you need is readjust your path and start walking again. This course truly is a very easy and slow paced course with much repetitions and exercises. The way to learn is by doing and by great explanations. This course has it both many times over!
garauntee for 30 days!
To make it even better, I offer this course as 30 day money back. This basically means that if this course is not right for you, you can get your money back in a blink of an eye. There is truly no reason not to do it and it has no risk at all.
Start taking actions right now and take this course. In life you have winners and losers. The winners take action at once and the losers keep on looking and waiting for the right time. In life there is never a right time except NOW! I truly belief you are winner because you are looking and reading this course.
Alright winner, it is time to take action! Click on “Take this course\" and start making great pieces of Excel Furniture!
Category: Office Productivity / Microsoft
What are the requirements?
A mindset of willing to take action (many action exercises)
A working Microsoft Excel 2007 / 2010 / 2013
What am I going to get from this course?
Over 20 lectures and 1.5 hours of content!
Use Excel the right way
Create you own Excel Tool
See practical use of Excel formula`s
What is the target audience?
This Excel course is an introduction for people who want to understand how to create Excel the right way!
People who want to understand how to create basic tools by using formula`s.
Student who are willing to understand Excel step by step in a practical manner.
Students who want to get their feet wet with Excel.
SECTION 1:
Welcome
1
What will you learn in this course!
01:28
Preview
Excel Course
Welcome to this course! Im excited to have you here!
Excel is a wonderful tool to create powerful programs. Sadly, many people cannot grasp the true power of Excel. In this course you will learn the formula`s and functions to create practical Excel sheets and tools.
The real power of Excel is Create by Doing! I do not want to you learn a basic Excel function and let you go. I want you to understand the practical use of Excel by using just a few tools to create something that has a value of a lifetime.
2
Download the Excel File with Raw Data
2 slides
Excel Course Raw Data
In this part you can download the raw data. You will not receive the full data. Why? Because I truly want you to learn it by doing. This course is titled: Create by Doing! It is a challenge and the big question is, can you do it?
Download the Excel sheet so you have the Raw Data at hand that you need for the upcoming lectures.
SECTION 2:
Create part 1
3
Making Tab 1, the raw data
04:37
Preview
Excel Tab 1
In this part you will learn how to add the raw data for the Input tab. You will get started with the first Tab and start placing the Raw Data in the tab. You will understand why the raw data is important and that everything in this tool will be connected with the raw data tab. This is the first step of the bookkeeping system.
4
Making Tab 1, the formula`s
06:05
Excel Tab 1
In this part you will learn how to make the formula for the Input tab. You will understand to use one of the first functions: SUM. This function will automatically sum all the values of the selected cells. You will start using it and automatically sum up different values in the raw data tab.
5
Making Tab 1, the layout
06:25
Excel Tab 1
In this part you will learn how to make the style for the Input tab. You will learn how to create the design and why a proper design is essential to create professional Excel sheets. The main reason you must invest in great layout is to give it a professional look. All the colors are great but be consistent. Each color will communicate something and that makes it very easy for you if ever you need to adjust something.
6
Exercise Test 1
00:57
Excel Exercise 1
In this part have a mini exercise. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 1? This is your challenge, create an equal box as on shown in this video.
Please take action on this exercise. You are here to maximize your learning. Research has shown that if you repeat something within the first 20 minutes of learning, it will stick longer in your mind. Besides, this is a challenge as well. Are you ready for the challenge.
7
Exercise Test 1 Answers Demonstration
01:58
Excel Exercise 1 Answers
In this part you will get the answers of mini exercise. You can double check if you did it properly. You will see here exactly how you had to do test 1 in Excel.
How did the challenge went? Was it hard or easy? Now you can double check the answer and you will see how to do this correctly.
SECTION 3:
Creating part 2
8
Making Tab 2, the text
08:05
Excel Tab 2
In this part you will learn how to make the basic info for the Monthly Sales tab. This is the second tab on the Excel sheet. You will start to input all the basic data of this tab to give it some bones. You will first connect the data from the raw data and add the basic text.
9
Making Tab 2, the formula
12:43
Preview
Excel Tab 2
In this part you will learn how to make the formula`s and functions for the Monthly Sales tab. You will use the function SUMIF to get data based on specifc criteria. This is one of the best functions from Excel. You will notice that you start to have now a linked tab and when you input in the Raw Data tab will automatically influence the results.
10
Making Tab 2, the layout
05:27
Excel Tab 2
In this part you will learn how to make the style for the Monthly Sales tab. You will create a specific design layout to give your Excel sheet a professional look and feel. This will be equal to the layout design methods of Tab 1.
11
Exercise test 2
00:50
Excel Exercise 2
In this part have a mini exercise. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 2? This is your challenge, create an equal box as on shown in this video.
How well did you understood the lessons and functions from this section? Please stop the video and start creating the exact same match as on the video. The focus on this course is repetition with action. This is the fastest way you can learn anything. Please start doing and create this sheet. Good luck!
12
Exercise Test 2 Answers Demonstration
05:28
Excel Exercise 2 Answers
In this part you will get the answers of mini exercise. You can double check if you did it properly. You will see here exactly how you had to do test 2 in Excel. How well did you do the exercise? Did you manage to get the desired results? Just follow this video and look what parts you can fine tune and what parts are easy.
SECTION 4:
Creating part 3
13
Making tab 3, the text and design
06:39
Excel Tab 3
In this part you will learn how to create the text and design for the Dashboard. You will connect the basic information from the previous tabs and give it a simplistic look and feel displaying the most important information. You will notice that the information is connected from tab 1 and tab 2.
14
Making tab 3, the formula & functions
11:29
Excel Tab 3
In this part you will learn how to create the formula & functions of the Dashboard. You will use the functions LARGE, SMALL & VLOOKUP (vertical look up) to get data from the previous tabs.
LARGE (searches the largest value)
SMALL (searches the smallest value)
VLOOKUP (searches for vertical values)
15
Making tab 3, the Graph
04:46
Excel Tab 3
In this graph you will learn how to make the graph for the Dashboard. You will know:
where you can find these graph options,
how to select the right data
and how to give it the right color.
This graph will display all profits or losses of each month.
16
Exercise Test 3
00:46
Excel Exercise 3
In this part have a mini exercise. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 3? This is your challenge, create an equal box as on shown in this video.
Once agian repetition is the mother of all learning. In this challenge you have to create something based on formulas. Practice this and pause the video to truly take action. If you have followed along you start to see more and more pieces of the puzzle.
17
Exercise Test 3 Answers Demonstration
04:53
Excel Exercise 3 Answers
In this part you will get the answers of mini exercise. You can double check if you did it properly. Discover if you did everything as it should. Did you had a hard time or was this an easy challenge to take? Find out all the steps you needed.
SECTION 5:
Thank you!
18
Final Points
02:40
Excel Conclusions
Congratulations of completing this course. Remember that you always should continue learning and improve it. That is why I would like to hear from you! Do you want to create something new? Did you like this learning method? Just let me know!
You have learned alot of quality information and understand how to use some functions to create a practical tool. You might wonder what can I do next? This is what you can do from now on:
Go and rate my course!
Go ahead and tell me what you want to learn more about Excel in the discussion board!
How can you use this knowledge in your daily life?
19
Excel Reference sheet by Udemology
4 pages
Excel Reference sheet
You learned a lot and I truly believe you want to make sure you remember all the information as well. So here you have a reference sheet. I placed the best functions on this sheet with a very brief explainaton. Are you on a mobile phone? Do not worry! I have also a mobile format ready for you!
20
Bonus: Further learning
Upcoming
این فیلم آموزشی اوریجینال بوده و به زبان انگلیسی ساده و روان ، در محیط نرم افزار و قابل درک برای همه تدریس می گردد
قیمت : 10000 تومان
روش خرید: برای خرید "آموزش ایجاد یک ابزار حسابداری با Excel" ، پس از کلیک روی دکمه زیر و تکمیل فرم سفارش، ابتدا محصول یا محصولات مورد نظرتان را درب منزل یا محل کار تحویل بگیرید، سپس وجه کالا و هزینه ارسال را به مامور پست بپردازید. جهت مشاهده فرم خرید، روی دکمه زیر کلیک کنید.
1-روی دکمه خرید پستی کلیک نمایید.
2-فرم مربوطه را به صورت کامل و صحیح پر نمایید.
3-سفارش خود را درب منزل از پستچی تحویل گرفته سپس هزینه را پرداخت نمایید.
سایر محصولات :
خرید پستی آموزش ایجاد یک ابزار حسابداری با Excel خرید پستی آموزش طراحی کاور کتاب با GIMP خرید پستی آموزش متوسط طراحی گرافیک با GIMP خرید پستی آموزش کدنویسی سریع در سی شارپ خرید پستی آموزش کامل jQuery برای تازه کاران خرید پستی آموزش کامل طراحی وب با HTML5 و CSS3 و Bootstrap و jquery و mysql خرید پستی آموزش گیت های منطقی در الکترونیک خرید پستی آموزش طراحی وب سایت با ابزارهای پیشرفته خرید پستی آموزش کار با تاریخ و زمان با PHP خرید پستی آموزش فریمورک های MVC برای PHP خرید پستی دوره PHP with MySQL Beyond the Basics خرید پستی دوره Agile Project Management خرید پستی برنامه نویسی برای MEAN Stack و MongoDB خرید پستی اصول تدریس با استفاده از تکنولوژی خرید پستی آموزش Google Drive خرید پستی آموزش ساخت جدول با HTML خرید پستی اسکریپت نویسی Unity با #C خرید پستی آموزش بازاریابی اجتماعی با Facebook و Twitter خرید پستی آموزش Matlab موسسه Udemy خرید پستی آموزش Apache Cassandra از ابتدا خرید پستی آموزش برنامه نویسی پایتون همراه با مثال از ابتدا خرید پستی دوره Cisco CCNP RoutingSwitching 300101 ROUTE خرید پستی دوره Cisco CCNP ROUTE 300101 Handson Labs Exam Prep خرید پستی آزمایشگاه Cisco CCNA – استفاده از Wireshark و GNS3 خرید پستی اجزای داخلی زبان #C – قسمت دوم خرید پستی دانلود فیلم آموزش برنامه نویسی آندروید محصول Lynda خرید پستی دوره Cisco CCNP RoutingSwitching 300115 SWITCH خرید پستی دوره Cisco CCNP Security 300208 SISAS خرید پستی دوره Cisco CCNP TSHOOT 300135 Handson Labs خرید پستی دوره Cisco Virtual Internet Routing Lab VIRL خرید پستی آموزش Citrix NetScaler 105 1Y0253 خرید پستی دوره F5 Local Traffic Manager خرید پستی مبانی GNS3 1x خرید پستی دوره Microsoft Office 365 70346 خرید پستی دوره Microsoft Office 365 70347 خرید پستی دوره Google App Engine Qualified Developer خرید پستی دوره Microsoft Lync Server 2013 70337 خرید پستی دوره Microsoft Windows Server 2012 70414 with R2 Updates خرید پستی دوره NetApp Certified Storage Associate NCSA NS0145 خرید پستی دوره Palo Alto Networks Firewall نرم افزار IBM SPSS Sample Power v301 برنامه تحلیل و سنجش سایز داده های نمونه
آموزش شبیه سازی لباس و پارچه در نرم افزار 3Ds Max
آموزش کامل و کاربردی انیمیشن سازی در نرم افزار Autodesk Softimage از طریق ساخت انیمیشن مبارزه دو کاراکتر انسان
آموزش برنامه نویسی موبایل برای اندروید و اپل بوسیله Phone Gap
ساخت افزونه برای توسعه وردپرس
آشنایی با برخی از پایه های یک زندگی دلپذیر آشنایی با برخی از پایه های یک زندگی دلپذیر
آموزش 3ds Max 2016
آموزش ساخت وب فرم ها در HTML 5
آموزش ایجاد یک ابزار حسابداری با Excel
کلمات کلیدی :
you will learn 1in this part can double check 2in this part creating this mini mini exercise practice this mini exercise answersin this part 3in this part the monthly sales you will this course this part you can part you learn how will learn for the excel create course learn exercise challenge functions learning start
