Excel, Data Science, Python and Machine Learning

Learn to code for data analysis, predictive modeling and artificial intelligence

Course Description

Learn data science and programming in Excel and Python. Learn to use Excel to pull in historical stock data and perform statistical analysis. Learn to understand the basics of statistics and machine learning in Excel.

Take your skills to the next level by learning how to code in Python. You’ll be able to build more powerful projects than ever possible in Excel. You’ll learn how to move your data science tasks from Excel to Python. This will improve your efficiency and data science skills.

Learn to code in Python from scratch for data science. Learn machine learning, a subset of artificial intelligence closely related to data science. Read Excel files with Python and use the data to make predictions with machine learning models.

Learn to use Excel files in Python, import data and manipulate sheets. You’ll find Python much easier and convenient to use than Excel once you master the fundamentals of programming. Build Excel tasks in Python to improve your speed and automate routine tasks.

Build neural networks and more machine learning projects. Finish the course with a grand portfolio and the skills to build any project requested at the coding interview. What are you waiting for? Enroll now!

Why Take This Course?

Keep your skills sharp to become indispensable on the job market. You must keep your resume updated to stay competitive and keep your job. Learn to produce projects and prove yourself useful. Learn to code to stay employed no matter the economy. There’s no safer job than coding.

Businesses love self-starters. The best way to spend your free time is to build practical projects that no one can take away from you. Sign up now to build top-earning projects and make your resume shine.

Why Python?

Python is the most popular coding language for data science, artificial intelligence and automation. Python is beginner-friendly and used to build machine learning agents, robots, web apps, video games, automated scripts and much more. Python developers make between $60-137,000 USD on average. If you want to learn to code, Python is the perfect place to start.

What is Data Science?

Data science is named one of the hottest careers today because of the amount of data generated every day and its power. 

Data science extracts knowledge and insights from data. Data scientists collect data, analyze data, visualize data and much more. Knowledge from data is then applied to a range of application domains. 

Data science works closely with machine learning to design user experiences, increase sales, design robots and much more. 

What is Machine Learning?

Machine learning describes software that uses previously-seen data to find patterns and perform some task unknown to it. The improvements are the result of an algorithm changing values by itself rather than a programmer manually tweaking the algorithm.

Machine learning allows us to build more powerful, more accurate, and more user friendly software. Machine learning programs respond and adapt and are often more effective than manual solutions – Many companies are integrating machine learning or have already done so. There are many high-paying machine learning jobs out there!

Machine learning projects include facial recognition, self-driving cars, speech detection, stock prediction, language translation, artificial intelligence, and much more.

Course Learning Outcomes

  • Learn to code in the Python programming language 
  • Perform Excel tasks more efficiently in Python 
  • Use coding for data analysis, data science and data visualization
  • Build machine learning models and neural networks 

Course Curriculum

Week 1 – 

  • Pull Historical Stock Data in Excel 
  • Linear regression introduction 
  • Linear Regression On Stock Data In Excel
  • Check Accuracy Of Linear Regression

Week 2 –

  • What is the Python programming language
  • How to run Python code online in Colab 
  • How to code variables in Python
  • How to build and call functions in Python 
  • Classes and objects in Python
  • Python libraries

Week 3 – 

  • What is machine learning 
  • What is linear regression 
  • Build 1D and 2D Python lists 
  • Read Excel File With Python 
  • Reshape Data For Data Modeling
  • Build A Linear Regression Model With Python
  • Visualize Machine Learning Predictor With Python

Week 4 –

  • Use Excel File In Python
  • What are dictionaries
  • Manipulate Excel File With Python
  • Build Dictionaries With Python

Week 5 –

  • Import Data File Into A Pandas Dataframe
  • Excel Sheet Manipulation With Python 
  • Get Excel Sheet Information With Python

Week 6 –

  • Build View Excel Functions In Python
  • Build Filter Excel Functions In Python 
  • Build Filter Functions On Blockchain Dataset 
  • Aggregate Excel Data With Python
  • Build Excel Pivot Tables In Python

Week 7 – 

  • Recurrent Neural Networks
  • Import Stock Data
  • What Is Shaping Data
  • Shape Training And Testing Data
  • What Is Scaling Data
  • Scale Data For Training
  • What Is Keras
  • Build A Keras Model
  • Scale And Shape Data For Testing
  • Test The Model

Week 8 –  

  • Build more machine learning projects 
  • Where to go from here

Course Projects

Projects signal to employers that you know your stuff! You’ll build an impressive portfolio of projects that demonstrate your abilities. The Live Classes plan includes the projects below, while the Project Help / Tutoring plan includes these and help with your own custom project.

Project 1 – Build a linear regression machine learning model in Excel and Python

Compare the two techniques and learn the power of coding when it comes to data science and predictive analysis. Pull historical data into Excel and build a statistical model. Then learn to code in Python for machine learning. Build your model, train it on data, and evaluate its performance. You’ll be able to visualize your model’s results and determine its accuracy in making predictions.

Project 2 – Build a recurrent neural network

Neural networks are a powerful type of machine learning model under the deep learning branch. Especially accurate with large datasets, neural networks are powerful algorithms behind lane
detection, text sentiment analysis, object detection, motion detection and much more. Build a recurrent neural network, excellent at solving text or speech related problems. Build the project from scratch, from importing stock data to shaping the data and building a Google TensorFlow Keras model.

What Are The Plans & How Are They Structured?

Self Directed Plan

Our collection of instructional videos and sample code will allow you to work at your own pace. Furthermore, our video library is constantly expanding and you will have lifetime access to all future videos and code.

Live Classes Plan

Our experienced instructors will host live classes at pre-established times, allowing you to interact with other students and the instructor. You will also get a chance to work with other students, fostering collaboration and discussion.

Project Help / Tutoring Plan

Our experienced instructors will meet with you, through video conference on a set schedule, to make sure you’re understanding the concepts and to help with building your custom portfolio project.

Excel, Data Science, Python and Machine Learning Course Plans

3 and 5 Month Payment Plans Available

Excel, Data Science, Python and Machine Learning – Self Directed
$2,995.00
  • Lifetime access to our video library
  • Lifetime access to our library of code
  • Access to Lumiwealth community
  • Instructor support through Lumiwealth community
  • Access to Weekly Discussion Hour through Lumiwealth community

3 and 5 Month Payment Plans Available

Excel, Data Science, Python and Machine Learning – Live Classes
$4,995.00
  • Everything from the Self Directed plan
  • 8 weeks of live classes (2 hours per week)
  • 6 hours of dedicated live Q&A
  • Access to all future videos and code
  • Help with 2 personal projects
  • Get to know other classmates
  • Help with resume and interview prep
  • Unlimited email and chat Q&A

3 and 5 Month Payment Plans Available

Excel, Data Science, Python and Machine Learning – Project Help / Tutoring
$7,095.00
  • Everything from the Self Directed and Live Course plans
  • Includes upcoming Live Classes (8 weeks/2 hrs per week)
  • Help with building a custom project, including software development if needed
  • 10 hours of 1-on-1 video/phone sessions or software development time with our experts

Book a call with us today! Save when you bundle courses and purchase more than one! Monthly payment plans are available at checkout!

4.8/5
TOP-RATED COURSE + UNIQUE APPROACH

This is the best finance focused data science/python course, rated 4.8 out of 5!

0
STUDENTS HAVE TAKEN OUR COURSES

We have helped thousands of students all over the world with our courses.

LIFETIME ACCESS (INCLUDING UPDATES)

We’re always adding new material – and you’ll get lifetime access to the content!

CERTIFICATE OF COMPLETION

After successfully passing the course you will receive a certificate of completion that you can show to employers.

Upcoming Live Classes

February 2023

Registration Closes
February 21, 2023

Course Starts
February 28, 2023

Course Length
8 Weeks (Excluding Holiday Breaks)

Effort
8-12 Hours Per Week, Self Paced Learning

Class Schedule
Every Tuesday at 8 pm EDT (5 pm PDT)

Lecture Duration
2 Hours Per Week,  Live Over Zoom

MEET YOUR INSTRUCTOR:

ALEKSANDRA KROPOVA

Alexandra Kropova has taught thousands of students in courses like Beginners Solidity for Ethereum Blockchain, Beginners Marlowe Haskell for Cardano Blockchain, and Blockchain and Cryptocurrency Machine Learning. When not building software, Alexandra teaches through online courses, live boot camps, blog posts, and YouTube tutorials on Blockchain, Python, JavaScript, and more software development topics. Alexandra has helped produce courses for Mammoth Interactive since 2016.

Testimonials from the Lumiwealth Community
Testimonials from the Lumiwealth Community
Testimonials from the Lumiwealth Community

Join the thousands of students that are already learning at Lumiwealth

“I didn’t want to buy a course of just videos. I think having somebody to interact with, like you’ve been great both on Discord and chat… Then the class has been interactive but also you’ve hopped on a call and just helped me out which has been game changing. So that’s why I chose Lumiwealth, it was really because you guys offer that level of care.”

“There’s people coming from way different backgrounds, some people are day traders like me others are more in the field of finance, and so it was really cool to just meet everybody and interact.”

– Agim Salija

“The class has been great. It has done exactly what I sought out. I have learned techniques to help me assess the quality of trading strategies which I didn’t have before. Overall, it has boosted my ability to create a trading bot and more easily test strategies in a way that I wasn’t able to before.”

“For anyone who is looking to learn Python, Finance, and putting together the dots in order to create their own strategy or enter the job market, I think this would be a great course to take.”  

– Rene Serulle

“Absolutely would recommend the classes. I went live with this trading bot a couple of weeks ago and right now I have almost made 80% of the money I spent on the course itself back from the bot itself. The trading strategies that I learned in the class paid for the class itself. I don’t think there is a better return on investment.”

“Learning from you was one of the biggest advantages. The depth of your experience you have and sharing that with all of us is amazing. To have that kind of person who’s willing to teach other people and help them enhance their lives is amazing.” 

– Santayan Paul

“I liked the variety of things being covered the most during the classes, not only how to set up a bot and connect to a broker, but also CAGR, long-term economic data, and things that I wasn’t really thinking about. For example, how long term trends can affect short-term prices. I liked the overall breadth of the class and how it wasn’t just all about the algo trading portion of it; there was a lot of how and what too.”

“I would recommend Lumiwealth’s classes to anybody who wants to understand and take more control of their trading. To anyone who wants to learn about Python/technology and trading and how these two things interplay with each other.” 

– Joel Brass

Any Questions?

Book a free consultation here:

Check out this preview of our Live Class where we show you a machine learning example, which is just one of the many things you will learn in this course: