Excel-Resturant Billing System Using Excel VBA with Currency Converter | Pardeep Sharma | Skillshare

Excel-Resturant Billing System Using Excel VBA with Currency Converter

Pardeep Sharma

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Videos (2h 47m)
    • Introduction of Excel VBA Enviournment

      6:35
    • Project Introduction Session

      8:58
    • Session 1 How to Save Project As Macro Enabled Workbook

      10:04
    • Session 2 Designing of Interface Part 1

      10:22
    • Session 3 Designing of Interface Part 2

      10:31
    • Session 4 Designing of Final Interface

      13:22
    • Session 5 Activate Billing Calculator

      14:33
    • Session 6 Activate Currency Converter

      14:33
    • Session 7 Activate Currency Converter Part 2

      11:44
    • Session 8 Use of Checkbox And Textbox

      5:47
    • Session 9 How To Activate Drinks Option Part 1

      14:06
    • Session 10 How To Activate Drinks Option Part 2

      5:29
    • Session 11 How To Activate Tax And Home Delivery

      9:46
    • Session 12 How To Activate Subtotal and Total

      7:16
    • Session 13 How To Reset All Option

      6:08
    • Session 14 How To Display Date and Activate Exit Button

      5:05
    • Session 15 How To Maintain the Bills Record

      12:35

About This Class

Design Simple Billing System Using Excel VBA. The Project will cover the 
• Macro Enabled Workbook
• Designing of Simple Billing System along with Currency Converter
The course is designed for individuals and office professionals who need to master the capabilities of the Microsoft Excel VBA. Through the video lectures you'll learn the usage of Ms-Excel VBA Step by step and also design one small project with the help of VBA tools.
Become an Ms-Excel VBA user. 

We start at the project from very beginning progressing with more than helpful videos.
All you need for work Excel VBA User Forms, Frame, Combo box, and other tools feel confident with every aspect of Excel VBA.

• Designed to help beginners get started
• Lessons start right at the very beginning
• Progresses slowly with more than 20 helpful videos
• A big 2 hours 39 Minutes of expert instruction
• Learn How to Work in Ms-Excel VBA
• Master the most common uses of Ms-Excel VBA
• Learn How to create project in Excel VBA
• Use the full palette of functions
• Experienced users can fill in gaps in knowledge
• Work faster with better results and greater confidence
• Discover how to create Simple Attendance Register With Help of Excel VBA


Now you can learn Ms-Excel VBA from the very beginning. Beautifully designed for beginners to get a great start while helping more experienced users fill in any gaps in their knowledge. You enjoy expert tutorial videos that clearly show you how to accomplish every aspect of Ms-Excel VBA.


This course is just what you want for being confident with Excel VBA in the workplace. Also gives you everything you need to know for personal use.
The self-learning video format lets you study on your own schedule. Watch videos as you have time, then come back to learn more later.

At the end of the project user is able to design and save the enter order details in Microsoft Excel Worksheet and also able to convert the currency amount based on their requirement. Now you can become a master at using one of the world's most popular computer applications – Microsoft Excel VBA.

Who is the target audience?
• Anyone new to Microsoft Excel or having basic working knowledge of Ms-Excel

Audience & Course Joiner Reviews

  • Top of Form
  • Bottom of Form

·       This is a really good course if you plan to do some pretty complex VBA code with User forms. Many thanks for making this course available and I will look for more courses from him.

ST

Suresh Thavalingam

·       The lecture is quite clear and it is easy to understand the programming.

SR

Subramanian Ramajayam

·       The video tutor had a good grasp of the lesson content. He was also systematic in his approach which made it easier for me to follow. I am abundantly grateful for this tutorial.

EO

Enoch Opolot

·       Useful!

SR

Siva Ram

·       Normally I see basic setup are done behind the scenes and they just show the screenshots. But Mr Pradeep taking us through each step which is very informative and easy to follow.

H

Harish

·       Nicely explained

AB

Abhijit Biswas

·       This course is must for everybody, for practical approach of VBA, please create MS Access VBA course trading(small) unit, so that it would be an excellent one. It is fast teaching, be bit slow and up-to the point.

PA

Prakash a

·       Many thanks, your course is very useful

·       الف شكر ، الكورس مفيد جدا

MA

Mohamed Amin

Fantastic!

·       Very clear and helpful

NM

Ng Khai Meng

·       It was an eye opener for me to coding with Excel.

AH

Abdullah Hussein

8

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Hello, I'm Pardeep.

See full profile

Report class