UdemyMicrosoft Excel

Master Excel With Your Keyboard

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

Master Excel With Your Keyboard

عن هذا الكورس

If you're a beginner level (or intermediate level) Excel user, this course is for you. This course will introduce you to a range of skills and functions that are vital for any office job. Not only will this course make you more knowledgeable, it will make you a much faster Excel user too through a heavy focus on using the keyboard (instead of the mouse) wherever possible. By the end of this course, the key skills that you will have learned are as follows: Quickly format your Excel workbooks using a range of easy-to-remember keyboard shortcuts to improve the presentation of datasets.Use advanced conditional formatting to quickly highlight entries in your dataset which match a range of criteria. Use If functions and nested If functions to help you categorise your data.Use a range of lookup functions (and combine them with the Match function) in order to quickly pull up relevant data in your Excel worksheet.Use Pivot Tables to quickly extract insights from your dataset. Learn mathematical functions and also learn how to conduct linear regression in your Excel workbook to measure and quantify relationships between variables. Learn about financial functions in Excel which will then be applied to bond valuation problems.The many uses of the Sumproduct formula. You will be introduced to all these key skills and more through watching videos and you will have an opportunity to consolidate and apply these skills through a number of assignments (there are 7 main assignments) that are included in the course.

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

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

محتوى معتمد

مقدم من منصة Udemy

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

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

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

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

عرض كل الكورسات ←
Excel for Accountants: Volume 1
Udemy
Microsoft Excel

Excel for Accountants: Volume 1

Developed specifically for accountants, this course discusses the Excel features, functions, and techniques that are practical, relevant, and sure to save you time. My Excel University series of books are available online in paperback and digital Kindle versions. My online Excel University courses teach the content of the books in video format. Now, for Udemy, I've combined the book text and the lecture videos of Excel University Volume 1 and made them both available in this Excel for Accountants Volume 1 course. Course Format Each course section will begin with the lecture video. You can work through the sample Excel file to practice. Each section also provides the text of the book which reinforces and enhances the content presented in the lecture video. I then provide additional resources and related Excel University blog posts and articles. These elements provide an effective training experience. Instructor Author and award-winning instructor, Jeff Lenning, is a certified public account and Microsoft certified trainer, and has helped thousands of accountants use Excel more efficiently.

Touch Typing Mastery – Learn To Touch Type Successfully
Udemy
Typing

Touch Typing Mastery – Learn To Touch Type Successfully

Unlock the power of touch typing with 12 meticulously crafted lessons designed for all skill levels. This course guides you from mastering individual keys to typing full sentences, numbers, and uppercase letters with confidence. Each lesson is structured to enhance your speed and accuracy, enabling you to type fluidly without looking at the keyboard.Why choose this course?- Structured progression: Move from beginner to advanced through guided exercises tailored for steady improvement.- Practice notes: Reinforce learning with lesson-specific typing notes to solidify your skills.- On-screen keyboard aid: A visual keyboard display simplifies practice, keeping you focused.- Flexible learning: Type along in a notepad while following audio instructions for an interactive, real-time experience.Your path to success: Consistent practice is key. The course’s slow-paced, repetitive lessons build a strong foundation, allowing speed to develop naturally. Prioritize accuracy early on, and watch your proficiency soar.By the end, you’ll type emails, reports, or even novels with precision and speed, supercharging productivity. Ideal for professionals, students, or writers seeking efficiency in 2025, this course equips you with skills to excel in any typing-intensive task.Enroll now to transform your typing abilities and stay ahead in a fast-paced digital world. Boost your career today.

Excel Complete Course أفضل دورة اكسل من الصفر الى الاحتراف
Udemy
Microsoft Excel

Excel Complete Course أفضل دورة اكسل من الصفر الى الاحتراف

دورة الاكسل من الصفر الى الاحتراف تغطي جميع المستوياتExcel for Beginners المستوى الأول للمبتدئين في برنامج اكسلExcel Intermediate المستوى الثاني الاكثر تطورا في دورة اكسلExcel Advanced المستوى الثالث و هي الدورة المتقدمة في اكسلجميغ المستويات في دورة واحدة. عند مشاركتك في الدورة ستكون لك امتيازات متعددة منها امكانية طرح الأسئلة عن طريق الموقع و ستجيب على جميعهانبذة عنيأنا مالك العروسي, مهندس و لدي أكثر من 10 سنوات خبرة في برنامج الاكسل و اليوم أقدم لكم هذه الخبرة بطريقة مبسطة عن الدورةدورة الاكسل هذه هي طريقك لتحترف استعمال الاكسل في العمل, الدراسة أو في الاستخدام الشخصي. حيث نبدأ بالاساسيات وصولا الى العمليات المعقدةفي نهاية الدورة ستلاحظ الفرق و طريقة الشرح ستكون بأمثلة بسيطة تسهل عليك الفهم و الاستيعابماذا سنتعلم؟Microsoft Excel تعلم اساسيات برنامج مايكروسوفت اكسلتنسيق كل ما يتعلق ب الاكسلالعمل على البيانات الكبيرة في الاكسلاحتراف الدوال بجميع أنواعهاالتحقق من صحة البياناتPivot Table اتقان الجداول المحورية اتقان الرسوم البيانية و المخططاتWhat-If Analysisو المزيد حيث نوفر لكم أكثر من 75 درسمنافع الدورةExcel أتقان برنامج الاكسلانشاء جداول اكسل محترفةربح الوقت في العمل او الدراسةتفادي الأخطاء عن طريق الاتخدام السليم لاكسللمن هذه الدورة؟beginners to advanced microsoft excelالمبتدئين في برنامج المايكروسوفت اكسلكل من يريد ان يخترف في برنامج الاكسلأنا متأكد أن الدورة ستنال اعجابكم و تستفيدون منها كثيرا. تقييمكم و تعليقاتكم تمكننا من تطوير المحتوى -----------------------------------دورة اكسل من البداي

Ilmu Excel Dari Pak Win
Udemy
Microsoft Excel

Ilmu Excel Dari Pak Win

MENGAPA PENTING UNTUK MENGUASAI ILMU EXCEL?Tidak bisa kita pungkiri bahwa Microsoft Excel adalah kemampuan yang sangat penting untuk dikuasai baik bagi seseorang yang sedang berkarir ataupun berbisnis. Hampir semua profesi menggunakan Excel, terutama bagi orang-orang yang bekerja di bidang Finance, Marketing, Operasional dan juga bidang2 lain terkait dengan angka dan data. Kemampuan Excel memungkinkan seseorang untuk mengolah dan menganalisa banyaknya data dengan mudah. APA SAJA YANG AKAN DIPELAJARI?Cara untuk menggunakan excel dari dasar sampai level profesional: dari formula dasar, fungsi2 utama dalam mengolah data, menginput bentuk ataupun foto, sampai dengan mengubah format agar terlihat profesional sampai dengan pembuatan Chart. Semua yang diajarkan disini bisa dipraktekkan secara langsung.PROFIL PENGAJARTjokro Wimantara, CFA (Biasa dikenal dengan 'Pak Win')Pak Win merupakan lulusan dari Tsinghua MIT Global MBA Program dengan penghargaan 'Distinguished International Student Award' dan juga 'Outstanding Master's Dissertation Award'. Ia pernah bekerja di beberapa perusahaan besar (seperti Infineon, Siemens, OCBC Bank) sebelum terjun ke dalam dunia bisnis. Ia merupakan salah satu pendiri dari Karta, startup teknologi di bidang periklanan yang terpilih dalam Forbes 30under30 2018. Ia merupakan lulusan Swiss German University dengan predikat Cumlaude. Ia memiliki pengalaman Go Public (IPO) dimana ia merupakan salah satu partner dari PT Jasnita Telekomindo Tbk. Di luar dari kegiatan bisnisnya, ia juga berinvestasi di beberapa bisnis dalam industri lain.Di pertengahan tahun 2020, Pak Win mulai rutin menuangkan pikirannya mengenai bisnis di akun sosial media @asahpolapikir. Akun sosial media @asahpolapikir menarik sampai hampir 1 juta follower dalam waktu k

PowerPoint Jeopardy and Family Feud from Scratch
Udemy
PowerPoint

PowerPoint Jeopardy and Family Feud from Scratch

Welcome! Be prepared to WOW your audiences with unique and awesome-looking games using PowerPoint. Your students/audiences will literally ask you what program is that? while you're playing. They won't BELIEVE that such awesome-looking and FUNCTIONAL games can be made and executed using PowerPoint. Playing games is a great way to LEARN and RETAIN information. The retention rate is RIDICULOUSLY high and the fun/rapport generated is immeasurable. You'll find a few templates online, but: They are hideously ugly, not professional-looking, and an EMBARRASSMENT to your skills expertise. Let's make great looking games so your audience will know that you respect them enough to not use pre-built templates that look like garbage. They're made by someone else, so...what you see is what you get. And don't bother trying to make changes; you'll just get FRUSTRATED and DISCOURAGED. You don't learn anything using someone else's stuff. Learn to build games from scratch for complete control over what goes in, and most importantly, what comes out. You will create two very popular games that you can use for any occasion: Jeopardy and Family Feud. Your audience will not have a learning curve on how to play...everyone can just jump right in! You will learn a lot while building your own game! You'll use many of PowerPoint's features to create a functional, highly-responsive game such as: Advanced animation techniques Triggers Shape building (2013) or Shape manipulation (2010, 2007) The PowerPoint games you'll create can be used for COUNTLE

Master Your iPhone and Be 10X More Productive
Udemy
Personal Productivity

Master Your iPhone and Be 10X More Productive

Did you know that as an iPhone user, you're likely spending over $1,000 a year in carrier fees, apps, and accessories? What's worse is that most people are barely scratching the surface in terms of using their iPhone's capabilities. I don't know about you, but if I'm spending $1,000 a year on something, I would want to get my money's worth. That's where this course comes in. I've designed this video series to help you master your iPhone and dramatically increase your productivity. Imagine being able to cut down the time it takes to do 90% of your most common tasks. Imagine knowing tricks that the vast majority of iPhone users don't know. Imagine becoming a real-life iPhone ninja. I've created over 2 hours of step-by-step video content to take you to that level. The course is broken up into 8 sections covering basic tips, built-in apps, Siri tricks, productivity apps, apps for freelancers and salespeople, and accessories for maximizing productivity. How did I come up with the price of $47? After the course launched, I got a couple of emails asking me to justify the price. For courses I create, I like to give at least 10 times the value of what you paid. So the math goes like this: if this course saves you 1 hour of time a week (conservative estimate), that equals 52 hours a year you've gained. If you make at least $20 an hour, that additional free time is worth at least (52 hours X $20) $1,040. $1040 divided by 10= $104. I just made it $47 to keep it under $50 and give you 20x the value :-) And who am I? I'm the Editor in Chief of iPhone Life magazine, one of the largest print publications in the world dedicated solely to iPhone and iPad users. You can find iPhone Life magazine in Barnes Noble, Walmart, Hudson New