Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Mastery | Microsoft Excel
Rating: 4.6 out of 5(105 ratings)
182 students

Excel Mastery | Microsoft Excel

Unlocking the Power of Spreadsheets
Created bySelfcode Academy
Last updated 6/2023
English
English [Auto],

What you'll learn

  • Gain a solid understanding of Excel's interface, including navigating worksheets, entering data, formatting cells, and utilizing essential functions and more.
  • Learn to create and edit formulas, understand operators and functions, and use cell references effectively to perform calculations and manipulate data.
  • In this course Students will Master the creation and customization of PivotTables and PivotCharts in Excel for in-depth data analysis and dynamic reporting.
  • Understanding how to protect sensitive data in Excel through workbook and worksheet protection, password encryption, and other security measures.
  • Gain expertise in advanced formatting techniques in Excel, including conditional formatting, and cell styles to enhance the visual appeal of worksheets.

Course content

2 sections • 27 lectures • 4h 18m total length

  • Getting Started5:49

    Learn why Excel is essential for data analysis. Explore interface features, including worksheet control buttons, formula bar, scroll bars, ribbon, title bar, file tab, sheet tabs, and quick access toolbar.

  • Key Shortcuts6:45
  • Entering Data9:22

    Explore data entry in Excel by distinguishing text from numbers, including alignment and formula auto fill. Learn autofill, custom lists, and date and time handling to speed work.

  • Mathematical Operations4:54

    Master basic mathematical operators in Excel, building formulas that start with equals, using plus, minus, and divide with direct cell references or AutoSum and the fill handle.

  • Cell Referencing7:06
  • Basic Functions7:52
  • Adjusting Worksheet5:08

    Learn to move and copy data, insert and delete rows and columns, adjust width and height, hide and unhide rows, and use auto resize to manage a worksheet.

  • Protection11:08

    Learn to protect Excel data by protecting sheets and workbooks, locking and unlocking cells, and encrypting with passwords to control edits, structure, and access.

  • Cell Formatting11:31

    Explore cell formatting in Excel, learning to format fonts, colors, borders, and alignment; merge cells, apply wrap text, and customize numbers with currency, percentages, and decimals.

  • Conditional Formatting19:17

    Explore conditional formatting in Excel to highlight cells by criteria, apply color scales, data bars, icon sets, and top and bottom rules, and build advanced formatting with formulas.

  • Format Painter5:20

    Master the Excel format painter to copy all formatting from one data set to another, applying colors, borders, alignment, and styles across sheets with single or double clicks and F4.

  • Shapes and Images in Excel9:54
  • Charts27:35

    Master Excel charts, including column, bar, line, pie, scatter, and sparklines, while learning chart elements, formatting, and quick creation shortcuts (Alt+F1, F11) to visualize data clearly.

  • Printing Options10:03

    Explore printing options in Excel, including printing worksheets or workbooks, setting print areas, and using page layout, headers and footers, and print titles for repeated headings.

  • Templates3:55

    Explore Excel templates, learn to create and save pre-designed spreadsheets with predefined formulas, and reuse templates such as an invoice to streamline repetitive work.

  • Tables11:08
  • Database Functions9:31
  • Data Validation11:43

    Master data validation in Excel by defining input restrictions, preventing invalid entries, and using dropdown lists, date, numbers, or text length rules with helpful error messages.

  • Pivot Tables11:32

    Pivot tables summarize and transform data in Excel by turning columns into rows and rows into columns, enabling grouping, calculations, and dashboards without macros.

  • Conditional Functions11:01
  • Named Ranges4:17
  • Lookup Functions17:01
  • Text Based Functions10:14

    Master text functions in Excel: left, right, and mid extract characters; use len and trim for length and spaces; search locates substrings; and concat builds IDs.

  • Additional Formulas12:46
  • Tools7:36

    Explore Excel tools such as scenario manager for comparing and swapping multiple data sets, and goal seek for solving by trial and error within what-if analysis, with practical examples.

  • User Forms6:16

    Create a user form in Excel with VBA, customize colors and properties, add text boxes, combo boxes, list boxes, check boxes, and toggle buttons, and implement code to run it.

Requirements

  • Our Microsoft Excel course is designed for individuals of all levels, with no prerequisites required.
  • Whether you are a beginner or have some prior experience with Excel, this course will provide you with a solid foundation and take you to the next level of proficiency. Starting from the basics, you will learn how to navigate the Excel interface, enter data, and format cells effectively. Through step-by-step instructions and practical exercises, you will gain hands-on experience in creating formulas, manipulating data, and generating insightful visualizations. Our comprehensive curriculum covers essential Excel features and functions, ensuring you acquire the necessary skills to analyze data, streamline tasks, and make informed decisions. By the end of this course, you will have the confidence to handle complex data sets, create dynamic reports, and maximize your productivity using Excel's powerful tools and functionalities.

Description

Unlock the full potential of Microsoft Excel with a comprehensive online course from SELFCODE ACADEMY.

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\  "  Excel Mastery | Microsoft Excel  "   \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\


Whether you're a business professional, analyst, student, or simply looking to enhance your spreadsheet skills, this course is designed to take you from an Excel novice to an Excel expert.

This course covers all aspects of Microsoft Excel, starting from the basics and progressing to advanced techniques and functionalities. You'll learn how to navigate the Excel interface, create and format spreadsheets, perform calculations, analyze data, visualize information, and much more.


Why Choose Our Microsoft Excel Course?

Beginner-Friendly Approach: This course assumes no prior Excel knowledge, making it ideal for beginners. We'll guide you step-by-step through the fundamentals, ensuring a smooth learning experience.


Comprehensive Curriculum: Our curriculum covers a wide range of Excel features, including formulas, functions, pivot tables, charts, data analysis tools, conditional formatting, data validation, and advanced functions like VLOOKUP and IF statements.


Hands-On Practice Sheet: Theory alone is not enough. You'll gain hands-on experience by working on practical exercises and real-world examples (TOPIC-WISE), allowing you to apply your knowledge in a meaningful way.


Expert Instructors: Learn from highly skilled instructors who have extensive experience using Excel in professional settings. They'll share tips, tricks, and best practices to help you maximize your efficiency and productivity.


Flexible Learning: Study at your own pace and convenience. Our course is available online, allowing you to access the materials anytime, anywhere, and on any device.


Industry-Recognized Certification: Upon completion of the course, you'll receive a certificate of achievement, highlighting your proficiency in Microsoft Excel, which can enhance your resume and career prospects.


\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\    Course  Curriculum  \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\


Section: 1  Basics of Microsoft Excel

Lecture 1: Getting Started

Lecture 2: Key Shortcuts

Lecture 3: Entering Data

Lecture 4: Mathematical Operations

Lecture 5: Cell Referencing

Lecture 6: Basic Functions

Lecture 7: Adjusting Worksheets

Lecture 8: Protection

Lecture 9: Cell Formatting

Lecture 10: Conditional Formatting


Section 2: Advanced Excel Features

Lecture 11: Format Painter

Lecture 12: Shapes and Images in Excel

Lecture 13: Charts

Lecture 14: Printing Options

Lecture 15: Templates

Lecture 16: Tables

Lecture 17: Database Functions

Lecture 18: Data Validation

Lecture 19: Pivot Tables

Lecture 20: Conditional Functions

Lecture 21: Named Ranges

Lecture 22: Lookup Functions

Lecture 23: Text-Based Functions

Lecture 24: Additional Formulas

Lecture 25: Tools

Lecture 26: User Forms


Section 3: Practice Sheet


Boost your productivity, efficiency, and analytical skills with our  "Excel Mastery | Microsoft Excel"  course.

Join thousands of satisfied learners who have already mastered the power of Excel. Enrol now and take your Excel skills to the next level!


Who this course is for:

  • This course is designed to equip you with the essential skills and knowledge needed to become proficient in this powerful spreadsheet software.
  • This course is suitable for anyone looking to enhance their data management and analysis abilities.

Report abuse