Arise SLG

Data Training Institute

Microsoft Excel Level 1 (Beginners)

Live & online$250
Microsoft Excel Level 1 (Beginners)

About This Course

Unlock the basics of Microsoft Excel with our Level 1 course designed for absolute beginners. Learn how to navigate the interface, create simple spreadsheets, and perform basic calculations. This course is perfect for individuals new to Excel or those looking to refresh their foundational skills.

What You'll Learn

  • Navigating the Excel Interface
  • Creating and Managing Simple Spreadsheets
  • Performing Basic Calculations

Course Content

8 sections · taught live, step by step

1

Section 1: Creating, Opening and Saving Workbooks

  • What Is Excel?
  • Create a New Blank Workbook
  • Open Excel Files
  • Save Workbooks
  • Navigate a Workbook
  • Selection Types
  • Data Checkers
  • Help
2

Section 2: Exploring the User Interface

  • Backstage View
  • Ribbon Overview
  • Quick Access Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs
3

Section 3: Working with Data

  • Basic Data Types
  • Enter, Edit and Delete Data
  • Use Autocomplete and Autofill
  • Resize Columns and Rows
  • Insert and Delete Columns, Rows, Cells
  • Hide and Unhide Columns and Rows
  • Use Undo, Redo and Repeat
  • Spellcheck and AutoCorrect
  • Use Find, Replace and Go To
  • Cut, Copy, Paste and Paste Special
  • Use the Fill Handle
4

Section 4: Performing Calculations

  • Use Basic Formulas
  • Use Basic Functions
  • Understand Absolute and Relative Cell References
5

Section 5: Using Time Saving Tools

  • Flash Fill
  • AutoCalculate
6

Section 6: Formatting A Workbook

  • Work with Fonts and Font Attributes
  • Apply Borders and Shading
  • Use the Format Painter
  • Change Text Alignment
  • Wrap Text
  • Apply Manual Line Breaks
  • Rotate Text
  • Merge and Centre Text
  • Create and Modify Styles
  • Apply Number Formats
  • Clear Formatting
7

Section 7: Managing Large Workbooks

  • Rename Worksheets
  • Colour-code Worksheet Tab Colours
  • Copy, Move, Delete, and Group Worksheets
  • Work with Freeze Panes
8

Section 8: Printing and Viewing A Workbook

  • Work with Page Breaks
  • Work with Print Preview and Page Layout View
  • Change Margins and Page Orientation
  • Scale to Fit Worksheets
  • Insert Headers and Footers
  • Print Titles Across All Pages
  • Review Print Options

Not sure this course is the right fit?

Tell us your goals and we'll recommend the right learning path — or build a custom corporate training for your team.

Talk To Us