UdemyData Analysis

Excel & Data Visualization, creating impactful dashboards

التصنيف الكامل: Office Productivity > Microsoft > Data Analysis

Excel & Data Visualization, creating impactful dashboards

عن هذا الكورس

Have you already stepped into the professional world? If yes, you must have noticed that Excel is essential to any function in any industry, not only Bankers or Analysts, but also Marketing (Product/Project manager...), Digital (SEO/SEA managers, CRM, Community manager, Business developer, Product owner...), HR, Client relationship manager etc.Excel is a powerful tool that has become entrenched in business processes worldwide, for analyzing sales data, budgeting, financial modelling, HR planning etc.. It can be your best friend, helping you to simplify your life; but it could also be a nightmare if you don't master it well! Within this course, I hope you can discover the beauty of Excel, perform a deep-dive into this powerful tool and master data analysis with EXCEL! To make your learning more attractive, I organize this course by going through 3 practical cases and also cover the trendy topic of data visualization. I will also share my methodology to create impressive interactive Excel dashboards and show you the most useful Excel functions formulas!The 3 practical cases are based on different sets of data:- Audience and sales data of an e-commerce site, extracted from Google Analytics (c. 5000 lines)- Data on names given in France from 1900 to 2019, extracted from INSEE (c. 700 000 lines)- Data on prices of Cryptocurrency, from Yahoo Finance (c. 50 000 lines)I hope that this course can help you to improve your Excel skills and impress your (future) colleagues! Are you ready? Let’s GO!****** You can also find the SYLLABUS of this course in the introduction section.******

تعلم أونلاين 100%

شاهد الدروس في أي وقت ومن أي مكان

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق ومباشر

ينقلك لصفحة التسجيل الرسمية

سعر الكورس
$109.99
المنصة:Udemy
الانتقال للكورس / التسجيل الآن
🔒 عند النقر، سيتم فتح صفحة الكورس الرسمية على منصة Udemy في نافذة جديدة.

كورسات مقترحة في نفس المجال

عرض كل الكورسات ←
Microsoft PowerPoint  - البوربوينت من الصفر للاحتراف
Udemy
PowerPoint

Microsoft PowerPoint - البوربوينت من الصفر للاحتراف

من أفضل البرامج المستعملة في تصميم عروض تقديمية إحترافية وعمل البريزنتيشن البوربوينت البوربوينت يتم استخدامه كأداة عرض رئيسية في المدارس والشركات ويجب ان يكون مهارة اساسية تتعلمها و تضيفها لمجموعة مهاراتك نظراً لأهميته و كثرة الطلب عليه فى سوق العمل لاحتوائه على مجموعة من القوالب الأنيقة التي تجعل إنشاء العروض التقديمية أكثر بساطة.تستطيع ان تتعلمه من الصفر للاحتراف من هذا الكورسهذا الكورس يتكون من ثلاثة اقسامالقسم الاول : ستتعلم فيه جميع اوامر البوربوينت مع تطبيقات عمليةالقسم الثاني : سيكون شرح لانواع مختلفة من العروض ليساعدك علي الاستيعاب اكثر وتزيد مهاراتك في البوربوينتالقسم الثالث : بعض النصائح لتقديم عرض افضلما ستتعلمه بعد انهائك هذا الكورسإتقان جميع أوامر البوربوينتالتعامل باريحية مع اوامر البوربوينتانشاء الجداول والرسوم البيانيةعمل فيديو انيميشن بواسطة البوربوينتصنع بريزنتيشن جذابةنصائح حول تقديم عرض رائعاضافة الاشكال والايقوناتاضافة المعادلات الرياضيةكل اختصارات الكيبورد المرتبطة بالبرنامجحفظ وطباعة البريزنتيشنتوفير الوقت والمجهود في تصميم البريزنتيشناضافة الانتقالات والمؤثرات الصوتية سجل الان لتتعلم البوربوينت من المستوي المبتدئ للمستوي المتقدم من خلال شرح وافي وتطبيقات عملية بعد انتهائك من هذا الكورس ستكون قد تعلمت كل الاساليب المختلفة لتصميم كل انواع البريزنتيشن وازدادت مهاراتك في استخدام البوربوينت واصبحت تتعامل بكل اريحية مع اوامر البرنامج بعد انتهائك من هذا الكورس ستكون قد تمكنت من عمل سلايدز احترافية وجذابة وازدادت مهاراتك في استخدام البوربوينت Enroll now and learn Microsoft PowerPoint from zero to hero and take full advantage of the software Thanks

Custom PivotTable Styles and Formatting: Advanced Excel
Udemy
Microsoft Excel

Custom PivotTable Styles and Formatting: Advanced Excel

**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to Advanced PivotTables in Excel, designed to elevate your data analysis skills and expertise.In this course, you will master formatting and customizing PivotTables to present data professionally. You'll explore various formatting options using Excel's PivotTable Design ribbon, from cell shading to header customization. You will also learn how to apply custom number formats, manage blank cells, and use conditional formatting to highlight key data points for better readability and visual impact.Each module includes video demonstrations and practical exercises to ensure you master each concept. Whether you are looking to streamline your data analysis or present your findings clearly, this course will provide you with the necessary tools and knowledge. Join us and take your PivotTable skills to the next level.In this course, you will learn how to:Apply PivotTable Styles from the Design Ribbon.Customize PivotTable Styles for consistent formatting.Utilize Custom Number Formatting for precise display.Enhance PivotTable presentations by customizing row and column labels for clarity.This course includes:35 minutes of video tutorials5 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

SAP SuccessFactors Employee Central Configuration
Udemy
SAP SuccessFactors

SAP SuccessFactors Employee Central Configuration

SAP SuccessFactors Employee Central is a cloud-based human capital management (HCM) system that serves as a central repository for employee data, providing a comprehensive solution for core HR processes.This thorough training program is intended primarily for consultants who want to become experts at configuring the SAP SuccessFactors Employee Central module as well as advanced system administrators in order to gain the knowledge and expertise to customize the solution as it suits all their unique business requirements. Therefore, it is highly recommended to follow our first course "SAP SuccessFactors Employee Central full business process training" if you do not have a good understanding of what is initially offered by the solution for end users and administrators.Indeed, participants will explore the basic concepts, ways to setup, and best practices that are necessary for putting Employee Central into practice and making it optimal for any number of customer needs.The course touches on multiple aspects of the Employee Central solution:- Configuration of objects related to the company structure and its foundation, - Customization of employee profiles structuring, the data fields and their parameters,- Set up of business rules for requirements associated to employee data validation workflows, automatic propagation of data fields, alerts and notifications, as well as event reason derivation,- Configuration of all document templates to be directly generated from the system- Management of security and role based permissions.

Learn Oracle PL/SQL - A Comprehensive Training Course
Udemy
PL/SQL

Learn Oracle PL/SQL - A Comprehensive Training Course

In this training course by Infinite Skills on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry. Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there! By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.

MO-100: Microsoft Word (Word and Word 2019) exam prep
Udemy
MO-100: Microsoft Office Specialist: Word Associate (Office 2019)

MO-100: Microsoft Word (Word and Word 2019) exam prep

Lots of people use Microsoft Word, but there are a lot of features hidden away. In this course, we'll be looking at features that can help you more easily and effectively create and maintain professional-looking reports, multicolumn newsletters, résumés or CVs, and business correspondence.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.We'll start off by looking at Inserting and formatting text, paragraphs and sections, including how to use the Format Painter, and how to insert page, section and column breaks.We'll then look at Managing tables and lists. We'll convert text to tables, configure our row headers in our tables to repeat on multiple pages, and create multi-level lists.Next up is Creating and managing references, such as footnotes and endnotes, bibliographies, and table of contents, and then managing comments and tracking changes to documents.We'll then look at how to insert and format graphic elements. This includes text boxes, pictures, SmartArt, screenshots, and 3D models.We'll finish off by looking at how to manage documents, such as links to locations within documents, modifying headers and footers, and inspecting documents for personal information, and accessibility and compatibility issues.No prior knowledge is required. And there are regular quizzes to help you remember the information, so you can be sure that you are learning.Once you have completed this course, you will have an expanded knowledge of Microsoft Word. And with some practice, you could even take the official Microsoft MO-100 exam, which is one of the three requirements to get an official Microsoft Office certification – wouldn't that look good on your CV or resume.

Excel Essentials for Professionals: Boost Your Productivity
Udemy
Microsoft Excel

Excel Essentials for Professionals: Boost Your Productivity

Hi guys,Are you ready to unlock the full potential of Microsoft Excel? Whether you're a beginner or looking to sharpen your skills, this course is your ultimate guide to mastering Excel, packed with engaging lessons, hands-on quizzes, and real-world challenges.What You’ll Learn:Navigate Like a Pro: Explore the Excel interface and discover essential shortcuts to streamline your work.Master Foundational Skills: Build a strong foundation with data entry, editing, formatting, and leveraging tools like the Fill Handle.Harness the Power of Formulas: Understand basic formulas and functions such as SUM, AVERAGE, MAX, and MIN, and apply them in practical business scenarios.Enhance Data Visualization: Create better-looking worksheets using formatting tools, borders, alignment, and charts to make your data stand out.Simplify Data Management: Organize and analyze data effortlessly with filtering, sorting, conditional formatting, and efficient find-and-replace techniques.Why Choose This Course?Interactive Learning: Test your understanding with quizzes after every key topic.Practice Challenges: Tackle realistic exercises to cement your skills in each section.Practical Applications: Gain insights into how Excel solves real-world problems in business and beyond.Preview Enabled Lectures: Get a sneak peek into select lectures before committing to the course.Who This Course Is For:Beginners aiming to build a solid Excel foundation.Professionals seeking to enhance their productivity and efficiency with Excel.Students and job seekers preparing for a career that requires Excel proficiency.</