
In this video we will see all the topics i have covered in this course.
What is Excel and Its Importance in various fields
Open the Excel application from the start button or search bar and view the blank workbook. Explore the quick access toolbar, ribbon tabs, columns, rows, and cells.
Learn how to save and save as in Excel, choose a location (OneDrive or PC), rename the workbook, and pick an extension such as .xlsm or the default Excel type.
Learn how to enter data in an Excel workbook, create entries for products, quantities, and prices, and observe the default alignment: text left, numbers right.
Explore how a workbook contains multiple worksheets, and a worksheet is a single entity. Add sheets with the plus button, delete with a right-click (permanently), and rename sheets.
Explore copy and paste special in Microsoft Excel, mastering formulas, number formatting, keep source formatting, values, values and number formatting, transpose, linked picture, and skip blanks for precise edits.
Understand relative and absolute references in Excel, why dragging formulas changes cell references, and how to lock a cell with absolute reference using F4.
Explore formatting in Excel by mastering the font group: changing fonts and sizes, applying bold/italic/underline, borders, fill colors, and font colors to improve readability of employee data.
Learn to use Excel's alignment group to adjust vertical alignment (top, middle, bottom) and horizontal alignment (left, center, right). Rotate text, wrap text, merge and center cells, and adjust indents.
Explore Excel formatting essentials, converting data to number, currency, and date formats, adjusting decimals, symbols, and borders using the format cells dialog (Ctrl+1) for clean, readable spreadsheets.
Explore conditional formatting in Excel, applying highlight cell rules and top bottom rules to visualize revenue and other data with rules like greater than, less than, between, and duplicates.
Master conditional formatting in Excel by applying data bars, color scales, and icon sets to visualize revenue data and build readable dashboards.
Apply conditional formatting to an entire row based on a single column value using a formula with absolute references, locking the column for consistent results.
Master how to freeze panes in excel to keep column headers visible as you scroll, freeze the top row or the first column, and unfreeze when needed.
Learn how to sort numbers, text, and dates in Microsoft Excel, preserving relationships across columns and choosing smallest to largest, a to z, and oldest to newest.
Learn how to perform advanced sort in Excel, including sorting by cell color, multi-column sorting by job title and business unit, and proper data selection using the custom sort dialog.
Learn to use filters in Microsoft Excel to hide data and focus on sales and revenue. Apply text, number, and date filters via data tab and filter button with Ctrl+Shift+L.
Learn to filter data by dates in Excel using date filters for this month, last month, last year, and quarter data, and toggle with ctrl+shift+l.
Learn how to use the advanced filter to apply multiple criteria, copy results to another location, and define list range, criteria range, and copy-to location in Excel.
Master Microsoft Excel : From Basics to Advanced - Boost Your Skills with Real-World Applications
This Course will teach one and all interested in knowing the best software invented till date which is none other than Microsoft Excel.
Unlock the full power of Excel and become an expert, whether you're a beginner or looking to refine advanced skills. This comprehensive course covers Microsoft Excel basics, essential functions, advanced data analysis techniques, and dynamic tools like Power Query.
Course Highlights:
Excel Basics and Data Entry: Start from the ground up with an introduction to Excel, saving files, entering data, and navigating workbooks and sheets.
Excel Formatting and References: Learn formatting essentials and understand relative vs. absolute references for efficient data handling.
Sorting and Filtering Data: Discover essential and advanced methods for sorting and filtering, including conditional formatting for enhanced data visibility.
Essential Excel Functions: Master core functions such as IF, SUMIF, COUNTIF, and nested IF statements to streamline your calculations.
Logical and Text Functions: Deep dive into logical tests, text manipulation, and date/time functions for a comprehensive understanding of Excel capabilities.
Data Management Tools: Explore advanced tools like data validation, flash fill, and text-to-columns, as well as methods to consolidate data from multiple sheets.
Powerful Lookup Functions: Gain expertise with VLOOKUP, HLOOKUP, XLOOKUP, INDEX, and MATCH for accurate data retrieval.
Pivot Tables and Dynamic Charts: Unlock the power of pivot tables and create visually compelling charts including bar, pie, line, area, and scatter plots.
Advanced Data Analysis: Learn to use Power Query to combine data from multiple files and master tools like scenario manager, goal seek, and data tables.
By the end of this course, you’ll be prepared to use Excel confidently across any business or personal project. Whether you’re a student, business professional, or simply aiming to upskill, this course will transform your data capabilities.
Enroll now to enhance your Excel expertise and stand out in today’s data-driven world