Рет қаралды 427
You are welcome to Banahene Tutorial Collections. This wonderful channel is about computer techniques and training on Microsoft office applications. As an ICT teacher and trainer, I do have the passion to share my IT ideas with people. #excel #worksheets #microsoftexcel
This ddeep dive tutorial is going cover all that you need to understand Excel worksheets. I will be showing the operations needed to have much control over your Excel workbook. This tutorial is a complete footage. Let's get straight to it. Below are timestamps
00:00 Introduction
00:30 Microsoft Excel Worksheet Overview
01:25 Excel Sheet Tab
02:07 Customize Excel Sheet Tab
05:25 Rename Excel Worksheets
08:28 Insert Excel Worksheets
12:37 Arrange Created Worksheets
15:42 Duplicate Created Worksheets
21:41 Revealing Worksheets on Sheet Tab
24:00 View Excel Worksheets Code
25:30 How to Protect Excel Worksheets
31:53 Apply Color Scheme to Worksheets
34:11 Hide and Unhide Worksheets
36:20 Hide Entire Excel Workbook
37:24 Group and Ungroup Excel Worksheets
40:35 Slide and Zoom Excel Worksheets
43:19 Freeze Panes Option in Excel
45:20 Deleting Excel Worksheets
46:42 Video Conclusion
Autofit column width using VBA in Excel
kzbin.info/www/bejne/aGmVmWibj5ifr80si=IHbD_yf44iFExSH-
Introduction to Microsoft Excel - Complete Course
kzbin.info/www/bejne/boGkdGuGn9Keftksi=j1lOUA7IFhgtbkuW
Please like, share, comment and consider subscribing for more educative content.