UdemyExcel Dashboard

Excel Interactive Dashboard

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

Excel Interactive Dashboard

عن هذا الكورس

In this course, you will learn how to use charts pivot tables to create amazing dynamic dashboards. But to do that you must first learn the basic charts and how to insert and edit pivot tables, slicers and pivot charts which will be taught in this course as well. During that journey, you will learn additional uncommon charts that requires an out of the box thinking as they are not an excel standard charts, such as the dynamic doughnut chart, rounded edges progress donut chart, dynamic line charts, overlay image charts and much more.This course only requires you to know the basic principles of excel as the course will guide you to do dynamic dashboards from scratch. Therefore, this course is applicable for all levels, beginners, intermediate and advanced levels in Excel.This is your chance to enhance you sheets, it is time to stop using standard direct methods, and level up your game to use dynamic dashboards and uncommon Excel charts. I will be using Excel 2019 but most of the features are available in the previous Excel versions.With that being said, I can’t wait to see you inside. If you decided to join me and other thousands students all over the world, I strongly advice you to download the resources and work on them while learning. But whatever you decide, stay productive and happy learning!!

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

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

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق

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

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

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

عرض كل الكورسات ←
SAP HCM Enduser Course
Udemy
SAP HCM

SAP HCM Enduser Course

SAP HCM Enduser course covers processes of the SAP HCM modules like organization management, personnel administration. You will also learn how to navigate within the SAP HCM system and be an expert in executing standard reports, creating variants and run reports in background. SAP HCM made easy and helping our clients through learning and earning This course is for HR Generalist, Specialist who will be managing data in the SAP HCM system Step by step instruction on each process After you complete this course, you will understand how to navigate in SAP, maintain employee data, maintain organization data, execute standard reports and learn transactions to execute certain processes in the SAP HCM system. Take the first step to knowledge with us All medium to large size companies have an ERP system to maintain their employee master data. SAP is the # 1 ERP system in the world. Learn the processes of the SAP HCM system and impress your employer by showing off your SAP HCM skills. We define SAP in a clear and easy way to learn at your own pace. Perfect Resources has 20+ years of HR experience and has been part of SAP HCM implementations. This is a self-paced learning with captions and is voice enabled. You will learn all the processes built in short videos that we help our clients every day. SAP HCM End User training is an excellent training for those looking to work in the corporate world as a HR Generalist or HR Analyst entering and maintaining data in the SAP HCM system. Perfect Resources exceptional team of expertise, experience and education will help clients optimize and MAXIMUM SAP HCM system technology and benefits. Perfect Resources specializes in S

Stocks & Crypto: In Google Spreadsheet only with formulas
Udemy
Google Sheets

Stocks & Crypto: In Google Spreadsheet only with formulas

That's the only asset allocation you'll need. This course will teach you everything you need to know to stay up to date with your asset management of stocks, cryptos, and precious metals. With this overview, you can keep track of your finances anytime and from anywhere.If you have completed this course, then:you can display your current deposit valueyou can you create a watchlist with purchase decisionyou can you show a historical price history with a trend lineyou can you create a currency converter with showing you the current currency rateyou can you evaluate dividends or income distributions from your bank statementyou can import crypto assets as well as altcoins from various external sourcesWhat we go through in the course:Get to know GOOGLEFINANCE formulaQuery stocks and cryptos on various exchanges with GOOGLEFINANCE.Query historical data.Use SUMIF and SUMIFS functions to create automated evaluationsQuery external data with the IMPORTXML functionPrepare imported data with the LEFT and RIGHT function.Convert imported data to a number with VALUE functionCatch errors of functions and external data with IF ERRORUse INDEX function for trimming table valuesQuerverweise zu anderen Tabellenblätter vornehmenMake cross-references to other spreadsheetsWhy Google Sheets?Because you have access to your financial overview anytime and anywhere there is internetYou can access Google Drive on nearly every deviceGoogle Spreadsheet as well as all functions and used interfaces are free of chargeThe interfac

Mastering Markdown: From Basics to Beautiful Documents
Udemy
Markdown

Mastering Markdown: From Basics to Beautiful Documents

Mastering Markdown is a comprehensive course designed to teach learners how to create professional-looking documents using the Markdown syntax. The course is suitable for beginners with no prior experience using Markdown or other markup languages, as well as professionals and students who want to improve their document formatting skills.The course begins with an introduction to Markdown, including its history and basic syntax. Learners will then learn how to format headings, paragraphs, and lists using Markdown, as well as more advanced formatting options such as tables, code blocks, and footnotes.Throughout the course, learners will have access to hands-on practice exercises and real-world examples to help them apply Markdown in their own projects. The course will also cover best practices for creating visually appealing documents using images, links, and other advanced formatting techniques.In addition to learning how to use Markdown, learners will also gain valuable skills in document organization, readability, and collaboration. The course will provide learners with the tools they need to create documents that are both professional-looking and easy to read.By the end of the course, learners will have a solid understanding of Markdown and the confidence to use it in their own projects. They will be able to create documents that are visually appealing, easy to read, and stand out from the crowd.Whether you're a writer, editor, content creator, student, or professional, this course will provide you with the skills you need to master Markdown and take your document formatting skills to the next level.

Practical SharePoint 2010 Deep Dive into the Essentials
Udemy
Microsoft SharePoint

Practical SharePoint 2010 Deep Dive into the Essentials

This course is a deep dive into everything a brand-new user to Microsoft SharePoint 2010 would need to know to get up and running quickly. It introduces the concepts and practical features that someone new to SharePoint needs to know. It shows use scenarios of a typical knowledge worker and does not require or cover administration or programming skills in SharePoint. In a quick and lively manner this will cover the main uses of SharePoint for a new user. This course is also a good review of the end user perspective for SharePoint administrators.The course begins with a definition of SharePoint and some basic navigation techniques. It then builds on the concept of a Document Library and its many uses. Document storage and use is covered including checking out a document and versioning. The concept of document Sets is discussed. Basics of Alerts are covered and how to use a list including importing and exporting Lists to Excel. Tasks and custom views are demonstrated with a special project view of a timeline. The concept of Workflow is introduced and a basic example shown with a document being routed through multiple users. The powerful Calendar function is addressed and demonstrated. How to share contact lists and collect information in Surveys is shown. The social aspects of SharePoint are covered including My Site, Wikis, Discussions and Blogging. Finally the basics of creating a new site and editing a page are demonstrated. If you are new to SharePoint this is an excellent introduction that does not get too technical or deep in the weeds. Throughout the course the videos are quick, lively and clearly explained. If you want a good grasp on what SharePoint is and what it can do for you this course will show you in just under 2.5 hours.***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED ********** COURSE UPDATED: February 2016 ***** If you are sending e-mails with attachments as a means of collaborating

Power Automate for Beginners: An Introductory Course
Udemy
Microsoft Power Automate

Power Automate for Beginners: An Introductory Course

Businesses have embraced automation because it improves work efficiency, maximizing both work speed and reliability.Power Automate is a simple yet powerful application from Microsoft for task and business process automation with no coding required. It is an exhaustive tool that can be connected to almost any application and used to streamline repetitive tasks. It lets you perform complex workflows and even allows you to share your workflows with other users.This beginner-level course is suitable for those brand-new to Power Automate for Microsoft 365 and intermediate users looking to expand their skills. The online version of Power Automate is used throughout this course, which covers the basics to get you started with the application, plus some intermediate features. Please note, this course does not cover advanced features such as UI and desktop flows.This course covers:How to get started with the Power Automate interfaceThe definition of a flow and types of flowCreating a flow from a templateHow to create an automated flowRunning, editing, and tracking a flowSharing flows with othersCreating a flow from scratchHow to create triggers and actionsUsing dynamic contentHow to create expressionsHow to create conditionsCreating scheduled flowsWhat is an approval flow?Input types and how to apply themIntro to built-in functionsWorking with loopsDo-until function overviewHow to use switch statementsThis course includes:2.5 hours of video tutorials36 individual video lecturesCertificate of completion<

Primavera P6 Professional Step-by-Step from Novice to Expert
Udemy
Oracle Primavera

Primavera P6 Professional Step-by-Step from Novice to Expert

Need to learn Oracle Primavera P6 fast?Learn the industry standard software you need to know to advance your career. Go from beginner to expert with easy to follow, step-by-step screencast videos.This course will show you step-by-step the most useful, important and powerful features available in Primavera P6 that you need to know in order to progress from beginner to an advanced level of proficiency with the software. In order for you to learn the most material in the least amount of time, the software is taught using screencast videos where every step of the task is explained in detail. Make a small investment in yourself and your career that will help you get a leg up on the competition!A practical course for learning project management in P6 quickly and easilyThis course is not meant to be an academic lecture series explaining theory, nor is it a boring slideshow that tells you how to use the software instead of showing you. This course is designed to equip you with the skills you need to unlock the most important features of Primavera P6 quickly. You don’t need to spend months staring a textbook when you can watch and simply follow along. When you reach the end of the course you will have a deeper understanding of how to use Primavera P6.Learn the software demanded by industry professionals today!Grab this course today and learn:· Introduction to Primavera P6· Logging in· General Interface Introduction· Data Configuration· Organizational Breakdown Structure· Enterprise Project Structure· Project Codes and Values· Global and Project Calendars· Definition of Project· Establishing Work Breakdown Structure· Assignment of OBS Elements to WBS· Defining Budget at Project Level· Defining Budget at WBS Level· WBS and Work Packages Tabular View· Defining Activity Codes and values· WBS Chart View a