Microsoft Excel Tutorials Introduction & Practicing
Van 11.54 € /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
Locatie
Plaats gekozen door de student :
- In de omgeving van Riyad, Saoedi-Arabië
Online vanuit Saoedi-Arabië
Over
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
Opleiding
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
Leservaring
Operations, Maintenance
Data Analytics
Database Unification and Reporting
Strategic Planning
Digital Transformation Processes
Data Analytics
Database Unification and Reporting
Strategic Planning
Digital Transformation Processes
Leeftijd
Kinderen (7-12 jaar oud)
Tieners (13-17 jaar oud)
Volwassenen (18-64 jaar oud)
Senioren (65+ jaar oud)
Niveau van de leerling
Beginner
Gemiddeld
Gevorderden
Duur
30 minuten
45 minuten
60 minuten
90 minuten
120 minuten
De les wordt gegeven in
Engels
Arabisch
Vaardigheden
Beschikbaarheid typische 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 Leraar Garantie





