CC is organizing an online training session for institute staff members on Microsoft Excel and Word. Training will be given by experts from Microsoft.
Date: 30 May 2023
Time: 11:00 AM (will last approx. 2 hours, including clarifications of doubts)
Registration Link: https://msit.events.teams.microsoft.com/event/cc111257-3e97-4490-8060-9a480b1ff185@72f988bf-86f1-41af-91ab-2d7cd011db47
Contents covered in the training session:
Excel Advanced Features
- Excel start Screen Explanations (Format Painter, Wrap Text, Merge Center, Border Creation, Indenting, Alignment, Cell Style Creation, Freezing Panes, Transposing, Print Preview)
- Statistical Data Analysis with Excel (Moving Average, Hypothesis, Anova, Covariance, Correlation, Regression, Multi Linear Regression, Logistic regression, Normal Distribution, Histogram, Descriptive Statistics)
- Macros Usage in Excel (Mean, Correlation, Duplicate Removal)
- Conditional Formatting, Flash fill, Custom Sorting, Subtotal creation, and Data Validation.
- Data Chart and Sparklines creation and visualization
- VLOOKUP, XLOOKUP
- Pivot Table creation and Slicers in Excel
- Few Excel formulas with use cases discussion.
Word Advanced Features
- Microsoft Word Start Screen Tools description and text formatting.
- Paragraph layout, Shading, and Borders
- Page design, Style
- AI features in word
- Special Symbol, table, and Image Insertion in Word
- Header and footer creation in word
- Creating Table of Content and Translating Documents
- Document Track Change option
- Auto Formatting and Dictation feature in Word document
- Mail Merge Using Word to send bulk mail.