MS Excel Training
MS Excel Training in Chennai
Description
Learn MS Excel with Skifter Technology in Chennai! Our training is perfect for beginners and professionals who want to master Excel skills, from basic functions to advanced tools like PivotTables and Macros. Gain hands-on experience and real-world knowledge to simplify your work, analyze data, and boost productivity.
Join us and become an Excel expert with Skifter Technology!
- A overview of the screen, navigation and basic spreadsheet concepts
- Understanding workbooks, worksheets, rows, columns, cells
- Various selection techniques
- Entering, Editing and Deleting Text, Numbers, Dates
- Using Auto Lists
- Moving and Copying data
- Using navigation techniques
- Using Workbook Views
- Selecting and Switching Between Worksheets
- Understanding & working rows, columns and worksheets
- Concept of Formulae
- Creating Formulae, Editing Formulae
- Bodmas : Mathematical Order
- Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
- Basic conditional formatting
- Working with Styles
- Create worksheets and workbooks
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Customise options and views for worksheets and workbooks
- Configure worksheets and workbooks for distribution/li>
- Insert data in cells and ranges
- Format cells and ranges
- Summarise and organise data
- Using different filtering techniques
- Create and manage tables
- Manage table styles and options
- Filter and sort a table
- Advanced paste special techniques
- Summarise data by using functions
- Perform conditional operations by using functions
- Logical functions
- Math functions
- Lookup functions
- Date & Time functions
- Create charts
- Format graphic elements
- Insert and format objects
- Manage workbooks
- Manage workbook review
- Apply custom data formats and validation
- Apply advanced conditional formatting and filtering
- Create and modify custom workbook elements
- Different levels of protection
- Setting permission & track changes
- Prepare a workbook for global standards
- Apply math functions in formulas
- Look up data by using functions
- Advanced logical & text functions
- Apply advanced date and time functions
- Perform data analysis and business intelligence
- Troubleshoot formulas using error handling functions
- Define named ranges and objects
- Create advanced charts
- Create and manage PivotTables
- Create and manage PivotCharts
- Bar Charts / Pie Charts / Line Charts
- Planning a Dashboard
- Adding Tables to Dashboard
- Adding Charts to Dashboard
- Adding Dynamic Contents to Dashboard