Save For Later

Microsoft Excel Programming

Save For Later

Microsoft Excel offers several powerful programming features you can use to automate mundane tasks and enrich your spreadsheets with custom logic and behavior. This skill will teach you to leverage the Visual Basic for Applications programming language inside of Excel, as well as using built-in Excel functions to perform data lookups, calculations, and logical comparisons.

What You'll Learn

  • Visual Basic for Applications
  • Excel Macros
  • Built-in Excel Functions
  • Troubleshooting Formulas
  • OpenCourser is an affiliate partner of Pluralsight and may earn a commission when you buy through our links.

    From Pluralsight
    Hours 7
    Instructors Pratheerth Padman, Craig Golightly, Mike McQuillan
    Language English
    Subjects IT & Networking

    Similar Courses

    Sorted by relevance

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

    Microsoft instructor $62k

    Excel Reporting Developer $68k

    Excel/Access DTS Developers $78k

    Microsoft CSR $81k

    Excel VBA Developer $82k

    Excel/Access DTS Developer $83k

    Tutor - Accounting/ Excel /ESL $87k

    Microsoft Access Programmer $96k

    SDE in Microsoft $106k

    SDE @ Microsoft 5 $110k

    Microsoft Active Directory/Microsoft Exchange Administrator. $114k

    Microsoft Active Directory/Microsoft Exchange Administrator. $114k

    Courses in this Paths

    Listed in the order in which they should be taken

    Starts Course Information

    On Demand

    Recording and Managing Excel Macros

    Unbeknownst to most people, a whole lot of our daily tasks performed in Excel can be automated. In this course, Recording and Managing Excel Macros, you will dip into the world of...

    Pluralsight

    Save

    On Demand

    Excel Logic Function Playbook

    Excel is often the hammer that is applied to many jobs. Knowing the built-in functions can save you time and frustration. In this course, Excel Logic Function Playbook, you will...

    Pluralsight

    Save

    On Demand

    Excel Statistics and Finance Function Playbook

    Excel is used for many jobs, and while you can invent all of your own functions, knowing how to use the built-in functions can save you time and frustration. In this course, Excel...

    Pluralsight

    Save

    On Demand

    Excel Data Lookup Function Playbook (You were viewing this course)

    Imagine that you’ve been given a Microsoft Excel worksheet with tons of data - hundreds or even thousands of rows, and thousands of columns. The task you’ve been given is to...

    Pluralsight

    Save

    On Demand

    Excel Time and Date Function Playbook

    Microsoft Excel workbooks are seldom found without several cells filled with relevant dates or timestamps. As such, it is important to know how to deal with them, and in this...

    Pluralsight

    Save

    On Demand

    Developing for Excel with VBA

    Microsoft Excel. It’s one of the most popular and used applications in the world, especially in business. Most people can use it to manage data and run simple calculations. But...

    Pluralsight

    Save

    Pluralsight

    From Pluralsight
    Hours 7
    Instructors Pratheerth Padman, Craig Golightly, Mike McQuillan
    Language English
    Subjects IT & Networking

    Careers

    An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

    Microsoft instructor $62k

    Excel Reporting Developer $68k

    Excel/Access DTS Developers $78k

    Microsoft CSR $81k

    Excel VBA Developer $82k

    Excel/Access DTS Developer $83k

    Tutor - Accounting/ Excel /ESL $87k

    Microsoft Access Programmer $96k

    SDE in Microsoft $106k

    SDE @ Microsoft 5 $110k

    Microsoft Active Directory/Microsoft Exchange Administrator. $114k

    Microsoft Active Directory/Microsoft Exchange Administrator. $114k

    Similar Courses

    Sorted by relevance