Excel 2013 - Level 1

loading..

loading..
or GET IT WITH SATVs

Excel can help you organise, calculate, analyse, revise, update, and present your data in ways that will help the decision makers in your organisation steer you in the right direction. Of course, knowing exactly how to ask Excel the questions that you need answered, which questions you can even ask, and how to interpret the answers Excel gives is necessary before you can even begin to embark on the journey ahead. This course aims to provide you with the foundational Excel knowledge and skills necessary to begin that journey.

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2013 Exam and the Excel 2013 Expert Exam.

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

  • Modify Fonts
  • Add Borders and Colours to Worksheets
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

  • Preview and Print a Workbook
  • Define the Page Layout

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

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

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should be comfortable in the Windows 8 environment, and be able to use Windows 8 to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.

After completing this course, students will be able to:

  • Get started with Microsoft Office Excel 2013
  • Perform calculations
  • Modify a worksheet
  • Format a worksheet
  • Print workbooks
  • Manage workbooks

Register

In Class

    Show all

    In Class

      Show all

      In Class

        Show all

        In Class

          Show all

          OnlineLive

            Show all

            Connected Classroom

              Show all

              Not currently scheduled

              Fast track the availability of this course.
              Add to watch list or call 1300 794 006.

              Need your team upskilled?
              Request a Quote
              blah is false
              top