starweaver-logo
LOG INGET STARTED
LOG INGET STARTED
  • Browse
  • Doing

  • On Air
  • Channels
  • Career Paths
  • LEARNING

  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • CONNECTING

  • How It Works
  • Community
  • Techbytes
  • Podcasts
  • Leaderboards
  • SUPPORT

  • Support & FAQs
  • Starweaver for Business
  • Starweaver for Campus
  • Teach with Starweaver
footer-brand-logo
  • COMPANY
  • About Us
  • Support and Knowledge Base
  • Policies & Terms
  • Contact
  • CONTENT
  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • Meet the Gurus
  • Techbytes
  • FOR ORGANIZATIONS
  • Starweaver for Business
  • Starweaver for Campus
  • Catalogue
  • Pricing
  • Private Classes
  • PARTNER WITH US
  • Instructors & Teachers
  • Books, Writing & Publishing
  • FOLLOW US
    • facebook
    • twitter
    • linkedin
    • pinterest
    • instagram
    • youtube
Our trademarks include Starweaver®, Make genius happen™, Education you can bank on®, People are your most important assets!®, Body of Knowledge™, StarLabs™, LiveLabs™, Journeys™
© Starweaver Group, Inc. All Rights Reserved.
  1. Journeys
  2. >
  3. Advanced Excel

Advanced Excel

This very brief introduction to Excel helps you get a feeling for what you can do with Excel and why you should develop Excel skills. In this journey you will get to know the advance feature of excel and the application of these.
John Bura
John Bura
Business | advanced | 17 hours 30 minutes

    Discussions

Overview

1.8KSTUDENTS*
94%RECOMMEND*

 This Journey includes:

  • 18 hours of on-demand video
  • 33 modules
  • Core level
  • Direct access/chat with the instructor
  • 100% self-paced online
  • Many downloadable resources
  • Shareable certificate of completion
Excel is one of the most important software packages in the World with 10s of millions of users and a vast array of applications.  This very brief introduction to Excel helps you get a feeling for what you can do with Excel and why you should develop Excel skills. In this journey you will get to know the advance feature of excel and the application of these. The program's framework consists of lectures covering 2 separate topics:
  1. Excel Visual Basic Applications for Beginners - This course is a introduction to Excel Visual Basic Applications, or VBA. It introduces you how VBA and you can use the Visual Basic Editor to create procedures (referred to as a macros) with VBA code that accomplishes a task.
  2. Excel Visual Basic Applications - Intermediate Level - Once you have completed our course on "Excel Visual Basic Applications for Beginners," you are ready for this higher level program which covers many of the intermediate and advanced functions you can write with in Visual Basic within Excel.
  3. Excel Financial Analysis - If you do any type of financial analysis, you know that Excel is the tool of choice and it understanding its nuances is essential for you.  This program helps you to understand how to use Excel in any financial analysis.
  4. Python Excel - 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.

Skills You Will Gain

Excel

Learning Outcomes (At the end of this program you will be able to)

Who Should Attend

  • Anyone interested in learning the core features and functions of Excel, and applying these skills in practical settings.

Curriculum

Instructors

Frequently Asked Questions

How much do the courses at Starweaver cost?

We offer flexible payment options to make learning accessible for everyone. With our Pay-As-You-Go plan, you can pay for each course individually. Alternatively, our Subscription-Based plan provides you with unlimited access to all courses for a monthly or yearly fee.

Do you offer any certifications upon completion of a course at Starweaver?

Yes, we do offer a certification upon completion of our course to showcase your newly acquired skills and expertise.

Does Starweaver offer any free courses or trials?

No, we don't offer any free courses, but we do offer 5-day trial only on our subscriptions-based plans.

Are Starweaver's courses designed for beginners or advanced students?

Our course is designed with three levels to cater to your learning needs - Core, Intermediate, and Advanced. You can choose the level that best suits your knowledge and skillset to enhance your learning experience.

What payment options are available for Starweaver courses?

We accept various payment methods such as major credit cards, PayPal, wire transfer, and company purchase orders. For more information related to payments contact customer support.

Do you offer refunds?

Yes, we do offer a 100% refund guarantee for our courses within a specified time frame. If you are not satisfied with the course, contact our customer support team to request a refund with your order details. Some restrictions may apply.

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.
Excel Visual Basic Applications – Intermediate Level

Excel Visual Basic Applications – Intermediate Level

Part 2: Excel Visual Basic Applications – Intermediate Level

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 Beginners

Excel Visual Basic Applications for Beginners

Part 1: Excel Visual Basic Applications for Beginners

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

Excel Financial Analysis

Excel Financial Analysis

Part 3: Excel Financial Analysis

If you do any type of financial analysis, you know that Excel is the tool of choice and it understanding its nuances is essential for you.  This program helps you to understand how to use Excel in any financial analysis.

Python Excel

Python Excel

Part 4: Python Excel

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.

1Welcome to the course!
2Module 01: Course Introduction
3Module 02: Send Messages with MsgBox
4Module 03: Workbook and Worksheet Objects
5Module 04: Work with the Range Object
6Module 05: Work with Range Properties
7Module 06: More Range Projects
8Module 07: Variables
9Module 08: Work with Conditionals
10Module 09
11Module 10

Segment - 03 - Topics Overview

Segment - 04 - Build a Simple Message

Segment - 05 - Build an Advanced Message

Segment - 06 - Empty a Sheet with the MsgBox Function

Segment - 07 - Prompt User for Input

123

1Module 01: Introduction to the Course
2Module 02: Use OpenPyXL and Sheets
3Module 03: Worksheet Tables
4Module 04: Build 2D Charts
5Module 05: Project Employee Time log
6Module 06: Write to a Text File
7Module 07: Update a Spreadsheet
8Module 08: More Chart Types
9Module 09: Web Scrapping
1Module 01: Introduction to the Course
2Module 02: Excel Statement Models
3Module 03: Excel Finance Methods
4Module 04: Conclusion
1Welcome to the course!
2Module 01: Introduction to Intermediate Level
3Module 02: Introduction to Loops
4Module 03: Loop Projects
5Module 04: String Manipulation
6Module 05: Build Custom Functions
7Module 06: Build Arrays
8Module 07: Work with Dates
9Module 08: Application Object
10Module 09: VBA Projects
11Module 10: Programming Charts
John Bura

John Bura

John Bura is a seasoned game developer, eLearning innovator, and AI coach with over 15 years of experience in the tech industry. Based in Vancouver, Canada, he serves as the CEO of Mammoth Interactive, where he leads the development of top-ranking games and applications across multiple platforms. His leadership also extends to Devonian Apps, a SaaS company known for delivering high-quality, fast-to-market digital products.

John is deeply passionate about education through technology. As a celebrated Udemy instructor, he has empowered over 300,000 students worldwide through practical courses on HTML5, Xcode, and game design, with his teaching style widely recognized for its clarity and real-world applicability. His dedication to curriculum excellence was further reflected in his role as a Program Advisor at Centennial College, where he shaped game design education to match industry demands.

With a rich background in both creative and technical disciplines, John has had his work featured by major industry players like Nickelodeon. As a forward-thinking AI expert, he now coaches businesses on building intelligent, automated infrastructures to increase efficiency and scalability. He's currently developing a cutting-edge tool that automates podcast and video production for content creators, furthering his mission to make innovation accessible.

Whether building games, coaching teams, or designing AI-powered tools, John blends creativity with technical mastery to drive productivity, foster innovation, and inspire learners around the world.

VIEW MY CHANNEL

Segment -42 - Topics Overview

Segment - 43 - Integer Data Type

Segment - 44 - String Data Type

Segment - 45 - Double Data Type

Segment - 46 - Boolean Data Type

Segment - 47 - Retain Variable Value

Source File

Segment - 51 - Topics Overview

Segment - 52 - Greeting Program Logical Operator and

Segment - 53 - Logical Operator or

Segment - 54 - Logical Operator not

123

Segment - 33 - Topics Overview

Segment - 34 - Union and Intersect of Ranges

Segment - 35 - Detect Content

Segment - 36 - Build a Range Program

Segment - 37 - Change Text Color

Segment - 38 - Bold a Range

Segment - 39 - Change Cell Color

Segment - 40 - Work with Areas

Segment - 41 - Find Differences in Ranges

123

Segment - 26 - Topics Overview

Segment - 27 - Find the current region of a cell

Segment - 28 - Dynamic Range Program

Segment - 29 - Resize a Range

Segment - 30 - Select Entire Rows and Columns

Segment - 31 - Offset Property

Segment - 32 - End Property

123

Segment - 48 - Conditionals

Segment - 49 - If then Statement

Segment - 50 - Else Statement

Source File

Segment - 01 - Course Overview

Segment - 02 - How to Save Macros

Source File

Segment - 17 - Topics Overview

Segment - 18 - Program a Range of a Spreadsheet

Segment - 19 - Use Cells instead of a Range

Segment - 20 - Use a Range Variable

Segment - 21 - Select a Range

Segment - 22 - Access a Row

Segment - 23 - Copy and Paste a Range

Segment - 24 - Clear a Range

Segment - 25 - Count a Range

Instructor bio - John Bura

Segment - 08 - Topics Overview

Segment - 09 - Object Hierarchy

Segment - 10 - Change Multiple Worksheets

Segment - 11 - Add and Count Worksheets

Segment - 12 - Get Path of a Workbook

Segment - 13 - Open and Close Workbooks

Segment - 14 - Loop Through Worksheets and Workbooks

Segment - 15 - Build a Sales Calculator

Segment - 16 - Change Charts

Resources

Segment - 26 - Read Spreadsheet Data

Segment - 27 - Store Spreadsheet Data

Segment - 28 - Write to a Text File

Source File

Segment - 55 - Topics Overview

Segment - 56 - Select Case

Segment - 57 - Build a Commission Calculator Project

Segment - 58 - Find Remainder with Mod

Segment - 59 - Check Number Program

123

Segment - 22 - Project Setup

Segment - 23 - Expand Columns to Fit Content

Segment - 24 - Add Dates

Segment - 25 - Add Days of the Week

Source File

Segment - 31 - Build a Stock Chart

Segment - 32 - Build a Doughnut Chart

Segment - 33 - Build a Bubble Chart

Source File

Segment - 11 - Build a Table

Segment - 12 -Style a Table

Segment - 13 - Import Dataset

Segment - 14 - Style a Cell

Segment - 15 - Make a Named Style

Segment - 16 - Copy a Style

Source Files

Segment - 17 - Make a Chart

Segment - 18 - Build Line Charts

Segment - 19 - Build a Pie Chart

Segment - 21 - Build an Area Chart

Segment - 20 - Build a Scatter Chart

Source File

Segment - 03 - Make a Workbook

Segment - 04 - Save a Workbook

Segment - 05 - Work with Rows and Columns

Segment - 06 - Merge and Unmerge Cells

Segment - 07 - Fold a Range

Segment - 08 - Make a New Sheet

Segment - 09 - Copy Data to a Sheet

Segment - 10 - Remove a Sheet

Source File

Segment - 01 - Course Overview

Segment - 02 - Run OpenPyXL on the Web

Source File

Segment - 34 - Import Web Driver

Segment - 35 - Scrape a Web Page

Segment - 36 - Parse Page Data

Segment - 37 - Put Data into Excel Sheet

Segment - 38 - Clean Data

Source File

Segment - 15 - What will we learn in this section

Segment - 16 - Forecast with Scenarios

Segment - 17 - How to Calculate Finance Main KPI's

Segment - 18 - Fixed Asset Roll Forward

Segment - 19 - Loan Schedule

Segment - 20 - AR Management Basics

Segment - 21 - Customer Rank

Segment - 22 - Create Budget Categories

Segment - 23 - Challenge

Source File

Segment - 01 - Course Overview

Instructor bio - John Bura

Segment - 05 - What will we learn in this section

Segment - 06 - Preparing Data Source for P&I

Segment - 07 - Create P&I Structure

Segment - 08 - Adding Data to P&I

Segment - 09 - Calculating Variencies

Segment - 10 - Balance Sheet Structure

Segment - 11 - Adding Values on BS from different Files Format

Segment - 12 - Cash Flow Structure

Segment - 13 - Calculating Cash Flow

Segment - 14 - Challenge

Source File

Segment - 47 - Topics Overview

Segment - 48 - How to Access Excel Functions

Segment - 49 - Disable Screen Updating

Segment - 50 - Write Data to a File

Source File

Segment - 29 - Set up Update Information

Segment - 30 - Update the Spreadsheet

Source File

Segment - 02 - Topics Overview

Segment - 03 - Single Loop

Segment - 04 - Double Loop

Segment - 05 - Triple Loop

Segment - 06 - Do While Loop

Segment - 07 - Build a Commission Table

Source File

Segment - 51 - Topics Overview

Segment - 52 - Build a Table

Segment - 53 - Build a Table of Contents

Segment - 54 - Build a Table of Contents 2

Segment - 55 - Combine Worksheets

Segment - 56 - Combine Worksheets by Column

Source File

Segment - 40 - Topics Overview

Segment - 41 - Delay a Procedure

Segment - 42 - Schedule a Procedure

Segment - 43 - Count Years

Segment - 44 - Count Days between Dates

Segment - 45 - Count Weekdays between Dates

Segment - 46 - Sort Dates

Source File

Segment - 08 - Topics Overview

Segment - 09 - Loop Through Defined Range

Segment - 10 - Loop Through Entire Column

Segment - 11 - Do Until Loop

Segment - 12 - Use Step to Increment

Segment - 13 - Build a Pattern Project

Segment - 14 - How to Sort

Segment - 15 - Sort by Related Data

Segment - 16 - Delete Duplicate Values

Source File

Segment - 24 - Course Summary and Next Steps

Segment - 27 - Topics Overview

Segment - 28 - Make and Use Your Own Function

Segment - 29 - Pass Arguments to a Function

Segment - 30 - Custom Calculator Function

Source File

Segment - 01 - Introduction to the Course

Segment - 02 - Why should you learn Financial Analysis

Segment - 03 - Introduction of the Instructor

Instructor bio - John Bura

Segment - 04 - Course Requirements (what software, experience)

Source File

Segment - 17 - Topics Overview

Segment - 18 - Join Strings

Segment - 19 - Extract Substrings from Left or Right

Segment - 20 - Extract Substring at Middle

Segment - 21 - Get Length of a String

Segment - 22 - Get Substring Position

Segment - 23 - How to Split Strings

Segment - 24 - Reverse Characters

Segment - 25 - Change String Casing

Segment - 26 - Count Words in a Range

Source File

Segment - 31 - Topics Overview

Segment - 32 - One Dimensional Array

Segment - 33 - Two Dimensional Array

Segment - 34 - Change Array Size

Segment - 35 - Build an Array

Segment - 36 - Populate Row with Array

Segment - 37 - Array Length

Segment - 38 - Split String Into an Array

Segment - 39 - Join Array Into a String

Source File

Segment - 57 - Topics Overview

Segment - 58 - Program a Chart

Segment - 59 - Program an Embedded Chart

Segment - 60 - Delete Charts Programmatically

Source File