Contents
- 1 Excel Computer Course in Abul Fazal Enclave, Delhi
- 2 Course Content:
- 3 Course Curriculum
- 4 Why Samantus Web Training Institute For Excel Computer Course in Abul Fazal Enclave
- 5 How this can be beneficial for your career growth?
- 6 General FAQs about the Excel Computer Course in Abul Fazal Enclave, Delhi
Excel Computer Course in Abul Fazal Enclave, Delhi
Welcome to the Samantus Web Training Institute, where we are excited to offer our comprehensive Excel Computer Course in Abul Fazal Enclave. Our course caters to all levels of expertise, whether you’re a beginner or looking to enhance your existing skills. Excel is an incredibly powerful tool, and mastering it can open up numerous opportunities in both your personal and professional lives.
At the Samantus Web Training Institute, we understand the importance of practical, hands-on learning. That’s why our Excel Computer Course is structured to provide you with real-world skills that you can immediately apply. Our experienced instructors are passionate about teaching and committed to helping you succeed. They bring a wealth of knowledge and practical experience, ensuring that you receive the best possible education.
Our course covers a wide range of topics to ensure you gain a thorough understanding of Excel. We start with the basics, including an introduction to the Excel interface, how to navigate through the different menus, and the essential functions and formulas. You’ll learn how to create, edit, and format spreadsheets, making them not only functional but also visually appealing.
As you progress, we’ll delve into more advanced topics such as data analysis, pivot tables, and complex formulas. You’ll learn how to use Excel to sort and filter data, create charts and graphs, and automate tasks with macros. Our course also includes lessons on data validation, conditional formatting, and how to protect your workbooks to ensure data integrity.
The practical projects you’ll undertake are one of the highlights of our Excel Computer Course. We design these projects to simulate real-world scenarios, allowing you to apply your learned skills in a practical setting. By the end of the course, you’ll have a portfolio of work that demonstrates your proficiency in Excel, which can be a valuable asset when applying for jobs or seeking promotions.
At Samantus Web Training Institute, we believe in providing a supportive learning environment. Our small class sizes ensure that you receive personalised attention from your instructor. If you ever have questions or need extra help, our team is always available to provide assistance. We also offer flexible scheduling options to accommodate your busy lifestyle, including evening and weekend classes.
We are conveniently located in Abul Fazal Enclave, making it easy for residents in the area to attend our courses. The latest technology equips our modern facilities, creating a comfortable and conducive learning environment. Additionally, we offer online resources and support, so you can continue your learning even outside of the classroom.
Enrolling in our Excel Computer Course at Samantus Web Training Institute is an investment in your future. Excel skills are highly sought-after in many industries, and having a solid understanding of this powerful tool can give you a competitive edge in the job market. Whether you’re looking to enhance your career prospects, improve your productivity, or simply learn something new, our course has something for everyone.
We invite you to join us at the Samantus Web Training Institute and take the first step towards mastering Excel. Our friendly staff is here to answer any questions you may have and help you with the enrollment process. We look forward to welcoming you to our community and helping you achieve your learning goals.
Course Content:
Excel Shortcuts,
Hidden Tricks and Settings,
Lookup Formulas,
Logical Functions,
Data Cleaning,
Pivot Table,
Conditional Aggregation and Formatting
If Analysis,
Report Consolidation,
VLOOKUP,
SUMIF,
COUNTIF,
IFS & SWITCH,
XLOOKUP,
And many more
Course Curriculum
Course Curriculum
- Introduction to MS Excel
- Excel Shortcuts
- Hidden Tricks & Settings
- Lookup Formulas
- Logical Functions
- Data Cleaning
- Pivot Table
- Conditional Aggregation & Formatting
- If Analysis
- Report Consolidation
- VLOOKUP, SUMIF, COUNTIF, IFS & SWITCH, XLOOKUP
- Basics of Macros (VBA) & Macros
PART-1: Computer Fundamentals
- Introduction to computers and their components
- Operating system and its types
- Computer networks and the internet
- Computer security and safety
- Basic troubleshooting techniques
PART-2: Typing Speed (On Typing Master)
- Introduction to touch typing
- Typing exercises to improve speed and accuracy
- Special characters and symbols
- Formatting and alignment
- Typing with numerical data
PART-3: Notepad Paint and WordPad
- Paint
- NotePad
- WordPad
PART-4: Basic + Advance MS Word
- Introduction to Word and its Interface
- Creating, formatting, and editing documents
- Inserting and formatting images, shapes, and charts
- Working with tables, columns, and headers/footers
- Mail merging and automation tools
PART-5: Basic + Advance MS Excel
- Introduction to Excel and its interface
- Working with formulas and functions
- Formatting and styling cells and data
- Creating and modifying charts and graphs
- Advanced data analysis techniques
PART-6: Basic + Advance MS Powerpoint
- Introduction to PowerPoint and its interface
- Creating, formatting, and editing presentations
- Inserting and formatting multimedia elements
- Creating and editing slide masters and layouts
- Advanced presentation techniques and animation effects
PART-7: Basic + Advanced MS Outlook
- Introduction to Outlook and its Interface
- Managing emails, calendars, and contacts
- Creating and formatting emails and signatures
- Automating emails with rules and templates
- Advanced email management and organization
PART-8: Internet (Browser, Surfing, Email, Downloading, Form Filling, Ticketing, Etc.)
- Introduction to the Internet and its Uses
- Browsing and searching techniques
- Managing emails and attachments
- Downloading and uploading files
- Filling out online forms and booking tickets
Part-9: Excel Master Class (EMC)
- Excels Shortcuts
- Hidden Tricks & Settings
- Lookup Formulas
- Logical Functions
- Data Cleaning
- Pivot Table
- Conditional Aggregation & Formatting
- If Analysis
- Report Consolidation
- VLOOKUP, SUMIF, COUNTIF
- IFS & SWITCH
- XLOOKUP & Many More.
PART-1: Introduction
- Introduction to computers and their components
- Operating system and its types
- Computer networks and internet
- Computer security and safety
- Basic troubleshooting techniques
PART-2: Typing Speed (On Typing Master)
- Introduction to touch typing
- Typing exercises to improve speed and accuracy
- Special characters and symbols
- Formatting and alignment
- Typing with numerical data
PART-3: Notepad Paint and WordPad
- Paint
- NotePad
- WordPad
PART-4: Basic MS Word
- Introduction to Word and its Interface
- Creating, formatting, and editing documents
- Inserting and formatting images, shapes, and charts
- Working with tables, columns, and headers/footers
PART-5: Basic MS Excel
- Introduction to Excel and its interface
- Working with formulas and functions
- Formatting and styling cells and data
- Creating and modifying charts and graphs
PART-6: Internet (Browser, Surfing, Email, Downloading, Form Filling, Ticketing, Etc.)
- Introduction to the Internet and its Uses
- Browsing and searching techniques
- Managing emails and attachments
- Filling out online forms and booking tickets
Course Curriculum:
- Basics of Accounting
- Fundamentals of Tally ERP 9
- Getting Functional with Tally ERP 9
- Creation / Setting up of Company in Tally ERP 9
- Accounting & Inventory Masters
- F11: Features
- F12: Configurations
- Voucher Entry in Tally ERP 9
- Master Creation in Tally
- Accounting Voucher
- Inventory Voucher
- Invoicing
- Inventory in Tally ERP 9
- Stock Group
- Stock Categories
- Godown /Locations
- Understanding the concept of unit of measure (UOM)
- Stock Items
- Creating Inventory Masters
- Inventory in Tally ERP 9
- Stock Group
- Stock Categories
- Godown /Locations
- Advance Accounting in Tally ERP 9
- Bill wise Details
- Cost Centers & Cost Categories
- Bank Reconciliation
- Interest Calculation
- Voucher Types Method
- Maintain Bill Wise Details
- Point of Sale ( PoS)
- Features of Point of Sales (PoS) in Tally. ERP9
- Configuration Point of Sale in Tally. ERP 9
- POS Reports
- Payroll Accounting
- Introduction of Payroll
- Creating Payroll Masters.
- Process Payroll in Tally ERP 9
- Accounting for Employer PF Contributions
- Accounting for Employees’ PF Contributions
- Generating Payroll Reports
- GST in Accounting
- Introduction of GST
- Types & Rates under GST
- Invoicing Method in GST
- Debit & Credit Note under GST
- Calculation Summarized on GST
- Preparation of Final GST Report
- GST Return (Types & Payment)
- How to Generate E-Way Bill System
- How to Check & Confirm Parties under GST Registration
- TDS – Tax Deducted at Source
- Introduction of TDS
- Rate & Calculation of TDS
- Section & Rates of TDS Deduction
- Entry Book with TDS on Invoicing
- TDS Deposited
- TDS Return Type & Due Dates
Course Curriculum:
- Introduction to Graphic Design
- Understanding the concept of Graphic Design
- History of Graphic Design
- Elements of Graphic Design
- Principles of Graphic Design
- CorelDraw
- Introduction to CorelDraw
- The interface of CorelDraw
- Working with Layers
- Basic Tools in CorelDraw
- Advanced Tools in CorelDraw
- Creating and Editing Shapes and Objects
- Working with Text and Typography
- Designing Logos and Business Cards
- CorelDraw tools and features
- Designing Posters and Flyers
- Photoshop
- Introduction to Photoshop
- Interface of Photoshop
- Basic Tools in Photoshop
- Advanced Tools in Photoshop
- Working with Layers
- Colour Correction and Enhancement
- Photo Manipulation and Retouching
- Designing Web Graphics and Banners
- Designing Social Media Graphics
- Canva
- Introduction to Canva
- The interface of Canva
- Basic Tools in Canva
- Advanced Tools in Canva
- Designing Social Media Graphics
- Designing Presentations and Infographics
- Designing Marketing Materials
- Collaboration and Sharing
- Motion Graphics
- Introduction to Motion Graphics
- Principles of Motion Graphics
- Basics of Animation
Course Curriculum:
- Introduction to Graphic Design
- Understanding the concept of Graphic Design
- History of Graphic Design
- Elements of Graphic Design
- Principles of Graphic Design
- CorelDraw
- Introduction to CorelDraw
- The interface of CorelDraw
- Working with Layers
- Basic Tools in CorelDraw
- Advanced Tools in CorelDraw
- Creating and Editing Shapes and Objects
- Working with Text and Typography
- Designing Logos and Business Cards
- CorelDraw tools and features
- Designing Posters and Flyers
- Photoshop
- Introduction to Photoshop
- Interface of Photoshop
- Basic Tools in Photoshop
- Advanced Tools in Photoshop
- Working with Layers
- Colour Correction and Enhancement
- Photo Manipulation and Retouching
- Designing Web Graphics and Banners
- Designing Social Media Graphics
- Canva
- Introduction to Canva
- The interface of Canva
- Basic Tools in Canva
- Advanced Tools in Canva
- Designing Social Media Graphics
- Designing Presentations and Infographics
- Designing Marketing Materials
- Collaboration and Sharing
- Motion Graphics
- Introduction to Motion Graphics
- Principles of Motion Graphics
- Basics of Animation
- Adobe Illustrator
- Introduction to Adobe Illustrator
- The interface of Adobe Illustrator
- Working with Objects in Adobe Illustrator
- Working with Colors and Gradients
- Working with Typography
- Creating Logos and
- IconsCreating Illustrations and Infographics
- Creating Illustrations and Infographics
- Adobe InDesign
- Introduction to Adobe InDesign
- The interface of Adobe InDesign
Working with Text - Working with Objects and Graphics
- Working with Color and Effects
- Master Pages and Layouts
- Creating Books and Interactive Documents
- Introduction to Video Editing
- What is Video Editing and how it works?
- Understanding video editing and its applications
- Types of video formats and codecs
- Basic video editing terminologies and concepts
- Workflow of the video editing process
- Filmora Pro
- Introduction to Filmora Pro
- Basic editing techniques
- Advanced editing techniques
- Audio editing
- Exporting the final video
- OBS Studio
- Introduction to OBS Studio
- Setting up scenes and transitions
- Audio and video settings
- Streaming and recording
- InVideo
- Introduction to InVideo
- Basic video editing
- Advanced video editing
- Audio editing
- Exporting the final video
- Camtasia
- Introduction to Camtasia
- Basic editing techniques
- Advanced editing techniques
- Audio editing Methods and techniques
- Exporting the final video
- Video Editing in Canva
- Introduction to Canva
- Designing graphics and layouts
- Using templates and elements
Exporting and sharing designs
- VideoScribe/White Board Animation
- Introduction to VideoScribe/White Board Animation
- Creating animated videos
- Using sound and music
- Exporting the final video
- Introduction to Video Editing
- What is Video Editing and how it works?
- Understanding video editing and its applications
- Types of video formats and codecs
- Basic video editing terminologies and concepts
- Workflow of the video editing process
- Adobe Premiere Pro
- Introduction to Adobe Premiere Pro interface
- Importing media files and organizing assets
- Basic editing techniques such as trimming, cutting, and splitting clips
- Applying transitions, effects, and audio enhancements
- Creating and editing titles and captions
- Colour correction and grading
- Adobe After Effects
- Introduction to Adobe After Effects interface
- Creating and animating text and graphics
- Working with layers and compositions
- Applying effects and transitions
- Keyframe animation and motion graphics
- Tracking and stabilization
- DaVinci Resolve
- Introduction to DaVinci Resolve interface
- Colour correction and grading using the Color Page
- Editing techniques such as trimming, cutting, and splitting clips on the Edit Page
- Creating visual effects and motion graphics using Fusion
- Audio editing and mixing
- Exporting and rendering the final output
- Visual Effects (VFX)
- Introduction to VFX and its applications
- Basic VFX terminology and concepts
- Working with green screen footage
- Creating and compositing 3D elements
- Adding and tracking special effects
- Colour Correction and Grading
- Understanding colour theory and colour grading concepts
- Using scopes and waveform monitors for colour correction
- Adjusting contrast, saturation, and hue
- Creating different looks and styles using LUTs (Look-Up Tables)
- Matching colour between shots and clips.
- OBS Studio
- Introduction to OBS Studio
- Setting up scenes and transitions
- Audio and video settings
- Streaming and recording
- InVideo
- Introduction to InVideo
- Basic video editing
- Advanced video editing
- Audio editing
- Exporting the final video
- Camtasia
- Introduction to Camtasia
- Basic editing techniques
- Advanced editing techniques
- Audio editing Methods and techniques
- Exporting the final video
- Video Editing in Canva
- Introduction to Canva
- Designing graphics and layouts
- Using templates and elements
Exporting and sharing designs
- VideoScribe/White Board Animation
- Introduction to VideoScribe/White Board Animation
- Creating animated videos
- Using sound and music
- Exporting the final video