The “Microsoft Excel Tutorial for Beginner” is a comprehensive Microsoft Excel advanced tutorial program published on the Khyber Academy. Its aim is to provide familiarity with the basic and most important tools available in the Microsoft Excel application. In this, we can learn how to manage data and can easily utilize Microsoft excel application in professional life. After learning the Microsoft Excel basics, the trainee will be able to perform complex statistical calculations in Microsoft Excel. You will be familiar with using Microsoft Excel basics tools to solve real problems using add-ins and focus on the use of pivot tables, and pivot charts to easily and quickly analyze large amounts of information. Finally, he will acquire a first familiarity with the macros that he can use to significantly boost his productivity
Microsoft Excel Tutorial:
Microsoft Excel’s advanced tutorial consists of the following lessons. If you are serious to learn Excel program. You must follow the learning attitude and must do hands-on practice after learning each tutorial. In this tutorial we will use Excel 2019 application, however, the main commands are the same in all versions.
Audience
All those computer users who would like to learn Microsoft Excel from basic to advanced. It is highly recommended for those who are working in Government or private sectors office.
Pre-requisites
Before starting this tutorial you should have a basic familiarity with a computer. You may also use computer peripherals like a keyboard, mouse, etc. You should also know the basic skills like computer ON-OFF, opening program, folder, and simple navigations.
Introduction to Microsoft Excel:
Microsoft Excel Commands
- Create a workbook in excel
- How to save excel file/workbook
- “Save as” command in excel
- Open an excel file/workbook
- Convert or Save Excel workbook as PDF
Working with a worksheet in excel
- Create or insert a new worksheet
- Copy or duplicate a worksheet
- Move a worksheet
- Rename a worksheet
- Delete a worksheet
- Protect a worksheet
- Set worksheet tab color
- Hide worksheet
- Select all worksheets
Working with cell in excel
- Insert data in cell
- Copy cell
- Past cell
- Insert new cell
- Delete cell
- Setting font
- Change background
- Change font color
- Text decoration bold, italic, underline, etc.
- Text alignments
- Change text direction
- Text wrap
- Cell merge
- Cell/Table border
- Cell data format