UdemyMicrosoft Excel

Microsoft Excel: Master Data Analysis, Cleaning & Dashboards

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

Microsoft Excel: Master Data Analysis, Cleaning & Dashboards

عن هذا الكورس

Hey Everyone,Microsoft Excel: Master Data Analysis, Cleaning Dashboards is a comprehensive course designed to turn you into a confident and efficient Excel user. Whether you are a beginner or an intermediate user, this course provides a step by step approach to mastering data management, analysis, and visualization.You will begin with the fundamentals of Excel, including navigating the interface, entering data, and applying essential formatting techniques. These foundational skills ensure that you can work with spreadsheets efficiently and accurately.Next, the course focuses on data cleaning, one of the most crucial steps in any analysis. You will learn to remove duplicates, handle missing or inconsistent data, and use powerful text and date functions to organize raw datasets. These skills prepare your data for accurate and reliable analysis.The course then introduces data analysis techniques, including the use of formulas, logical functions, and PivotTables. You will practice summarizing complex datasets, identifying trends, and performing calculations that provide actionable insights for business or research purposes.A significant portion of the course is dedicated to dashboard creation and data visualization. You will learn to design interactive dashboards using charts, slicers, conditional formatting, and visualization best practices. These dashboards will allow you to present data clearly and professionally, making your analysis impactful.In addition to hands-on exercises, the course teaches practical tips and time saving techniques that professionals use daily. By combining cleaning, analysis, and visualization, you will develop a complete workflow for handling any dataset efficiently and accurately.By the end of this course, you will be able to clean large datasets, perform advanced data analysis, and create interactive dashboards that communicate insights effectively

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

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

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق

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

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

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

عرض كل الكورسات ←
Tableau Desktop - Intermediate
Udemy
Tableau

Tableau Desktop - Intermediate

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.This course continues where the beginner course ends. Multiple data sources are introduced as well as table calculations and formula construction. More sophisticated visualizations are introduced and some advanced dashboard techniques are introduced as well.You will learn more about the following listed items:Enhancing visualizations with formatting and annotations.Creating visualizations from multiple data sources with joining and merging.Performing calculations with Table calcs, basic calcs, logic calcs, and Tableau functions.Grouping and binning data for custom analysis.Enhancing analysis with basic and interactive filters.Create intermediate level charts including: Pie Charts, Donut Charts, Area Charts, Line and Column Charts, Histograms, Box Plots, Gantt Charts, Bullet Charts, Dual-Axis Maps, Layered Maps, and WMS Maps.Creating interactive dashboards with specific actions

Complete Microsoft Powerapps Training from Zero to Hero
Udemy
Microsoft Power Apps

Complete Microsoft Powerapps Training from Zero to Hero

Join Now Because it's time to get started The Microsoft PowerApps with loads of Examples and projects. it's covers everything and will be contentiously updated. with more lectures every period. Let's Build a Mobile and Web applications using PowerApps Step by Step, not just Theoretical and ABC examples.This course is recommended as it covers not only Basics topics But additional material and concepts.The course Cover:-What's PowerAppsCreate Trial PowerApps accountPowerApps Tour Are There Lots of Examples? There are loads of examplesPay once, benefit a lifetime! with 30 Days money-back guarantee. Certification after course completion

Microsoft Excel 2013 بالعربي
Udemy
Microsoft Excel

Microsoft Excel 2013 بالعربي

أكسيل 2013 هو برنامج جداول بيانات ( تنتظم فيه البيانات المختلفه داخل أعمدة وصفوف ) تم تصميمه لتحليل الإعداد والبيانات وذلك ليحل محل الالة الحاسبة وصفحات الدفاتر المحاسبية المجدولة والممحاة والأقلام وكل ذلك بما يسهل التعامل مع الأعداد والمعادلات الحسابيه والنصوص بكل سهوله مع تمكين المستخدم من تقديم عمله بصورة منسقة ومتقنهأكسيل 2013 هو برنامج جداول بيانات ( تنتظم فيه البيانات المختلفه داخل أعمدة وصفوف ) تم تصميمه لتحليل الإعداد والبيانات وذلك ليحل محل الالة الحاسبة وصفحات الدفاتر المحاسبية المجدولة والممحاة والأقلام وكل ذلك بما يسهل التعامل مع الأعداد والمعادلات الحسابيه والنصوص بكل سهوله مع تمكين المستخدم من تقديم عمله بصورة منسقة ومتقنهأكسيل 2013 هو برنامج جداول بيانات ( تنتظم فيه البيانات المختلفه داخل أعمدة وصفوف ) تم تصميمه لتحليل الإعداد والبيانات وذلك ليحل محل الالة الحاسبة وصفحات الدفاتر المحاسبية المجدولة والممحاة والأقلام وكل ذلك بما يسهل التعامل مع الأعداد والمعادلات الحسابيه والنصوص بكل سهوله مع تمكين المستخدم من تقديم عمله بصورة منسقة ومتقنهأكسيل 2013 هو برنامج جداول بيانات ( تنتظم فيه البيانات المختلفه داخل أعمدة وصفوف ) تم تصميمه لتحليل الإعداد والبيانات وذلك ليحل محل الالة الحاسبة وصفحات الدفاتر المحاسبية المجدولة والممحاة والأقلام وكل ذلك بما يسهل التعامل مع الأعداد والمعادلات الحسابيه والنصوص بكل سهوله مع تمكين المستخدم من تقديم عمله بصورة منسقة ومتقنهأكسيل 2013 هو برنامج جداول بيانات ( تنتظم فيه البيانات المختلفه داخل أعمدة وصفوف ) تم تصميمه لتحليل الإعداد والبيانات وذلك ليحل محل الالة الحاسبة وصفحات الدفاتر المحاسبية المجدولة والممحاة والأقلام وكل ذلك بما يسهل التعامل مع الأعداد والمعادلات الحسابيه والنصوص بكل سهوله مع تمكين المستخدم من تقديم عمله بصورة منسقة ومتقنه

SAP Simple Logistics Online Training
Udemy
SAP S/4HANA

SAP Simple Logistics Online Training

SAP Simple Logistics Online Training :--------------------------------------------------------------SAP Business Suite 4 SAP HANA (or SAP S/4HANA) is a business suite that is built on SAP's proprietary operational database system and in-memory computing platform called SAP HANAThe S/4HANA product offering consists of two editions: SAP S/4HANA On-Premise and SAP S/4HANA Cloud.SAP S/4HANA On-Premise is similar in terms of coverage, functionality, industry-specific support, and localization to the current SAP Business Suite (in 39 languages, 64 country versions).The primary benefit of S/4 is that it runs in-memory, giving enterprises a centralised, streamlined business suite powered by close to real time data, which is especially useful for firms looking to take advantage of growing data streams - like online sales - or asset information coming from internet of things (IoT) sensors.

Excel 2016 PowerPivot, PowerQuery, PowerView & BI
Udemy
Microsoft Power BI

Excel 2016 PowerPivot, PowerQuery, PowerView & BI

This course takes up where the Optima Train Excel 2016 Pivot Tables Deep Dive course leaves off. It all revolves around the fairly new suite of Microsoft “Power” tools, often referred to as Power BI. The course has three primary themes. First, it teaches you a number of methods for importing data (from a database, text files, or other sources) into Excel. The primary emphasis is on Power Query. Second, it devotes considerable time to the Excel Data Model and Power Pivot for analyzing data with pivot tables. These take traditional pivot tables to a whole new level. Third, it shows how Power View and Power Map can be used to create insightful reports and maps with very little work. ***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED ***** ***** CLEAR AND CRISP VIDEO RESOLUTION ***** ***** COURSE UPDATED: February 2016 ***** “When I first looked up this site I was a bit skeptical, but I soon realized how amazing these courses are. They have helped me excel in all my business classes. The PowerPivot course now makes business analytics easy and at my fingertips." - Wilson Xu, STUDENT “The Optima Train two part series on Pivot Tables is pure gold! The material is so amazingly thorough and clear that anyone watching the videos and doing the exercises provided will without a doubt become a true expert at working with Pivot Tables and likely become a hero at work by applying and sharing this new-found knowledge. There is nothing like it on the market." - Phil, FORMER TREASURY OPERATIONS MANAGER - EXXONMOBIL 99.9% of Excel users do not use PowerPivot but those that do are in elite company. Power Pivot allows end users with no business intelligence or data analytics training to develop data models and calculations. The tide has shifted where the knowledge worker can perform analysis on millions of records without using specialized IT software or the h

PowerPoint & Excel Fusion (+250 PowerPoint Slides)
Udemy
PowerPoint

PowerPoint & Excel Fusion (+250 PowerPoint Slides)

13,000+ Students have enrolled in my 13 Courses!The 4.65 Rating from student reviews shows the value packed in this course!Practicality: This course has a 250-slide PowerPoint Template and is a step-by-step guide to using PowerPoint Excel together. PowerPoint and Excel are 2 very different pieces of software, however, this does not mean you cannot use PowerPoint and Excel together. In fact, Management Consultants especially have great knowledge of how to use the 2 softwares to create stunning presentations which are automated, data-driven, beautifully designed and impressive to read. Mastering both PowerPoint and Excel and knowing how to work with both at the same time can be invaluable and that's exactly what I strive to present to you in this course. What would it be like if each and every one of your PowerPoint presentations were stunning and impressed your attendees, co-workers, senior managers or investors without you saying a word yet? How about transforming raw data from Excel and turning it into beautiful Charts Graphs that impress and save you countless hours of work every month? The "Stunning Presentation" Guarantee Commit to take action and I GUARANTEE your Presentation skills will improve tremendously. If that's not the case, I will personally train you to achieve the results you desire. But more on the guarantee later… The Secret You might have wondered how Management Consultants and Investment Bankers always churn out PowerPoint presentations that look incredible. I mean, giv