4209 Courses

Data Analysis In Excel is suitable for anyone aspiring to or already working in this field or simply want to learn deeper into data analysis. You will be able to add this qualification to your CV by downloading your certificate instantly without any cost. To make this course more accessible for you, we have designed it for both part-time and full-time students. This course is packed into the bite-size module for your convenience. You can study at your own pace or become accredited within hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. This Data Analysis In Excel aims to introduce Data Analysis in Excel 2016. You'll learn the best way to enter and organize data, sort and map data, perform calculations with simple functions, format the appearance of your data and cells, and build charts and PivotTables for data analysis. You will know how to validate data, search and remove invalid data. The course covers Lookup information using VLOOKUP, and INDEX-MATCH, data forecasting and cleansing, providing external and 3D references and inserting sparklings, so that you have a great foundation in the world's most popular spreadsheet programme. Finally, you will learn different features to visualise or analyse your data in the most convenient way, which allows you to take the right business decisions for your company Who is this Course for? Data Analysis In Excel is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Data Analysis In Excel is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Learn to build an HR Dashboard using Excel with our comprehensive course. From data introduction to designing index and tabs, analyze employee data effectively using pivot tables and charts. Ideal for HR professionals and analysts looking to create insightful dashboards for HR metrics and analysis.

Almost every business, organization, companies, and individual owner need Microsoft Excel to record finances, hours, data, and to perform many other activities at once. It is widely used software that assists to analyze data, send invoices, share works with different people at a time, and function many more activities. Are you looking fresher? Don't you have any training and knowledge about this software? Are you interested to improve your skills to pursue the best position in any organization? if so, the ultimate Microsoft Excel for Beginners course assists you to learn further all you need in your quest. As the course is online based, you can complete it from any part of the world at any time at your own pace. The course is accessible through an internet connection from any Computer, Laptop, Mac, smartphones, or any electronic devices that support MS Excel software. The course contents require a few minutes for each. So, it is convenient for you to start or stop at any time as you want. It entertains you, though you have less than 20 minutes to go through this course. Who is this Course for? Microsoft Excel for Beginners is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of the English language, numeracy and ICT are required to attend this course CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99 Course Curriculum Excel Beginners Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Excel for Beginners 00:20:00 Final Exam Final Exam- Microsoft Excel for Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Learn essential techniques for successful trading & investing through Technical Analysis Masterclass. Explore key indicators, chart patterns, and strategies to decipher market trends effectively.

MojiTax is hosting an invaluable event for ADIT students aimed at unlocking the secrets to exam success. This engaging session is designed to provide insights into MojiTax's effective learning methodologies that have contributed to its impressive success rates. Attendees will benefit from expert discussions on Knowledge-Based Learning, and Exam Writing Techniques. Additionally, we will share motivational ADIT journies, highlighting the impactful benefits of MojiTax. This event represents a unique opportunity for ADIT candidates to enhance their exam preparation strategies, connect with a supportive community, and learn from those who have excelled. Video time: X hours Exams: X Author: MojiTax Level: Not Applicable Study time: 1 hour 01 Live session Open Event Link (2pm - 3pm London Time)

*** A Better Pathway for Rapid Growth! Limited Time Opportunity; Hurry Up! *** Ignite your dynamic career and strengthen your deep insight knowledge by signing up for Strategic Account Management. This course is the ideal approach for you to obtain a thorough understanding and knowledge of the subject. We are concerned about the progression of your career. Therefore, after conducting extensive studies and consulting with experienced personnel, we formulated this outstanding course to improve your pertinent skills. In this easy-to-digest Strategic Account Management course, you will get exclusive training, which will enable you to stand out in this competitive market. However, the Strategic Account Management course covers all of the recent materials in order to keep you up to date with the job market and make you a good fit for your career. This top-notch course curriculum comprises basic to advanced levels of modules that will increase your skillsets. After completing this Programme, you will attain the productivity to succeed in your organisation. So, if you are eager to see yourself in a gratifying Strategic Account Management career, then enrol in our course today! What will make you stand out? On completion of this Strategic Account Management online course, you will gain: CPD Certified Course After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of Strategic Account Management learning materials. The course online test with immediate results Enroling in the Course has no additional costs. You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. The substantial Strategic Account Management is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enroling in this course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Strategic Account Management and explore the key topics such as: Strategic Account Management Module 01: Introduction to Key Account Management Module 02: Purpose of Key Account Management Module 03: Understanding Key Accounts Module 04: Elements of Key Account Management Module 05: What Makes a Good Key Account Manager Module 06: Building and Delivering Value to Key Accounts Module 07: Key Account Planning Module 08: Business Customer Marketing and Development Module 09: Developing Key Relationships Module 10: The Importance of Record Keeping for Key Account Management Module 11: Internal KAM Aspects Module 12: The Value Proposition Therefore, reinforce your knowledge and furnish your skills by enroling in our Strategic Account Management course. Take one step closer to achieving your goal. Show off your new skills with a certificate of completion When you have finished all of the Strategic Account Management course lectures, a digital certificate will be available for download. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Strategic Account Management Course the Right Option for You? This Strategic Account Management course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this course. This Strategic Account Management course is open to everybody. You can access the course materials from any location in the world and there are no requirements for enrolment. You should enrol in this Strategic Account Management course if you: Aspire to understand Strategic Account Management better. Already working on it and eager to learn more. Is a student pursuing a relevant field of study? Trying to get a job in Strategic Account Management-related fields. Requirements Without any formal requirements, you can delightfully enrol in this Strategic Account Management course. Just get a device with internet connectivity and you are ready to start your learning journey. Thus, complete this Strategic Account Management course at your own pace. Career path The aim of this exclusive Strategic Account Management course is to help you toward your dream career. So, complete this Strategic Account Management course and enhance your skills to explore opportunities in relevant areas.

Are you looking to enhance your Compliance Management skills? If yes, then you have come to the right place. Our comprehensive course on Compliance Management will assist you in producing the best possible outcome by mastering the Compliance Management skills. The Compliance Management is for those who want to be successful. In the Compliance Management, you will learn the essential knowledge needed to become well versed in Compliance Management. Our Compliance Management starts with the basics of Compliance Management and gradually progresses towards advanced topics. Therefore, each lesson of this Compliance Management is intuitive and easy to understand. Curriculum Breakdown of the Compliance Management Module 01: Introduction to Compliance Module 02: Five basic elements of compliance Module 03: Compliance Management System (CMS) Why would you choose the Compliance Management from Compliance Central: Lifetime access to Compliance Management materials Full tutor support is available from Monday to Friday with the Compliance Management Learn Compliance Management skills at your own pace from the comfort of your home Gain a complete understanding of Compliance Management Accessible, informative Compliance Management learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Compliance Management bundle Study Compliance Management in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Compliance Management course CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Compliance Management helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career. Requirements To enrol in this Compliance Management, all you need is a basic understanding of the English Language and an internet connection. Career path The Compliance Management will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Compliance Management. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Online courses for various languages and different levels from Beginners to Advanced

Fakta Menarik tentang Fenomena Poker Mania yang Jarang Diketahui Dunia poker dipenuhi dengan fakta menarik dan fenomena yang jarang diketahui yang sering kali luput dari perhatian para pemain biasa. Dari asal muasal permainan ini hingga popularitasnya yang meningkat, ada banyak hal yang bisa ditemukan tentang dunia poker mania yang menarik. Pada artikel kali ini kita akan mengupas beberapa fakta menarik tentang fenomena global yang jarang diketahui ini. Jadi bergabunglah dengan dewapoker saat kami menyelidiki misteri poker mania dan mengungkap kebenaran tersembunyi di balik permainan ini. Poker Mania: Fenomena yang Mengagumkan Poker mania telah melanda dunia, memikat orang-orang dari semua lapisan masyarakat. Fenomena global ini telah mendapatkan basis penggemar yang sangat besar dan bahkan telah menjadi subyek banyak buku, film, dan acara televisi. Daya tarik poker tidak dapat disangkal, tapi apa sebenarnya yang membuatnya begitu memesona? Salah satu aspek paling menarik dari poker mania adalah kemampuannya untuk melampaui batas dan menyatukan orang. Baik Anda bermain di kasino, platform online, atau bahkan berpartisipasi dalam pertandingan poker 88 kandang persahabatan, pengalaman bersama dalam menyusun strategi, menggertak, dan pada akhirnya menang atau kalah menciptakan ikatan unik di antara para pemain. Selain itu, aspek psikologis poker sangat menarik dan menawan. Permainan ini mengharuskan pemain untuk membaca lawannya, mengukur reaksi mereka, dan membuat keputusan yang diperhitungkan berdasarkan informasi yang tidak lengkap. Perang psikologis ini menambah dimensi yang menggembirakan dalam permainan ini dan menarik para pencari sensasi dan pemikir strategis. Di bagian selanjutnya, kita akan menyelami lebih dalam dampak budaya poker mania dan mengeksplorasi bagaimana hal itu memengaruhi berbagai aspek masyarakat. Nantikan wawasan lebih menarik mengenai fenomena menakjubkan ini! Pantau terus! Mengenal Fakta Menarik tentang Poker Mania Ketika poker mania terus memikat jutaan penggemar di seluruh dunia, inilah saatnya untuk menyelidiki beberapa fakta yang kurang diketahui seputar permainan yang mendebarkan ini. Tahukah Anda bahwa poker berasal dari awal abad ke-19 di Amerika Serikat? Awalnya dimainkan dengan setumpuk hanya 20 kartu, permainan ini telah berkembang seiring waktu menjadi versi populer yang kita kenal sekarang. Fakta menarik lainnya adalah bahwa poker memiliki terminologi uniknya sendiri. Dari “full house” dan “straight flush” yang terkenal hingga “donkey” dan “bad beat” yang kurang terkenal, bahasa sehari-hari poker menambah lapisan kegembiraan dan intrik ekstra bagi para pemain yang rajin. Selain itu, poker memiliki dampak besar pada budaya pop. Banyak aktor terkenal, atlet, dan bahkan politisi diketahui menikmati permainan domino bet selama waktu senggang mereka. Hal ini tidak hanya mempopulerkan permainan ini tetapi juga membantu menghilangkan beberapa stereotip yang mengelilinginya. Di bagian selanjutnya, kita akan menjelajahi berbagai jenis permainan poker dan perbedaannya satu sama lain. Bersiaplah untuk memperluas pengetahuan Anda dan tingkatkan apresiasi Anda terhadap poker mania! Kini setelah kita mengungkap beberapa fakta menarik tentang poker mania yang sering luput dari perhatian, mari kita telusuri langkah-langkah yang dapat Anda ambil untuk sukses di dunia poker yang mengasyikkan. Baik Anda seorang pemula yang ingin menyempurnakan keterampilan Anda atau pemain berpengalaman yang ingin mencapai level baru, mengikuti langkah-langkah profesional ini akan membantu Anda menavigasi industri yang kompetitif. Pertama dan terpenting, penting untuk menguasai dasar-dasar poker. Pahami aturan, peringkat tangan, dan strategi yang terlibat dalam berbagai variasi permainan dewa poker Manfaatkan tutorial online, buku, dan kursus poker terkemuka untuk meningkatkan pengetahuan dan teknik Anda. Selanjutnya, bangun fondasi yang kokoh dengan berlatih secara rutin. Luangkan waktu khusus untuk mengasah keterampilan Anda, berpartisipasi dalam turnamen online, dan terlibat dalam permainan persahabatan dengan sesama penggemar. Latihan yang konsisten ini akan membantu Anda memoles kemampuan pengambilan keputusan, beradaptasi dengan berbagai skenario, dan mengembangkan intuisi Anda sebagai pemain poker yang sukses. Selain latihan, pelajari gameplay pemain poker profesional. Tonton streaming langsung, sorotan, dan pertandingan klasik untuk mendapatkan wawasan tentang strategi dan pola pikir mereka. Analisis gerakan mereka, pola taruhan, dan proses pengambilan keputusan. Mengamati yang terbaik dalam permainan akan memberikan pelajaran dan inspirasi yang sangat berharga bagi perkembangan Anda sendiri. Selain mengasah keterampilan teknis Anda, tingkatkan permainan mental Anda. Poker membutuhkan fokus, disiplin, dan kontrol emosional. Belajarlah untuk mengelola emosi Anda, menghindari kemiringan, dan membuat keputusan yang rasional bahkan dalam situasi tekanan tinggi. Mengembangkan pola pikir poker yang kuat akan memungkinkan Anda untuk tetap tajam dan tangguh sepanjang perjalanan poker Anda. Aspek penting lainnya untuk menjadi pemain poker yang sukses adalah memahami pentingnya manajemen bankroll. Sisihkan uang khusus untuk bermain poker dan perhatikan batasan finansial Anda. Mengelola uang Anda dengan benar akan membantu Anda menghindari risiko yang tidak perlu, meminimalkan kerugian, dan memastikan umur panjang dalam permainan. Terakhir, selalu berusaha untuk terus belajar dan melakukan perbaikan. Tetap update dengan strategi poker terbaru, tren, dan perkembangan industri. Bergabunglah dengan komunitas poker, diskusi forum, dan hadiri acara langsung untuk membangun jaringan dengan sesama profesional dan mendapatkan wawasan berharga. Terima masukan, analisis gameplay Anda sendiri, dan sesuaikan strategi Anda. Dengan mengikuti langkah-langkah profesional ini, Anda akan segera mencapai kesuksesan dalam industri poker kompetitif. Tetap berdedikasi, belajar, berlatih, dan mempertajam keterampilan Anda. Ingat, menjadi pemain poker profesional membutuhkan waktu dan usaha, namun dengan tekad dan semangat terhadap permainan ini, Anda dapat mengukir jalan Anda sendiri menuju kehebatan! Di bagian selanjutnya, kita akan menjelaskan sejarah poker yang menawan dan bagaimana perkembangannya seiring berjalannya waktu. Bersiaplah untuk terkagum-kagum dengan asal usul dan transformasi game tercinta ini! Dalam blog ini, kita telah membahas berbagai fakta menarik tentang fenomena poker mania yang jarang diketahui. Mulai dari sejarah poker, popularitasnya di kalangan pemain muda, hingga tantangan dalam membangun dan menjaga komunitas poker yang sukses. Poker memang telah menjadi generasi baru dalam industri perjudian. Permainan ini telah melampaui batas-batas tradisional dan menjadi fenomena global yang menarik minat jutaan pemain di seluruh dunia. Dengan perkembangan teknologi, permainan poker juga telah beradaptasi dengan baik di era digital, dengan banyak platform online yang menawarkan pengalaman bermain poker yang interaktif dan mengasyikkan. Namun, kesuksesan dalam membangun dan menjaga komunitas poker yang sukses tidaklah mudah. Ada berbagai tantangan yang harus dihadapi, mulai dari menarik dan mempertahankan anggota komunitas hingga menjaga integritas permainan. Berdasarkan artikel ini, kita telah menemukan strategi untuk mengatasi tantangan ini. Dengan menciptakan lingkungan yang inklusif dan menyenangkan, menerapkan peraturan yang ketat, mengorganisir turnamen dengan efisien, dan terus berkomunikasi dengan anggota komunitas, kita dapat membangun dan menjaga komunitas poker yang aktif dan berkelanjutan. Semoga artikel ini telah memberikan wawasan dan pengetahuan baru tentang fenomena poker mania yang jarang diketahui. Teruslah mengikuti artikel kami untuk informasi menarik lainnya tentang poker dan dunia perjudian.

Overview This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds. Requirements Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 34 sections • 135 lectures • 08:20:00 total length •Introduction: 00:03:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:01:00 •FAQ's: 00:01:00 •Excel Overview: 00:05:00 •Start Excel Spreadsheet: 00:04:00 •Enter Text and Numbers: 00:07:00 •Relative References: 00:04:00 •Working with ranges: 00:07:00 •Save and Save as Actions: 00:08:00 •File Extensions, Share, Export, and Publish files: 00:06:00 •Adding Rows and Columns: 00:03:00 •Modifying Rows and Column lengths: 00:05:00 •Copy, Cut, and Paste: 00:07:00 •Copying Formulas: 00:03:00 •Page setup options: 00:06:00 •Fit to print on One Page: 00:03:00 •Print Workbooks: 00:03:00 •Sorting Data Ascending Order: 00:04:00 •Sorting Data Descending Order: 00:02:00 •Filter Data: 00:04:00 •Creating Basic Formulas: 00:06:00 •Datetime Formulas: 00:06:00 •Mathematical formulas phase1: 00:20:00 •Mathematical formulas phase2: 00:12:00 •VLOOKUP formula: 00:12:00 •HLOOKUP formula: 00:04:00 •XLOOKUP: 00:08:00 •Handling #NA and Approximates match in XLOOKUP: 00:11:00 •Split Text into columns: 00:07:00 •Flash Fill: 00:07:00 •Data Validation: 00:07:00 •Remove Duplicates: 00:08:00 •Import Data from Text files: 00:06:00 •Import Data from .CSV files: 00:03:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Numbers: 00:05:00 •Formatting Date: 00:03:00 •Formatting Tables: 00:05:00 •Pivot Tables: 00:07:00 •Pivot Charts: 00:02:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Creating Charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line Charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Overview: 00:04:00 •Start PowerPoint Presentation: 00:05:00 •Screen setting and Views: 00:05:00 •Presentation Tips and Guidelines: 00:06:00 •Creating a New Presentation: 00:04:00 •Working with Slides: 00:04:00 •Save a Presentation: 00:04:00 •Print Slides: 00:03:00 •Formatting Text: 00:05:00 •Slide Text Alignments: 00:03:00 •Multi-Column Text Alignments: 00:02:00 •Adding Bullets and Numbered List Items: 00:03:00 •Insert Shapes: 00:03:00 •Insert Icons: 00:03:00 •Insert Graphics: 00:04:00 •Add 3D Models: 00:03:00 •Insert Pictures: 00:03:00 •Picture Options: 00:04:00 •Picture Cropping: 00:03:00 •Applying Built-in Picture Styles: 00:04:00 •Add SmartArt Graphic: 00:03:00 •Modifying SmartArt: 00:03:00 •Creating a Target Chart using SmartArt: 00:03:00 •Create a Table on Slide: 00:04:00 •Formatting Tables: 00:02:00 •Inserting Tables: 00:02:00 •Table Layouts: 00:01:00 •Add a Chart: 00:02:00 •Formatting Charts: 00:02:00 •Insert Chart from Microsoft Excel: 00:03:00 •Adding Video to a Presentation: 00:03:00 •Adding Audio to a Presentation: 00:02:00 •Screen Recording and Adding: 00:02:00 •Applying Transitions to Presentation: 00:04:00 •Object Animation: 00:03:00 •Effect Options: 00:02:00 •Advanced Animation: 00:02:00 •Triggers to control animation: 00:02:00 •Onscreen Presentation: 00:02:00 •Hiding Slides: 00:02:00 •Changing Order of Slides: 00:02:00 •Copying Slides: 00:02:00 •Overview of MS Word: 00:04:00 •Start MS Word 2021: 00:05:00 •Create a new blank document: 00:04:00 •Creating a paragraph text: 00:05:00 •Non-printing characters: 00:03:00 •Save a document: 00:03:00 •Open a document: 00:01:00 •Find and replace: 00:04:00 •AutoCorrect options: 00:03:00 •Formatting text: 00:04:00 •Copy cut and paste: 00:04:00 •Character formatting: 00:02:00 •Format painter: 00:04:00 •Work with numbers: 00:02:00 •Add bullets: 00:03:00 •Outline creation: 00:04:00 •Creating a table: 00:03:00 •Adding rows and columns to a table: 00:02:00 •Formatting table data: 00:02:00 •Borders and shading: 00:02:00 •Sorting in a table: 00:04:00 •Draw a table: 00:04:00 •Convert text to table: 00:03:00 •Convert table to text: 00:02:00 •Insert a spreadsheet: 00:02:00 •Quick tables - readily available formats: 00:02:00 •Working with styles: 00:02:00 •Creating styles: 00:02:00 •Clear formatting: 00:01:00 •Margins: 00:02:00 •Orientation: 00:01:00 •Page size setting: 00:01:00 •Adding columns: 00:03:00 •Page break - section break: 00:02:00 •Adding watermark: 00:03:00 •Headers and footers: 00:03:00 •Create envelops: 00:02:00 •Creating labels: 00:02:00 •Creating a mail merge document: 00:03:00 •Thesaurus and spell check: 00:01:00 •Word count: 00:01:00 •Speech - read aloud: 00:01:00 •Language - translate: 00:01:00 •Tracking: 00:01:00