Certificate In Excel 2013 Essentials Online Course

Courses For Success
Online

Precio a consultar

Información importante

  • Curso
  • Online
  • Cuándo:
    A definir
Descripción

Learn the Basic Features of Excel 2013 You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013. Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making! By the end of this Certificate In Excel 2013 Essentials Online Course, you will be able to: Open and close Excel Differentiate between worksheets, workbooks, rows, columns, and cells Understand the new Interface and the new Backstage View Enter labels and values Edit data Add rows and columns Check spelling Open, close, and save workbooks (including publishing to PDF and sending via E-mail) Switch between Excel views and create custom views Use Zoom Set up, Preview and print your workbook Build, copy and edit formulas Use absolute referencing appropriately Understand the difference between Formulas and Functions Understand the new Function Names Use the Formulas Tab Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN Use the status bar to perform calculations Use AutoFill and AutoComplete Sort and filter data Use sparklines Format text and numbers Use alignment options Merge cells Apply borders Use cell styles Use conditional formatting Change the workbook theme Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any...

Información importante

Requisitos: Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows:...

Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Online

¿Qué aprendes en este curso?

Excel
Options
Basic
Basic IT training
Basic IT
MS Excel

Programa académico

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Using Excel Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Using the Status Bar to Perform Calculations
  • Understanding the New Function Names

Module Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up