Course Details

AllTechZ Solutions is one of the best Microsoft Excel Macro Training institute in Chennai, located in Velachery provides real time and practical training with industry oriented syllabus in Advanced Excel Training in Velachery, In Chennai. MS Excel is one of the most powerful business tool, widely used in various business sector and allows us to manipulate, manage and analyze data helping assist in decision making and creating efficiencies that will directly affect your bottom line domain today. You will use MS Excel across various functions including Sales, Finance, Marketing, Project Management, HR, Operations, Supply Chain etc.
 

ATS Syllabus for Microsoft Excel Training in Chennai | Microsoft Excel Training in Velachery
EXCEL BASIC OPTIONS

An overview of the Screen, Navigation and Basic Spreadsheet concepts

• Understand Excel terminology Workbooks, Worksheets, Rows, Columns and Cells
• Various Selection techniques
• Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
• Methods to Move, Copy & Paste data
• All the Options in Paste Special and Go To
• Insert, Delete and Hiding Rows & Columns
• Inserting and Deleting ranges Insert, Delete and Move Cells
• Various Navigation techniques Sheet tab formatting and Renaming Copy and Clear Formats and Merge Cells Find, Replace and AutoCorrect
• Various Printing Technique like Page break preview, Headers and footers, Freezing print titles & Data Alignments
• Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
• Uses Conditional Formatting and Auto Formatting
• All Format Cells Options
• Uses of Toolbars and Formula Bar
• Viewing, Adding, Editing and Deleting Comments
• Auditing features and Tracing Formula errors
• Protecting and Sharing Workbook, Worksheet and Cell ranges
• Using Freeze Panes
• Worksheets and Workbooks Calculation method
• Hiding and Displaying Data, Rows, Columns, Worksheet & Workbooks
• Methods to Move and Copy sheets
• Uses of Hyperlinks and Define Name