Excel - Level 1

This is a beginner's course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel. Particular emphasis is placed on developing accurate and well-designed...
$380
Brand
SKU:
E16L1
Duration:
1 Day
Delivery:
Virtual Classroom
Adding to cart… The item has been added
Request a Quote

Excel - Level 1

We deliver this course in versions 2016, 2019, and 365

This is a beginner's course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Audience

This course is intended for students who wish to gain a foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.

This course assumes little or no knowledge of spreadsheets or Microsoft Excel. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

Skills Covered

Upon successful completion of this course, you will be able to:

  • navigate your way around Microsoft Excel
  • create and work with a new workbook
  • save workbooks in a variety of formats
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • obtain help for Excel whenever you need it
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use the fill operations available to fill a data series
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • move the contents of cells and ranges within and between workbooks
  • use the special pasting options in Excel
  • use font formatting techniques
  • understand and use the number formatting features in Excel
  • align the contents of cells in a number of ways
  • format rows and columns in a worksheet
  • apply a variety of page setup techniques
  • create and work with headers and footers
  • print your workbook data
  • work with elements that make up the structure of a worksheet
  • use a range of techniques to work with worksheets
  • apply borders to cells and ranges in a worksheet
  • apply a range of number formatting techniques to worksheet cells

Course Content

Excel - Level 1

  • Lesson 1: Getting To Know Excel
    • Starting Excel From the Desktop
    • Understanding the Excel Start Screen
    • The Excel Workbook Screen
    • How Excel Works
    • Using the Ribbon
    • Showing and Collapsing the Ribbon
    • Understanding the Backstage View
    • Accessing the Backstage View
    • Using Shortcut Menus
    • Understanding Dialog Boxes
    • Launching Dialog Boxes
    • Understanding the Quick Access Toolbar
    • Adding Commands to the QAT
    • Understanding the Status Bar
    • Exiting Safely From Excel
  • Lesson 2: Creating a New Workbook
    • Understanding Workbooks
    • Using the Blank Workbook Template
    • Typing Text
    • Typing Numbers
    • Typing Dates
    • Understanding the Fill Handle
    • Typing Formulas
    • Easy Formulas
    • Saving a New Workbook on Your Computer
    • Checking the Spelling
    • Making Basic Changes
    • Printing a Worksheet
    • Safely Closing a Workbook
  • Lesson 3: Saving Workbooks
    • Understanding the Windows Filing Structure
    • Understanding Naming Conventions
    • Understanding Version Compatibility
    • Saving With a Different Name
    • Saving in Another Location
    • Saving in Another Version
    • Saving in a Web Format
    • Saving in Binary Format
    • Saving as a Template
    • Saving as Macro Enabled
    • Saving With Thumbnails
    • Saving Tags and Author Details
  • Lesson 4: Working with Workbooks
    • Opening an Existing Workbook
    • Navigating a Workbook
    • Navigating Using the Keyboard
    • Using Go To
    • Recent Files and Folders
  • Editing in a Workbook
    • Understanding Data Editing
    • Overwriting Cell Contents
    • Editing Longer Cells
    • Editing Formulas
    • Clearing Cells
    • Deleting Data
    • Using Undo and Redo
  • Lesson 6: Getting Help
    • Understanding How Help Works
    • Using Tell Me
    • Accessing the Help Window
    • Navigating the Help Window
    • Using Google to Get Help
    • Printing a Help Topic
    • Other Sources of Assistance
  • Lesson 7: Formulas and Functions
    • Understanding Formulas
    • Creating Formulas That Add
    • Creating Formulas That Subtract
    • Formulas That Multiply and Divide
    • Understanding Functions
    • Using the SUM Function to Add
    • Summing Non-Contiguous Ranges
    • Calculating an Average
    • Finding a Maximum Value
    • Finding a Minimum Value
    • Creating More Complex Formulas
    • What if Formulas
    • Common Error Messages
  • Lesson 8: Formula Referencing
    • Absolute Versus Relative Referencing
    • Relative Formulas
    • Problems With Relative Formulas
    • Creating Absolute References
    • Creating Mixed References
  • Lesson 9: Filling Data
    • Understanding Filling
    • Filling a Series
    • Filling a Growth Series
    • Filling a Series Backwards
    • Filling Using Options
    • Creating a Custom Fill List
    • Modifying a Custom Fill List
    • Deleting a Custom Fill List
    • Extracting With Flash Fill
    • More Complex Flash Fill Extractions
    • Extracting Dates and Numbers
  • Lesson 10:Selecting Ranges
    • Understanding Cells and Ranges
    • Selecting Contiguous Ranges
    • Selecting Non-Contiguous Ranges
    • Using Special Selection Techniques
    • Selecting Larger Ranges
    • Selecting Rows
    • Selecting Columns
    • Viewing Range Calculations
    • Creating an Input Range
  • Lesson 11: Copying Data
    • Understanding Copying in Excel
    • Using Fill for Quick Copying
    • Copying From One Cell to Another
    • Copying From One Cell to a Range
    • Copying From One Range to Another
    • Copying Relative Formulas
    • Copying to a Non-Contiguous Range
    • Copying to Another Worksheet
    • Copying to Another Workbook
  • Lesson 12: Moving Data
    • Understanding Moving in Excel
    • Moving Cells and Ranges
    • Moving by Dragging
    • Moving Data to Other Worksheets
    • Moving Data to Other Workbooks
  • Lesson 13: Special Pasting
    • Understanding Pasting Options
    • Pasting Formulas
    • Pasting Values
    • Pasting Without Borders
    • Pasting as a Link
    • Pasting as a Picture
    • The Paste Special Dialog Box
    • Copying Comments
    • Copying Validations
    • Copying Column Widths
    • Performing Arithmetic With Paste Special
    • Copying Formats With Paste Special
  • Lesson 14: Font Formatting
    • Understanding Font Formatting
    • Working With Live Preview
    • Changing Fonts
    • Changing Font Size
    • Growing and Shrinking Fonts
    • Making Cells Bold
    • Italicising Text
    • Underlining Text
    • Changing Font Colours
    • Changing Background Colours
    • Using the Format Painter
    • Applying Strikethrough
    • Subscripting Text
    • Superscripting Text
  • Lesson 15: Number Formatting
    • Understanding Number Formatting
    • Applying General Formatting
    • Formatting for Money
    • Formatting Percentages
    • Formatting as Fractions
    • Formatting as Dates
    • Using the Thousands Separator
    • Increasing and Decreasing Decimals
  • Lesson 16: Cell Alignment
    • Understanding Cell Alignment
    • Horizontal Cell Alignment
    • Vertical Cell Alignment
    • Indenting Cells
    • Rotating Text
    • Wrapping and Merging Text
    • Unmerging Cells
  • Lesson 17: Row and Column Formatting
    • Approximating Column Widths
    • Setting Precise Columns Widths
    • Setting the Default Column Width
    • Approximating Row Height
    • Setting Precise Row Heights
    • Hiding Rows and Columns
    • Unhiding Rows and Columns
  • Lesson 18: Page Setup
    • Understanding Page Layout
    • Using Built in Margins
    • Setting Custom Margins
    • Changing Margins by Dragging
    • Centring on a Page
    • Changing Orientation
    • Specifying the Paper Size
    • Setting the Print Area
    • Clearing the Print Area
    • Inserting Page Breaks
    • Using Page Break Preview
    • Removing Page Breaks
    • Setting a Background
    • Clearing the Background
    • Settings Rows as Repeating Print Titles
    • Clearing Print Titles
    • Printing Gridlines
    • Printing Headings
    • Scaling to a Percentage
    • Fit to a Specific Number of Pages
  • Lesson 19: Headers and Footers
    • Understanding Headers and Footers
    • Adding a Quick Header
    • Adding a Quick Footer
    • Switching Between Headers and Footers
    • Typing Text Into Headers and Footers
    • Modifying Headers and Footers
    • Adding Page Numbering
    • Adding Date Information
    • Adding Workbook Information
    • Adding a Picture
    • Formatting Headers and Footers
    • Dragging Margins for Headers and Footers
    • Creating a Different First Page
    • Different Odd and Even Pages
  • Lesson 20: Printing
    • Understanding Printing
    • Previewing Before You Print
    • Selecting a Printer
    • Printing a Range
    • Printing an Entire Workbook
    • Specifying the Number of Copies
    • The Print Options
  • Lesson 21: Working with a Worksheet
    • Understanding Worksheets
    • Changing the Worksheet View
    • Worksheet Zooming
    • Viewing the Formula Bar
    • Viewing Worksheet Gridlines
    • Viewing the Ruler
    • Inserting Cells Into a Worksheet
    • Deleting Cells From a Worksheet
    • Inserting Columns Into a Worksheet
    • Inserting Rows Into a Worksheet
    • Deleting Rows and Columns
    • Working With Multiple Worksheets
    • Worksheet Wisdom
  • Lesson 22: Worksheet Techniques
    • Inserting and Deleting Worksheets
    • Copying a Worksheet
    • Renaming a Worksheet
    • Moving a Worksheet
    • Hiding a Worksheet
    • Unhiding a Worksheet
    • Copying a Sheet to Another Workbook
    • Changing Worksheet Tab Colours
    • Grouping Worksheets
    • Hiding Rows and Columns
    • Unhiding Rows and Columns
    • Freezing Rows and Columns
    • Splitting Windows
  • Appendix A: Applying Borders
    • Understanding Borders
    • Applying a Border to a Cell
    • Applying a Border to a Range
    • Applying a Bottom Border
    • Applying Top and Bottom Borders
    • Removing Borders
    • The More Borders Command
    • Using the More Borders Command
    • Drawing Borders
    • Drawing a Border Grid
    • Erasing Borders
    • Formatting the Drawing Pencil
  • Appendix B: Number Formatting Techniques
    • Applying Alternate Currencies
    • Applying Alternate Date Formats
    • Formatting Clock Time
    • Formatting Calculated Time
    • Understanding Number Formatting
    • Understanding Format Codes
    • Creating Descriptive Custom Formats
    • Custom Formatting Large Numbers
    • Custom Formatting for Fractions
    • Padding Numbers Using Custom Formatting
    • Aligning Numbers Using Custom Formats
    • Customising the Display of Negative Values

FAQs

  • How do I enrol in this online training?

    You can enrol in this training on our website and make an online payment using any of the following option

    • Visa Credit or Debit Card
    • MasterCard
    • American Express
    • Diners Club
    • PayPal

    Once payment is received, you will automatically receive a payment receipt and access information via email.

Buy Now

Our Most Popular Training Courses

BApps1a

Excel - Level 2

$380

Microsoft

  • Duration 1 Day
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
Excel - Level 2 1 Day
$380
course info
BApps2

Excel - Level 3

$380

Microsoft

  • Duration 1 Day
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
Excel - Level 3 1 Day
$380
course info
BApps9

Outlook - Level 1

$380

Microsoft

  • Duration 1 Day
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
Outlook - Level 1 1 Day
$380
course info
PI3

PowerPoint - Level 1

$380

Microsoft

  • Duration 1 Day
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
PowerPoint - Level 1 1 Day
$380
course info
PD5

Word - Level 1

$380

Microsoft

  • Duration 1 Day
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
Word - Level 1 1 Day
$380
course info