MICROSOFT EXCEL BASIC TRAINING

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 TimingDaysDuration Mode Of TrainingRequest Price/Future Dates
15/08/2022
10:00 – 18:00Monday/Friday 5 WeeksClassroom Based / Live Virtual Online
27/08/2022
10:00 – 18:00Saturday Only 5 WeeksClassroom Based / Live Virtual Online
11/09/2022
10:00 – 18:00Sunday Only 5 WeeksClassroom Based / Live Virtual Online
26/09/2022
10:00 – 18:00Monday-Friday 5 DaysClassroom Based / Live Virtual Online
01/10/2022
10:00 – 18:00Monday-Friday 5 DaysClassroom Based / Live Virtual Online
04/03/2023
10:00 – 18:00Saturday Only 5 WeeksClassroom Based / Live Virtual Online
25/03/2023
10:00 – 18:00Saturday Only 5 WeeksClassroom Based / Live Virtual Online
02/04/2023
10:00 – 18:00Saturday Only 5 WeeksClassroom Based / Live Virtual Online
28/04/2023
10:00 – 18:00Saturday Only 5 WeeksClassroom Based / Live Virtual Online
14/05/2023
10:00 – 18:00Sunday Only 5 WeeksClassroom Based / Live Virtual Online (Flexible schedule)
21/05/2023
10:00 – 18:00Sunday Only 5 WeeksClassroom Based / Live Virtual Online
22/05/2023
10:00 – 18:00Monday-Friday 5 DaysClassroom Based / Live Virtual Online
12/06/2023
10:00 – 18:00Monday-Friday 5 DaysClassroom Based / Live Virtual Online
19/06/2023
10:00 – 18:00Monday-Friday 5 DaysClassroom Based / Live Virtual Online
10/07/2023
10:00 – 18:00Monday-Friday 5 DaysClassroom Based / Live Virtual Online
15/07/2023
10:00 – 18:00Saturday Only 5 WeeksClassroom Based / Live Virtual Online
17/07/2023
10:00 – 18:00Monday-Friday 5 DaysClassroom Based / Live Virtual Online

RELATED COURSES

SAP HCM at iTraining London

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