Excel Training Courses

Excel Training Courses

Duration : 20 Hours

Excel is one of the most popular software applications in the world and is used by firms in almost every industry, from pizza parlors to private equity. Companies, educational institutions, and government agencies all use Excel to manage and analyze data, create spreadsheets and reports, print charts, and much more. It’s no wonder why a working knowledge of this spreadsheet software is an essential skill for people who spend part of their workday in front of a computer, even for those that do not necessarily have an accounting or finance-related careers. Thus Excel skills are in demand, and its no surprise people with Excel knowledge are earning more money than their counterparts. Excel Training Courses are best to start with in computer industry.

Target Audience – Excel Training Courses

  • Undergraduate, Graduates and Post-Graduates
  • Job aspirants

Pre-requisites – Excel Training Courses

  • Basic Computer
  • Basic Internet

Recommended Next Course – Excel Training Courses

  • Commercial Accountant
  • Digital Marketing
  • Advanced Excel

Complete Course Contents – Excel Training Courses

Module 1: Getting Started
Understanding the Excel screen
Navigating in a spreadsheet
Understanding worksheets, columns, rows and cells
Saving, opening, and closing workbooks
Module 2: Formatting a Spreadsheet
Changing column widths and row heights
Changing alignment of cells
Undoing and redoing actions
Formatting numbers , Clearing formats , Applying borders to cells, Merging cells
Module 3: Formulas and Functions
Entering formulas
Copying data and formulas
Using AutoSum
Understanding functions
Using simple aggregate functions (Sum, Count, Average, Min, Max)
Copying formulas
Applying conditions in a formula (The IF function)
Working with ranges
Module 4: Editing Features
Using cut , copy, and paste operations
Using paste special with values
Selection techniques
Navigation techniques
Module 5: Working with Large Worksheets
Freezing and unfreezing panes
Splitting windows
Inserting page breaks for printing
Module 6: Working with Charts
Creating charts using Chart Wizard
Creating different types of charts
Including titles and values in charts
Formatting of charts
Module 7: Previewing and Printing
Previewing worksheets
Page setup
Printing of worksheets in multiple pages
Repeating rows and columns for multiple pages
Printing multiple worksheets
Module 8: Simple Database Operations
Sorting tables
Filtering data with auto filter
Referring data from other worksheets

Certifications & Affiliations

Image

Why SAMYAK ?

• Registered LLC Company in Florida, USA
• Presence in Dubai & Many States / Cities across India.
• An ISO 9001:2015 Certified Company
• GOOGLE & HP Certification Partner
• Authorized Tally Institution of Learning from Tally Company (HO)
• Authorized Microsoft, AutoDesk, Adobe, Apple, EC-Council & Unity Testing & Certification Partner
• Pearson Testing Centre – Oracle, Cisco, Salesforce, AWS, RedHat & ALL IT Giant’s Certification Partner.
• 17+ Branches Worldwide & Growing ...
• Dedicated IT team of 200+ working on International Level Projects

International CERTIFICATIONS with Live Projects

• Samyak believes in employability and hence Samyak provides training with less theory and more of Practical work.

• Course modules are prepared by Expert IT Professionals & HR.

• 100% Placement Assistance. We have good track record of placements.

• Samyak has 450+ Computers, Switches, Routers, PLCs, Hardware and Software AND has enormous in-house projects to support the project based training.

• Being in multiple locations across the Globe, Samyak allows students to take transfer in needed circumstances.

• Highest Rating ( Google, Facebook, Justdial & Others) & Global Rewards in Education Sector.

Click To Fix An Appointment