Saturday, 18 May 2019

Excel - Progress Charts

Excel - Progress Charts

Publisher : Osama Jaber
Course Length : 1 hour
Course Price : $120
Course Language : English


Description

This a short course , this course is an Intermediate course, please before you decide preview 10 minutes which consists of one third of the course and you are more than welcome to enroll .
You will learn how to create progress charts , those progress chart are circular in nature looking like doughnut charts but they represent progress ,may be progress in sales or progress or percentage in work done , as seen in the promo and introduction videos .
Then we will paste the Progress Charts into PowerPoint to create some nice Animation to capture the attention of you audience , in meetings or when presenting progress reports or results of any project



Friday, 17 May 2019

Learning & Programming Numerical Methods in EXCEL/VBA

Learning & Programming Numerical Methods in EXCEL/VBA

Publisher : Shams El-Din El-Fouly
Course Length : 10 hour
Course Price : $0
Course Language : English


Description

Numerical modeling is a very powerful branch of mathematics. It is capable to solve very complex problems using very simple techniques.
It is a branch that can differentiate and integral without the need to use any of the sometimes complex differentiation and integration rules. It can create best fit models with just knowing a data set. It can create functions where the only thing we know is its derivative and a condition. And best of all, it can generate approximations that have such a low percentage error that they are as good as the true value. 
But...
There is a limitation to numerical methods. They depend of iterative calculations. If for example you want an approximation with a low error, for example 0.001%, this will require a large amount of calculations which can be sometimes impossible to do by hand not to mention tedious. This is where programming comes in.
In this course I will walk you through not only the workings of each technique but a step by step process on how to program each of these techniques and preform hundreds if not thousands of calculations with a click of a button using one of the most powerful softwares created, EXCEL. And I'll be using excel's inbuilt programming language, VBA.
The great thing about programming languages is they all follow the same programming structure, sequence, repetition and decision making. Meaning, if you know one language  you can learn another very easily by just knowing how these structures are defined in the new language.
In this course you'll have a very good grasp of these structure so if you decide to learn another language afterwards it will be very easy.

This project was a means for me to give back and contribute. I hope you find some value in this course.
Thank you and Enjoy!



Monday, 13 May 2019

Data Analysis Essentials Using Excel

Data Analysis Essentials Using Excel

Publisher : Symon He - Travis Chow
Course Length : 11.5 hour
Course Price : $190
Course Language : English


Description

Ibadullah Khalil - 5 Stars
“A great instructor and guide for the course. All topics were well driven and to the point with no gibberish language used to make it difficult for the learners just like other instructors. A highly recommended course for every beginner who aims to become a data analyst”

Jianyong Chen - 5 Stars
“This is one of the best course I took on Udemy so far. The instructors explained everything in detail and there are practices after each section. Make sure you download all the files, practice on your own, and you will learn a lot. Highly recommend!”


Every business generates data.  But whether you're able to turn that into useful insights depends on your ability to process, manipulate, and ultimately translate that data.
Whether you're working for a company or running your own, being able to make better decisions requires you to be able to analyze and interpret data.  
What data do you need? How do you prep that data? How do you analyze it to answer specific questions?
In this course, we're going to show you step-by-step, exactly how to do that, by starting with the very basics.  

Why Microsoft Excel?

This course is as much about Excel, if not more, than data analysis concepts and techniques. Why?

Excel is still the most popular tool used by analysts in all industries, across all roles.  It's used by financial analysts, marketing analysts, sales analysts, and of course, data analysts.  
Yes, there are many tools out there but if you learn and master the core concepts and techniques of data analysis in Excel, you'll be able to apply your knowledge to a broad range of applications.

Don’t underestimate Excel--a single worksheet can technically hold more than 17 BILLION data points (granted, it will make your computer REALLY slow). Fortunately, most of us running analysis will need to process far fewer data points than that. Still, it speaks to the power of the program.

Maurizio Zippo - 5 Stars
“This is one of the best course I have ever taken and thoroughly enjoyed. Highly recommended if you want to brush up your existing Excel Skills and to learn how to build some complicated formulae. The Pivot Table and Charts were something I always struggled with but thanks to Symon and Travis' explanations they are now so easy to use every day at work, saving me tonnes of time! Many Thanks Symon and Travis for putting together this great course you are my Excel heroes! The case studies on Cryptocurrency and The Start Up Market are absolute gems! I can't wait to get started with your next course.”

Why learn from us?

By signing up with us, you will be learning from two instructors with a combined 35 years of relevant experience across a wide range of analyst roles.  

Travis has been a digital marketer, investor, and entrepreneur for 20 years. He’s led growth in Asia for Groupon and even helped build Excel when he was as an engineer at Microsoft.  He is a data analysis and data visualization expert who pulls from his industry experience to teach some of the advanced data analysis topics you’ll find in this course. 

Symon has been interpreting and analyzing data for 15 years.  He has served as a financial analyst, marketing analyst, and even head of marketing analytics across half a dozen industries.  If you look at his other courses on Udemy, you'll see that he is an Excel and analysis ninja, having taught nearly 100,000 students with over 6000 reviews.  

Together, we’ve pulled directly from our personal experience and put everything we could into this course. In fact, all of the case studies you’ll find inside are inspired by real-world projects we’ve worked on.

What if I don't have any data analysis or Excel background?

No worries! This is why we start with the very basics in our foundational sections, which is designed to get you familiar with Excel before we move on to more advanced topics.  You can be a complete beginner and take this course.  It might sometimes feel like you're drinking out of a fire hose, but if you put in the time and effort we promise you’ll see results by following our course and doing the exercises. 

We then progressively increase the difficulty as you move along in the course, culminating in advanced techniques taught through our case studies.  
If you do have an Excel background, you can skip or skim through the foundational sections and move directly into the more advanced topics.  

Stephen Dias - 5 Stars
“If you're trying to learn the foundations of excel this course is all you need.”

Brandon Parker - 5 Stars
“I have a lot of experience building excel models and purchased the course for the case studies. I didn't expect to learn much from the introductory parts but was surprised to find additional keyboard shortcuts I had never learned as well as powerful new functions that will make my life a lot easier. This course helped me brush up on functionality that I often neglected while using excel and was super comprehensive. I look forward to continuing using this course as additional case studies are added and highly recommend it for even excel experts.”

Learn through practice.
Like most things in life, becoming proficient at data analysis in Excel takes practice.  A lot of practice.

Sure, you'll pick up plenty just from watching, but you'll be doing yourself a disservice if you don't download our more than 100 custom-built Excel practice files specifically designed to help you master the program.

We're not done adding all our content yet, either.  This class was initially created an "intro" course, but it will soon become a complete coverage of all things data analysis in Excel.  

In conclusion, does any of the following apply to you?

    1.     Do you want to really know your way around Excel?
    2.     You have data for your work or business but you're not sure what to make of it?
    3.     You might know your way around Excel but you're not confident about turning data into business insights
    4.     You frequently receive Excel spreadsheets from others but want to better understand how they arrived at their conclusions?
    5.     You want to learn the best practices when it comes to using Excel for data analysis.
    6.     You are intimidated by spreadsheets and terms like Pivot Tables and VLookups
    7.     You want to learn a skill set that is useful for any role in any industry you get into later.


If so, then take charge and take our course.
You have absolutely ZERO risk. Udemy gives you a solid-as-an-oak-tree 30-day money back guarantee.  You have nothing to lose and everything to gain.

So if you're ready to go from data deficient to data proficient, enroll now!



Friday, 10 May 2019

Microsoft Word 2016 for Everyone

Microsoft Word 2016 for Everyone

Publisher : Prof. K
Course Length : 2.5 hour
Course Price : $190
Course Language : English


Description

This course provides a comprehensive tutorial on using Microsoft Word 2016, whether you are a student, a business user or in a corporate environment.  Speed learn Word 2016 from start to finish learning Microsoft Word from the basics to the advanced features.
This course is expertly designed for new users to get a great start while helping more experienced users fill in any gaps in their knowledge. You enjoy more than 50 expert video tutorials clearly showing you how to use Microsoft Word 2016.
Learn what's new in Microsoft Word 2016. Get up to date in order to be a true Word power user.
This Word 2016 course will renew your confidence and recharge your career and resume. This course gives you everything you need to know about Microsoft Word 2016 for personal use or running your own business.
The self-learning format allows you to watch a short video tutorial and follow along using your Microsoft Word 2016 program. You'll have a lifetime of access to the course allowing you to revisit and learn at your own schedule.
Now you can become a master at using one of the world's most popular computer applications – Microsoft Word 2016.



Tuesday, 7 May 2019

Microsoft Office (Word-Excel-PowerPoint) مايكروسوفت أوفيس

Microsoft Office (Word-Excel-PowerPoint) مايكروسوفت أوفيس

Publisher : 04 Academy
Course Length : 4.5 hour
Course Price : $140
Course Language : English


Description

عزيزي المتدرب، من المتوقع بعد انتهائك من هذا البرنامج التدريبي أن تكون قادرًا وبكفاءة على أن:
أولاً: تتعرف على واجهة برنامج Microsoft Word ومعرفة Tabs الرئيسية.
ثانيًا: تعرف طريقة العمل على Templates
ثالثًا: تعمل على قوالب البرنامج والإضافة عليها والعمل على خيارات الطباعة.
رابعًا: تستخدم الجداول المختلفة وتستطيع التعديل عليها ودمجها.
خامسًا: تتعرف على الهوامش العلوية وإضافة Header And Footer والاقتباسات.
سادسًا: تستطيع إضافة الصور والفيديوهات وsmart art والتعديل عليهم.
سابعًا: تضيف شرائح أو مستند من برنامج Word أو ورقة عمل من برنامج .Excel
ثامنًا: تعرف كيفية كتابة التعليقات على الشرائح والتعديل عليها وحذفها
تاسعًا: تعرف ما هي الشريحة الرئيسية وكيف تستخدمها وكيف تضيف الصور إليها.
عاشرًا: تعرف كيفية إنشاء نسق وقالب خاصين بك وكيف تحرر الرؤوس والتذييلات.
الحادي عشر: تُدرك كيف تضيف الحركات إلى نص أو صورة أو شكل أو SmartArt
الثاني عشر: تعرف كيف تستخدم مسار الحركة لعنصر من عناصر الشريحة أو تقوم بإضافة انتقالات بين الشرائح.
الثالث عشر: تعرف كيف تضيف فيديو أو صوت وكيف تضبط خيارات التشغيل الخاصة بهما وكيف تضيف ارتباطًا تشعبيًّا.
الرابع عشر: تعرف كيف تسجل الشاشة، وكيفية استخدام الـ action buttons
الخامس عشر: تعرف كيفية تصميم عرض مخصص وكيف تستخدم مؤشر الليزر والتعليقات التوضيحية وإخفاء الشرائح أثناء العرض.
السادس عشر: تعرف كيف تنظم شرائح العرض إلى أقسام وكيف تستخدم أداة الـ Zoom
السابع عشر: تعرف كيف تقوم بتسجيل عرض الشرائح وإعداد عرض PowerPoint تقديمي بحيث يتم تشغيله تلقائيًّا.
الثامن عشر: تطبق تحويل العرض التقديمي إلى فيديو.
التاسع عشر: تعرف ما هي استخدامات المفتاح F4
عشرون: تطبق بجميع العمليات والمعادلات الحسابية في برنامج Excel.
الحادي والعشرون: تُنشئ رسومات بيانية في برنامج Excel.
الثاني والعشرون: تحلل البيانات من خلال أداة Pivot table في برنامج Excel .
الثالث والعشرون: تنم البيانات من أجل سهولة الوصول إليها في برنامج Excel .
الرابع والعشرون: تحلل البيانات من خلال أداة Power Pivot في برنامج Excel .
الخامس والعشرون: تستخدم solver tool وأداة goal seek في برنامج Excel .
السادس والعشرون: تحمي البيانات والملفات النهائية الخاصة بك في برنامج Excel



Friday, 26 April 2019

Complete Excel 2016 Guide: Master Spreadsheets Today!

Complete Excel 2016 Guide: Master Spreadsheets Today!

Publisher : Victoria White
Course Length : 2 hour
Course Price : $20
Course Language : English


Description

Hi there, my name is Victoria White and I will be your instructor for this presentation on Udemy. I would like to welcome you to my course The Complete Beginner’s Guide to Microsoft Excel 2016 - A Step-by-Step Journey into Spreadsheets.
Want to be more organized?
Want to learn programs faster?
Well you have come the right place!
Microsoft Excel allows you to use its program for the betterment of your careers. In Excel you have many options in which you are able to use to your advantage such as inserting picture, tables and charts for a visual appeal. Using shortcut and other options, allows you to navigate through Excel much faster and be more efficient. Using the skills taught in this course will allow you to be more efficient when working and minimize the use of having to go back and edit. Doing it right the first time is better and less time consuming when you know what your doing!
Each lecture is simplified at a beginner level, in order to teach anyone and everyone at all levels the simplest and easiest version of how to use Microsoft Excel. Lectures are specified on individual sections for less confusion. Straight to the point videos with little to no rambling.  
Please be sure to look out for my other courses here on Udemy!
All of my courses come with a no questions asked, 30-day money back guarantee.
Once finished the course, I would greatly appreciate any feedback you may have, so be sure to rate and leave a comment about what you liked and disliked about my course. Your feedback will help me improve the course, as well as, future courses to come!
Feel free to recommend any courses you would like to see me create for your benefit.