Core Excel Skills
Overview
This journey includes:
- 15 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
Skills You Will Gain
Learning Outcomes (At the end of this program you will be able to)
- Understand and navigate Excel
- Use the full array of Excel functions
- Create charts, graphs, and visualizations in Excel
- Build Pivot Tables to analyze data in Excel
- Conduct both simple and complex financial analyses using Excel
- Perform robust data analysis using Excel
Who Should Attend
Anyone interested in learning the core features and functions of Excel, and applying these skills in practical settings.
Curriculum
Introduction to Excel
Excel Functions
Excel Charts and Visualization
Excel Financial Analysis
Excel Pivot Tables
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.
1Welcome to the course!
Instructor bio - John Bura
2Course Content
Segment - 01 - Introduction to Excel
Segment - 02 - Introduction to Graphs
Segment - 03 - Adding in Multiple Sheets
Segment - 04 - Making a Simple but Effective Income Statement
Segment - 05 - Making a Productive Chart in Excel
Segment - 06 - Making a Budget
This course is a comprehensive overview of what effective business analysts really do - their strategies, techniques, tools and methods – all which apply to any process whether it’s a traditional large project, and Agile or DevOps project.
1Welcome to the course!
Instructor bio - John Bura
2Module One
Segment - 01 - Introduction to the Course
Segment - 02 - Introduction of the Instructor
Segment - 03 - Course Requirements
Segment - 04 - How to get Excel
3Module Two
Segment - 05 - What will we learn in this section
Segment - 06 - Create an if() Function
Segment - 07- nest and() and or() Functions within Reference Functions
Segment - 08 - Work with choose() , vlookup() ,Index() ,and match() Functions
Segment - 09 - Create a vlookup() function
Segment - 10 - Section Summary
4Module Three
Segment - 11 - What will we learn in this section
Segment - 12 - Aggregate Data using both the Sum and Subtotal Functions
Segment - 13 - Calculate Minimums, Maximums and Averages from Data sets
Segment - 14 - Use the Forecast Function to Forecast numbers along a Trend
Segment - 15 - Generate a Net Present Value using a Formula
Segment - 16 - Section Summary
5Module Four
Segment - 17 - What will we learn in this section
Segment - 18 - Work with Excel’s Date Manipulation Functions
Segment - 19 - Build a Holiday Date Calculator
Segment - 20 - Section Summary
6Module Five
Segment - 21 - What will we learn in this section
Segment - 22 - Split Textual Data Apart
Segment - 23 - Manipulate Textual Data
Segment - 24 - Replace Portions of Textual Data
Segment - 25 - Put Textual Data Back Together With Formulae
Segment - 26 - Work with Key Informational Functions For Evaluating and Responding Correctly to Errors in Routine Excel Calculations
Segment - 27 - Use the Hyperlink Function to Build Navigational Menus Inside an Excel Worksheet
Segment - 28 - Section Summary
7Module Six
Segment - 29 - What will we learn in this section
Segment - 30 - How to Filter Items in a List
Segment - 31 - Sorting List Without Messing up the Data
Segment - 32 - How to Freeze Rows or Columns
Segment - 33 - Remove Duplicates from a List
Segment - 34 - Section Summary
8Module Seven
Segment - 35 - What will we learn in this section
Segment - 36 - Count, Counta and Countif Functions
Segment - 37 - Create a Drop Down List
Segment - 38 - Work with Isnumber and Search Functions within Text Functions
Segment - 39 - Format Row Based on a Cell Value
Segment - 40 - Create an Invoice Template in Excel
Segment - 41 - Section Summary
Segment - 42 - Course Summary and Next Steps
This course helps you understand how to use Excel to build a myriad of interesting charts, starting with the basics and moving up to some of the most complex charts imaginable.
1Welcome to the course!
Instructor bio - John Bura
2Module 01: Introduction to the Course
Segment - 01 - Introduction to the Course
Segment - 02 - Why should you learn about Charts and Data Visualization
Segment - 03 - Introduction of the Instructor
Segment - 04 - Course Requirements (what software, experience)
3Module 02: Charts and Basics
Segment - 05 - What will we learn in this section
Segment - 06 - Main Principles and Chart Visualization Impact
Segment - 07 - Choosing the Correct Chart
Segment - 08 - Communicate with the End User
Segment - 09 - Section Summary
Segment - 10 - Challenge
4Module 03: Excel Chart Tools
Segment - 12 - Chart Design
Segment - 13 - Working with Chart Formats
Segment - 14 - Chart Types
Segment - 15 - Primary and Secondary Axis
Segment - 15A
Segment - 16 - Chart Templates
Segment - 17 - Section Summary
Segment - 18 - Challenge
5Module 04: Working with Basic Excel Charts & Graphs
Segment - 19 - What will we learn in this section
Segment - 20 - Excel Column Charts
Segment - 21 - Column Charts Challenge
Segment - 22 - Excel Bar Charts
Segment - 23 - Excel Bar Charts 1
Segment - 24 - Bar Charts Challenge
Segment - 25 - Excel Line Charts
Segment - 26 - Line Charts Challenge
Segment - 27 - Excel Pie Charts
Segment - 28 - Pie Charts Challenge
Segment - 29 - Excel Area Charts
Segment - 30 - Area Charts Challenge
Segment - 31 - Excel Scatter Charts
Segment - 32 - Scatter Charts Challenge
Segment - 33 - Excel Bubble Charts
Segment - 34 - Bubble Charts Challenge
Segment - 35 - Excel Stock Charts
Segment - 36 - Stock Charts Challenge
Segment - 37 - Excel Surface Charts
Segment - 38 - Surface Charts Challenge
Segment - 39 - Excel Radar Charts
Segment - 40 - Radar Charts Challenge
Segment - 41 - Excel Treemap Charts
Segment - 42 - Treemap Charts Challenge
Segment - 43 - Excel Sunburst Charts
Segment - 44 - Sunburn Charts Challenge
Segment - 45 - Excel Histogram and Pareto Charts
Segment - 46 - Histogram and Pareto Charts Challenge
Segment - 47 - Excel Waterfall Charts
Segment - 48 - Waterfall Charts Challenge
Segment - 49 - Excel Box & Whisker Charts
Segment - 51 - Excel Sparklines
Segment - 52 - Sparklines Challenge
Segment - 53 - Excel Color Scales
Segment - 54 - Color Scales Challenge
Segment - 55 - Excel 3D Map
Segment - 56 - 3D Map Challenge
Segment - 57 - Section Summary
6Module 05: Excel Advanced Data Visualization
Segment - 58 - What will we learn in this section
Segment - 59 - Data Visualization with Pivot Chart and Slicers
Segment - 60 - Data Visualization with Pivot Chart and Slicers Challenge
Segment - 61 - Create Break Even Chart
Segment - 62 - Challenge Create Break Even Chart
Segment - 63 - Rating Star Chart
Segment - 64 - Challenge Rating Star Chart
Segment - 65 - Drop Down Menu for Chart
Segment - 66 - Challenge Drop Down Menu for Chart
Segment - 67 - Risk Score Chart
Segment - 68 - Risk Score Chart Challenge
Segment - 69 - Dynamic Chart Update
Segment - 70 - Challenge Dynamic Chart Update
Segment - 71 - Section Summary
7Module 06: Conclusion
Segment - 72 - Course Summary and Next Steps
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.
1Module 01: Introduction to the Course
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
2Module 02: Excel Statement Models
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
3Module 03: Excel Finance Methods
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
4Module 04: Conclusion
Segment - 24 - Course Summary and Next Steps
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.
1Welcome to the course!
Instructor bio - John Bura
2Module 01: Introduction to the Course
Segment - 01 - Introduction to the Course
Segment - 02 - Why should you learn Pivot Tables
Segment - 03 - Introduction of the Instructor
Segment - 04 - Course Requirements (what software, experience)
Source File
3Module 02: PivotTables Fundamental Projects
Segment - 05 - What will we learn in this section
Segment - 06 - What is a Pivot Table
Segment - 07 - Pivot Table Basics
Segment - 08 - Pivot Table Compilant Data Sources
Segment - 09 - Build a Basic Pivot Table
Segment - 10 - Section Summary
Segment - 11 - Challenge
Source File
4Module 03: Format Pivot Tables
Segment - 12 - What will we learn in this section
Segment - 13 - Introduction to Formatting Pivot Tables
Segment - 14 - Build an Expense Report
Segment - 15 - Format the Expense Report Pivot Table
Segment - 16 - Finalize the Expense Report Pivot Table
Segment - 17 - Section Summary
Segment - 18 - Challenge
Source File
5Module 04: Excel Tables
Segment - 19 - What will we learn in this section
Segment - 20 - What are Excel Tables
Segment - 21 - Sales Report Analysis
Segment - 22 - Complete the Sales Report Analysis
Segment - 23 - Format the Sales Report
Segment - 24 - Modify Source Data
Segment - 25 - Section Summary
Segment - 26 - Challenge
Source File
6Module 05: Slice and Dice Your Data
Segment - 27 - What will we learn in this section
Segment - 28 - What is Slicing Data
Segment - 29 - Slicing Data Project
Segment - 30 - Data Slicer Tools
Segment - 31 - Links Slicer to Multiple Pivot Tables
Segment - 32 - Section Summary
Segment - 33 - Challenge
Source File
7Module 06: Connect to Databases
Segment - 34 - What will we learn in this section
Segment - 35 - Connect to Databases
Segment - 36 - Import Data Sources
Segment - 37 - Use Pivot Tables to Refine Data
Segment - 38 - Consolidate your Data Table
Segment - 39 - Format Large Data Sets
Segment - 40 - Slicer and Timeline in Large Data Sets
Segment - 41 - Refresh and Drill Down from Databases
Segment - 42 - Section Summary
Segment - 43 - Challenge
Source File
Instructors
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.
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.