Microsoft Excel Course In Mumbai
Description of Course
Microsoft Excel Course introduces participants to working with Microsoft Excel, covering the basics such as creating and editing worksheets, formatting them for a professional look, working with formulas to manage routine tasks, etc.
Start mastering Excel, the world-renowned powerful spreadsheet program. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out how to use the IF, VLOOKUP, and COUNTIF family of functions. See how to use data analysis tools, including Goal Seek and Solver. Discover how to automate tasks with macros, manage data, and more.
Detailed Syllabus
- Understanding the Excel screen
- Navigating in a spreadsheet
- Understanding worksheets, columns, rows and cells
- Saving, opening, and closing workbooks
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
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
Editing Features
- Using cut , copy, and paste operations
- Using paste special with values
- Selection techniques
- Navigation techniques
Working with Large Worksheets
- Freezing and unfreezing panes
- Splitting windows
- Inserting page breaks for printing
Working with Charts
- Creating charts using Chart Wizard
- Creating different types of charts
- Including titles and values in charts
- Formatting of charts
Previewing and Printing
- Previewing worksheets
- Page setup
- Printing of worksheets in multiple pages
- Repeating rows and columns for multiple pages
- Printing multiple worksheets
Simple Database Operations
- Sorting tables
- Filtering data with auto filter
- Referring data from other worksheets
Training Details:
- Student WIll Be Allocated 1 Laptop
- Experienced Trainer With 15 Years Of Experience
- Complete Hands-On Training
- Certificate Will Be Provided After Completion Of Training
- Placement Assistance After Course Completion
- 1-2hr of Practical Training
- Certificate of Completion
- 1 Month of Duration
- Job Offer
- 14 Topics
- Roadway to Success
MS Excel Course Details Overview
- MS Excel course allows the students to access face-to-ace practical classes. Each class is of 1-2 hours and is spread over 2 months.
- The course offers weekly assignments, and study material in PDF format for students to refer to and study.
- The course program holds module-wise case studies or projects for interested students.
- After completing the course, students will be given a certificate of completion of MS Excel course which will help them in their future.
