This course shows you how to use OpenPyXL to automate functions in Excel using Python, automate Excel tasks and build a wide range of Excel projects.
Excel Visual Basic Applications - Intermediate LevelCourse
This course is a comprehensive overview of what effective business analysts really do - their strategies, techniques, tools, and methods – all of which apply to any process whether it’s a traditional large project, an Agile or DevOps project.
Excel Visual Basic Applications for BeginnersCourse
This course is an introduction to Excel Visual Basic Applications or VBA. It introduces you to how VBA and you can use the Visual Basic Editor to create procedures (referred to as a macro) with VBA code that accomplishes a task. The macros you will
Using Python and Excel for Investing in StockCourse
This course will show you how to use Excel and Python in tandem to pull stock data and related information, calculate returns and establish a portfolio management strategy, predict stock market trends and much more.
This course on Amazon Honeycode jumps you into a use case for Honeycode so you know how it works and how it can be applied practically. Learn to use Honeycode to quickly build mobile and web apps for teams—without programming.
Excel Pivot TablesCourse
Excel Pivot Tables are powerful tools to help understand and analyze data. This course covers the power of Pivot Tables and how they can be used to create sums, averages, or other statistical analysis of grouped values.