Skip to main content

Posts

Showing posts with the label COURSE#1

Microsoft excel course for beginner to advanced learners- Module 6

 Microsoft excel course for beginner to advanced learners MODULE 6 - PIVOT TABLE & EXCEL EXTRAS Lesson 24 - Overview of Excel Pivot Table The video covers the following topics: Introduction to Pivot Tables Creating a Pivot Table in Excel Formatting the Pivot Table Grouping data in an Excel Pivot table Calculated Field/Items in Pivot Table Pivot Table Slicers Pivot Charts Pivot Tables are an excellent feature in Excel that allows you to quickly summarize large amounts of data with just a few clicks. Even if you are new to Excel, you can easily grasp the concept. This video covers a lot about Pivot Tables. However, if you want to learn more, you can check out all the Pivot Table tutorials available. The video is quite long, so if you want to dive deeper into any of the topics covered in the video, you can refer to the recommended articles section.

Microsoft excel course for beginner to advanced learners - MODULE 5

MODULE 5 - INTRODUCTION TO EXCEL CHARTING MODULE 5 / 6 Lesson 21 - Introduction to Excel Charting In this free Excel training video, you will learn about creating and formatting charts to represent your data visually. Excel provides a variety of built-in charts that you can use to represent your data instantly, and you can create various combination charts and advanced charts to present a large amount of information in a single chart. The video covers the following topics: Introduction to Excel Charting and Chart Types Editing and Formatting Charts Formatting Chart Elements Creating Combination Charts Dealing with Gaps in Charts.

Microsoft excel course for beginner to advanced learners - MODULE 4

Microsoft excel course for beginner to advanced learners MODULE 4 / 6 - DATA ANALYSIS Lesson 17 - Named Ranges in Excel In this free training video, you will get an understanding of using Named Ranges in Excel. This session includes the following topics: Creating Named Ranges Managing Named Ranges Useful Keyboard Shortcuts Creating Dynamic Named Ranges using OFFSET and INDEX formulas

Microsoft excel course for beginner to advanced learners - MODULE 3

Microsoft excel course for beginner to advanced learners MODULE 3 / 6 - EXCEL FORMULAS Lesson 9 - Excel Formula Basics This tutorial covers the following key topics: The constituents of an Excel formula: Understand the basic structure of an Excel formula and the different elements that make it up. Operators in formulas: Learn about the different types of operators that can be used in Excel formulas and how they work. Entering a formula in Excel: Discover how to input formulas in Excel and how to use cell references in your formulas to calculate results based on the data set. Editing a formula: Learn how to modify existing formulas to reflect changes in your data set. Absolute and relative cell references: Understand the differences between absolute and relative cell references and how to use them in your formulas. Copying and pasting formulas in Excel: Learn how to copy and paste formulas to different parts of your worksheet, and how to use this feature to improve your effi

Microsoft excel course for beginner to advanced learners - MODULE 2

Microsoft excel course for beginner to advanced learners MODULE 2 / 6 Lesson 6 - Introduction to Excel Tables The following are the key highlights covered in this Module of Microsoft excel course for beginner to advanced learners Lesson 6 Creating an Excel Table Excel Table features Structured references Table slicers Excel tables are a powerful feature that can be of immense use when working with large amounts of data, dashboards, and models. This tutorial demonstrates how to leverage Excel tables effectively. Note that table slicers were introduced only in Excel versions 2013 and newer.

Microsoft excel course for beginner to advanced learners - MODULE 1

Microsoft excel course for beginner to advanced learners MODULE 1 OF 6 There are over 26 lessons and 12+ hours of free Excel training available in video format. Start learning for free without any sign-up requirements by simply scrolling down. Get started with learning Excel today for free with our comprehensive Excel course with a certificate. Whether you're a beginner or intermediate learner, this is the perfect place to start. Access our free online Excel training , which includes 26 video lessons with over 12 hours of learning, without having to sign up for anything. All you have to do is scroll down and start watching the videos. To maximize your learning experience, we recommend that you go through the Excel training videos in the sequence listed, which we've divided into 7 modules. If you're an intermediate or advanced user, feel free to choose which lessons you want to watch. If you encounter any blurry videos, you can easily adjust the video quality to 7