Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Leadership Microsoft Excel skills for business
Rating: 4.4 out of 5(5 ratings)
24 students

Leadership Microsoft Excel skills for business

Learn Excel quickly through a project based approach
Created byEmeka Onodugo
Last updated 3/2024
English

What you'll learn

  • Excel VBA
  • Excel Funcions
  • Excel automation
  • Excel for engineers
  • Excel for product managers
  • excel for project Managers
  • excel for designers
  • Macros
  • Index Functions
  • Match Functions
  • If then statements
  • importing live data
  • stock data
  • cryptocurrency data
  • stock portfolio

Course content

6 sections14 lectures2h 23m total length
  • Introduction - Excel Workbook Overview9:36

    In this video I will give you a high level overview of the Excel workbook and all its features.  If you are not a beginner that you may want to skip to the next video.

    From the Home Tab

    • Adding Worksheets

    • Renaming Worksheet

    • Adding Color to Excel worksheet

    • Format Painter

    • Borders

    • Wrap Text

    • Formatting numbers

    • Conditional formatting

    • Merging Cells

    Functions and Formulas tab

    Data tab

    • Importing data from the internet


Requirements

  • None

Description

Tired of generic Excel tutorials that leave you feeling lost? This course takes a different approach, equipping you with the skills and confidence to excel (pun intended!) in the workplace.


Why Excel?


Excel is the king of spreadsheets, a versatile tool used across industries for tasks like:


  • Project Management: Track project timelines, budgets, and resources with ease.

  • Product Management: Design sleek app prototypes and analyze user data within Excel.

  • Finance and Trading: Create dynamic trading sheets to analyze Bitcoin and other cryptocurrencies.

  • Presentations and Design: Craft compelling visuals for impactful presentations.

  • Automation: Simplify repetitive tasks and boost your productivity with Excel's automation features.

Learn by Doing: The Project-Based Approach


This course ditches the theoretical fluff and dives right into practical projects that mirror real-world scenarios. You'll build:


  • A Vulnerability Report: Learn valuable skills for cybersecurity professionals by constructing a report similar to those used in the field.

  • An App Template: Channel your inner product management guru by designing a user-friendly app template within Excel.

  • Customized Trading Sheets: Take control of your cryptocurrency investments with dynamic sheets to analyze Bitcoin and other markets.

This hands-on approach ensures you grasp the true power of Excel, learning only the functionalities you'll need for immediate effectiveness in the workforce.


Beyond the Basics: Embracing the Future of Work


We understand the workplace is evolving rapidly. As AI continues to transform how we work, this course goes a step further by including exclusive video tutorials demonstrating how to integrate AI tools directly into your Excel workflow.


By the end of this course, you'll be a confident Excel user, equipped with the skills to tackle real-world projects, integrate cutting-edge AI functionalities, and impress in any professional setting.

Who this course is for:

  • All Levels (Beginner - Expert)