Excel Functions
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.
Overview
This course includes:
- 5+ hours of on-demand video
- 7 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)
Prerequisites
None other than a basic understanding of computers
Who Should Attend
Anyone interested in learning the core features and functions of Excel, and applying these skills in practical settings.
Curriculum
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
Instructors
John Bura
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.