Course curriculum

    1. Navigating the Excel Interface

    2. Creating and Formatting Your First Spreadsheet

    3. Exploring the Excel Interface in Detail

    4. Excel Interface Quiz 1

    5. Microsoft Excel Interface( Rename, Delete (WS), Change the tabs color)

    6. Microsoft Excel Interface( Change Column size, Freeze Panes)

    7. Hiding and Unhiding columns, tabs

    8. How to apply themes in Microsoft Excel

    9. Margins, Page Orientation, Size, Print Area

    10. How to Set up Print Titles

    11. Switch Worksheet View in Microsoft Excel

    12. Number pages, Add Headers and Footers

    13. Save , Print Workbook

    14. Cut, Paste, Format Painter (Clipboard Group)

    15. Adjust, Change, Fill Font Color

    16. The Alignment Group ( right,left, center alignment )

    17. The Number Group(Home Tab)

    18. Styles Group

    19. Cells Group

    20. Cells Group (Problem Cont.)

    21. Editing Group

    22. Editing Group (Sum +Clear)

    23. Quiz 2

    1. Basic Formulas ( Auto Fill, Cell References)

    2. Absolute vs Relative References

    3. Data Cleaning

    4. Using the Concat function in Microsoft Excel

    5. Textjoin In Microsoft Excel

    6. Sum, Average, Min ,Max in Microsoft Excel

    7. Left, Right Text Extraction in Microsoft Excel

    8. The IF function in Microsoft Excel

    9. Countif ,If In Microsoft Excel

    10. If,And Function in Microsoft Excel

    11. If,Or Function in Microsoft Excel ,Sumif

    12. Date and Time functions in Microsoft Excel

    13. Naming Ranges in Microsoft Excel

    14. View,Edit,Delete Named Range

    15. Total Sales, Average, and Conditional

    16. Quiz 3

    1. Conditional Formatting

    2. How to insert a clustered column chart

    3. Insert a Pie Chart

    4. Line Charts in Microsoft Excel

    5. Chart Elements

    6. Chart Elements 2

    7. Create Tables in Microsoft Excel

    8. Tables in Microsoft Excel 2

    9. Grouping in Excel

    10. Sorting In Excel

    11. Filtering in Excel

    12. Quiz 4

    1. Pivot Table in Microsoft Excel

    2. Vlookup in Microsoft Excel

    3. Loan Amortization Schedule in Microsoft Excel

    4. Net Present Value

    5. Net Present Value 2

    6. PV and FV

    7. How to Import a Text File to Microsoft Excel

    8. How to Insert a Picture into Microsoft Excel

    9. How to Insert a Picture into Microsoft Excel

    10. How to Customize the Ribbon

    11. How to Protect your Worksheet

    12. The internal Rate of Return

    13. Quiz 5

Unlock the power of Microsoft Excel with this comprehensive course designed for learners of all levels! Whether you're a beginner looking to understand the basics or an intermediate user aiming to refine your skills, this course will guide you step-by-step through Excel’s essential features. In this course, you will: - **Master the fundamentals**: Learn how to navigate the Excel interface, create and format spreadsheets, and work with formulas and functions. - **Boost your productivity**: Discover time-saving tips, keyboard shortcuts, and tools to streamline your workflow. - **Analyze data effectively**: Understand how to organize, manipulate, and visualize data using powerful features like pivot tables, charts, and conditional formatting. - **Tackle real-world projects**: Apply your skills to practical scenarios such as budgeting, data analysis, and reporting. By the end of this course, you will feel confident in your ability to use Excel like a professional, whether for personal projects or professional tasks. Ready to boost your Excel skills and open up new career opportunities? Let's get started!

  • $79.00
  • 64 lessons
  • 6.5 hours of video content

Discover your potential, starting today

**Transform Your Skills with Excel—Enroll Now!**

Enroll today