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
08/08/2023
10:00 – 18:00Tuesday-Wednesday 2 DaysClassroom Based / Live Virtual Online
06/09/2023
10:00 – 18:00Wednesday-Thursday 2 DaysClassroom Based / Live Virtual Online
07/09/2023
10:00 – 18:00Thursday-Friday 2 DaysClassroom Based / Live Virtual Online
20/09/2023
10:00 – 18:00Wednesday-Thursday 2 DaysClassroom Based / Live Virtual Online
10/10/2023
10:00 – 18:00Tuesday-Wednesday 2 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