MS Excel: Tips and Tricks
Opis
Boost your productivity and efficiency in Excel with our "MS Excel: Tips & Tricks" course.
This training focuses on small yet powerful features of Excel that can significantly speed up your workflow. Learn essential hot-key combinations, data manipulation techniques, advanced conditional formatting, and more. Discover innovative ways to use traditional functions and explore various chart types for dashboards. This course is perfect for Excel users looking to enhance their skills with practical tips and tricks.
This course covers a range of advanced Excel features and techniques and is divided into seven detailed modules:
- Hot Keys
- Manage Workbooks & Worksheets
- Entering Data
- Formatting Data
- Formulas & Functions
- Charts
- Power Query Editor
By the end of this course, participants will be able to:
- Utilize hot-key combinations to increase productivity.
- Manage and customize workbooks and worksheets efficiently.
- Enter and manipulate data using advanced techniques.
- Apply advanced formatting options to enhance data presentation.
- Use a variety of advanced formulas and functions creatively.
- Create and customize a range of charts for insightful data visualization.
- Perform advanced data transformations using Power Query Editor.
Participants will gain practical skills to perform tasks more efficiently in Excel, making their workflow faster and more productive. This course will empower participants to leverage Excel's full potential with various tips and tricks.
wydawany jest certyfikat
Cele
Participants are expected to demonstrate correct application of the advanced features of MS Excel and complete tasks independently.
Grupa docelowa
Anyone interested in the topic.
Warunki wstępne
OFFICE-009, OFFICE-010
Plan działania
1. Hot Keys (1 hour)
2. Manage workbooks & worksheets (2 hour):
− Excel Customization, windows positioning, workbook protection,
3. Entering data (1 hour):
− Clipboard, user form, data transformation (flash fill, text-to-columns), data consolidation, drop-down list
4. Formatting data (2 hour):
− Custom styles, formulas in conditional formatting, check list, autoformat, format painter
5. Formulas & functions (3 hours):
− COUNTIFS, SUMIFS, DSUM, DCOUNT, DAVERAGE, VLOOKUP, XLOOKUP, FILTER, SORT, SORTBY, UNIQUE, CHOOSECOLS, VSTACK, HSTACK, DATEDIF
6. Charts (3 hours):
− Pictograph Chart, Interactive charts, Waffle Chart, Speedometer, Thermometer, Plan-Fact Chart, Timeline, Forecast
7. Power Query Editor (3 hours)