Microsoft Excel Tutorials Introduction & Practicing
From 9.96 £ /h
1. Exploring Excel
Finding and using commands
Moving around a worksheet
Navigating the workbook
2. Basic Workbook Skills
Creating a workbook
Selecting cells and ranges
Opening, closing and saving workbooks
Entering data into cells
Entering values into ranges
3. Creating Simple Formulas
Writing formulas in cells
Using the Formula Bar
AutoSum and other basic functions
The Paste Function tool
Automatic calculation
4. Copying and Moving Data
Copying and cutting data
Absolute cell references
Filling cells
Using drag-and-drop
Undo and Redo
Find and Replace
5. Managing Worksheets
Naming worksheets
Copying and moving worksheets
Grouping worksheets
Moving data between sheets
Adding and deleting worksheets
Creating 3-D formulas
6. Printing
Choosing what to print
Previewing and printing
Page Setup
Margins and page orientation
Headers and footers
Repeating column/row headings
Page Break Preview
Printing grid lines
7. Formatting Data and Cells
Formatting numbers
Formatting text
Coloring data and cells
Wrapping and shrinking text
Merging cells
Using indents
Applying borders to cells
The Format Painter
Conditional formatting
8. Working with Columns and Rows
Selecting columns and rows
Changing column width and row height
Hiding and unhiding
Inserting and deleting
9. Using Large Spreadsheets
Changing the magnification
Full Screen view
Splitting the window
Using Freeze Panes
10. Named Ranges
Naming a range of cells
Jumping to a named range
Using range names in formulas
Re-defining and deleting range names
11. Working with Data Series
Creating a linear series
Working with Date series
Using Auto-fill
Finding and using commands
Moving around a worksheet
Navigating the workbook
2. Basic Workbook Skills
Creating a workbook
Selecting cells and ranges
Opening, closing and saving workbooks
Entering data into cells
Entering values into ranges
3. Creating Simple Formulas
Writing formulas in cells
Using the Formula Bar
AutoSum and other basic functions
The Paste Function tool
Automatic calculation
4. Copying and Moving Data
Copying and cutting data
Absolute cell references
Filling cells
Using drag-and-drop
Undo and Redo
Find and Replace
5. Managing Worksheets
Naming worksheets
Copying and moving worksheets
Grouping worksheets
Moving data between sheets
Adding and deleting worksheets
Creating 3-D formulas
6. Printing
Choosing what to print
Previewing and printing
Page Setup
Margins and page orientation
Headers and footers
Repeating column/row headings
Page Break Preview
Printing grid lines
7. Formatting Data and Cells
Formatting numbers
Formatting text
Coloring data and cells
Wrapping and shrinking text
Merging cells
Using indents
Applying borders to cells
The Format Painter
Conditional formatting
8. Working with Columns and Rows
Selecting columns and rows
Changing column width and row height
Hiding and unhiding
Inserting and deleting
9. Using Large Spreadsheets
Changing the magnification
Full Screen view
Splitting the window
Using Freeze Panes
10. Named Ranges
Naming a range of cells
Jumping to a named range
Using range names in formulas
Re-defining and deleting range names
11. Working with Data Series
Creating a linear series
Working with Date series
Using Auto-fill
Location
At student's location :
- Around Riyadh, Saudi Arabia
Online from Saudi Arabia
About Me
Certificate - Excel Microsoft Master
Certificate - Excel Associate Microsoft Office Specialist for Office 2019 and Office
365
Certificate - Excel Expert Microsoft Office Specialist for Office 2019 and Office 365
Certificate - Excel PivotTables in Depth
Certificate - Excel Charts in Depth
Certificate - Excel Creating a Basic Dashboard
Certificate - Excel Advanced Formatting Techniques
Certificate - Excel Advanced Formulas and Functions
Certificate - Excel Essential Training Office 365
Certificate - Excel Associate Microsoft Office Specialist for Office 2019 and Office
365
Certificate - Excel Expert Microsoft Office Specialist for Office 2019 and Office 365
Certificate - Excel PivotTables in Depth
Certificate - Excel Charts in Depth
Certificate - Excel Creating a Basic Dashboard
Certificate - Excel Advanced Formatting Techniques
Certificate - Excel Advanced Formulas and Functions
Certificate - Excel Essential Training Office 365
Education
Bachelor of Electrical - Electronics and Telecommunications Engineering
Microsoft Office Excel, PowerPoint Mastery
Digital Transformation Mastery
Mobile Communications
Microsoft Office Excel, PowerPoint Mastery
Digital Transformation Mastery
Mobile Communications
Experience / Qualifications
Operations, Maintenance
Data Analytics
Database Unification and Reporting
Strategic Planning
Digital Transformation Processes
Data Analytics
Database Unification and Reporting
Strategic Planning
Digital Transformation Processes
Age
Children (7-12 years old)
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Advanced
Duration
30 minutes
45 minutes
60 minutes
90 minutes
120 minutes
The class is taught in
English
Arabic
Skills
Availability of a typical week
(GMT -05:00)
New York
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Good-fit Instructor Guarantee





