COURSE OVERVIEW
WE OFFER
- Instructor-led Classroom-based & Live Virtual Online Training
- Hands-on Training
- Free Study Material
- Lab Exercises
- Unlimited Lab Access
- 100 % Passing Guarantee or Free Re-training
COURSE INFORMATION
- Fast Track
Days: Monday-Friday
Duration: 5 days - Slow Track
Days: Saturdays / Sundays / Evenings
Duration: 5 Weeks
Study Modes:
- Classroom / On-site
- Live Virtual
Microsoft Excel Basic Training Course
For More information call us on
0208 123 7574
COURSE INSIGHT
Microsoft Excel is a spreadsheet application, which is also a part of the Microsoft Office Application package. This training program is designed for those individuals who have no experience using Microsoft Excel before. The training course’s content starts from scratch on how to use Microsoft Excel, how to set up the working environment and so on. This training program will let you learn about the basic features and functionalities of Microsoft Excel. You will also start knowing about the arrangement of sheets and the process of creating and deleting the sheets. In addition, this course will teach you how to work with the predefined formula to calculate on top of the Excel sheet. Finally, this course will also let you learn about the different options in the menu tab of the Excel application.
Officially, Microsoft did not announce any prerequisite for this Microsoft Excel Basic Training Course. Ideally, you have minimum knowledge of basic computer operations, but not required. However, a fundamental understanding of the Microsoft Office package, especially Microsoft Excel, would be an added advantage for this course.
COURSE OUTLINE
- Starting Microsoft Excel
- Creating a Workbook
- Saving a Workbook
- The Status Bar
- Adding and Deleting Worksheets
- Copying and Moving Worksheets
- Changing the Order of Worksheets
- Splitting the Worksheet Window
- Closing a Workbook
- Work with tabs.
- Work with groups.
- Work with commands.
- Know which groups and commands are found on which tabs.
- Introduction to the Backstage View
- Opening a Workbook
- Open a Workbook
- New Workbooks and Excel Templates
- Select, Open and Save a Template Agenda
- Printing Worksheets
- Print a Worksheet
- Adding Your Name to Microsoft Excel
- Adding a Theme to Microsoft Excel
- Adding Common Commands
- Adding Additional Commands with the Customize Dialog Box
- Adding Ribbon Commands or Groups
- Placement
- Customize the Quick Access Toolbar
- Entering Text
- Adding and Deleting Cells
- Adding a Hyperlink
- Add WordArt to a Worksheet
- Using AutoComplete
- Entering Text and Using AutoComplete
- Entering Numbers and Dates
- Using the Fill Handle
- Entering Numbers and Dates
- Selecting Ranges of Cells
- Hiding Worksheets
- Adding Color to Worksheet Tabs
- Adding Themes to Workbooks
- Customize a Workbook Using Tab Colors and Themes
- Adding a Watermark
- The Font Group
- Working with Font Group Commands
- The Alignment Group
- Working with Alignment Group Commands
- The Number Group
- Working with Number Group Commands
- Math Operators and the Order of Operations
- Entering Formulas
- AutoSum (and Other Common Auto-Formulas)
- Copying Formulas and Functions
- Relative, Absolute, and Mixed Cell References
- Working with Formulas
- Inserting Rows and Columns
- Deleting Rows and Columns
- Transposing Rows and Columns
- Setting Row Height and Column Width
- Hiding and Unhiding Rows and Columns
- Freezing Panes
- Working with Rows and Columns
- Locate information in your worksheet using Find
- Find and Replace
- Using Find and Replace
- Using the Clipboard
- Using Format Painter
- Managing Comments
- Setting Margins
- Setting Page Orientation
- Setting the Print Area
- Print Scaling (Fit Sheet on One Page)
- Printing Headings on Each Page/Repeating Headers and Footers
- Headers and Footers
- Preparing to Print
Benefits of A Microsoft Excel Basic Training Certification
- Gain a highly recognised, on-demand accreditation of excellence
- Differentiate yourself in a crowded market
- Execute tasks with confidence and skills
- Attain higher wages and billable rates with a highly valued credential
Dates And Prices
| Start Date | Timing | Days | Duration | Mode Of Training | Request Price/Future Dates |
|---|---|---|---|---|---|
| 01.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 08.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 10.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 15.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 22.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 24.07.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 29.07.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 05.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 07.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 12.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 19.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 21.08.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 26.08.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 02.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 04.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 09.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 16.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 18.09.2024 | 10:00 – 18:00 | Wed only | 5 Weeks | Classroom Based / Live Virtual Online | |
| 23.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online | |
| 30.09.2024 | 10:00 – 18:00 | Mon - Fri | 5 Days | Classroom Based / Live Virtual Online |
RELATED COURSES
SAP HCM
Company that offers design and build services for you from initial sketches to the final production.
read more
CCNA
Our aim is exclusively focused on high-quality training that are tailored to corporate needs. The training delivered by professional trainers.
read more
Comptia A+
Our internship programme is designed to help students who have successfully completed the training and give experience in real time projects.
read more
SAP FICO
We allow only a limited number of students in a class. So you get more attention from your instructor and clarify your doubts better.
read more