|
Provided by: Act Training Excel Level 1Computer |
 |
Beginners level one day instructor led course on Microsoft Excel. Topics include: Excel basics, Entering data and navigating in a worksheet, Modifying a workbook, Moving and copying data, Formatting a worksheet, Printing a worksheet, Introduction to the workbook environment, Creating Excel web pages.
The only prerequisite for this course is having a basic knowledge of Windows.
The only prerequisite for this course is having a basic knowledge of Windows.
Related Software Programs or Products: Microsoft Excel
|
|
||||||||||
Training
Provided by Act Training
Excel Level 1
Lesson 1: Excel basics
The paper spreadsheet
The Excel program
The workbook environment
Lesson 2: Entering data and navigating in a worksheet
Entering and correcting data
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques
Lesson 3: Modifying a workbook
Working with ranges
Working with functions
Editing cell contents
Lesson 4: Moving and copying data
Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature
Lesson 5: Formatting a worksheet
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Lesson 6: Printing a worksheet
Checking spelling
Using the Print Preview command
Printing a large worksheet
Additional print options
Lesson 7: Introduction to the workbook environment
Using a multiple-sheet workbook
Creating a chart
Outlining
Spreadsheet solutions
Lesson 8: Creating Excel Web pages
Using Excel as a Web tool
The paper spreadsheet
The Excel program
The workbook environment
Lesson 2: Entering data and navigating in a worksheet
Entering and correcting data
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques
Lesson 3: Modifying a workbook
Working with ranges
Working with functions
Editing cell contents
Lesson 4: Moving and copying data
Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature
Lesson 5: Formatting a worksheet
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Lesson 6: Printing a worksheet
Checking spelling
Using the Print Preview command
Printing a large worksheet
Additional print options
Lesson 7: Introduction to the workbook environment
Using a multiple-sheet workbook
Creating a chart
Outlining
Spreadsheet solutions
Lesson 8: Creating Excel Web pages
Using Excel as a Web tool
About The Training Provider: Act Training
Act Training - We provide training in Computer Applications such as Microsoft Word, Excel, PowerPoint, Access, Outlook, Sage Accounts and Sage Payroll; Professional IT subjects such as CompTIA A plus, CompTIA N plus, MCP, MCSA, MCSE and CISCO; Office skills such as Bookkeeping, Accounting, Pitman & Teeline Shorthand, OCR Text Processing and Keyboard skills.
These subjects are taught on site for individuals...
