Excel 2013 - Level 1

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

Traditional Classroom   

    Show all

    Traditional Classroom   

      Show all

      Traditional Classroom   

        Show all

        Traditional Classroom   

          Show all

          OnlineLive   

            Show all

            Connected Classroom   

              Show all

              Flexible Mentored Learning   

                Show all

                Flexible Mentored Learning   

                  Show all

                  Flexible Mentored Learning   

                    Show all

                    Flexible Mentored Learning   

                      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