Economize 95%
      Shaw Academy

      Diploma in Microsoft Excel

      4.5 excelente 7 opiniões
      Shaw Academy
      Online

      R$1.796 R$86
      *Preço aproximado
      Valor original em EUR:
      €395  €19

      Informação importante

      Tipologia Curso
      Nível Beginner
      Metodologia Online
      Horário de aulas 8h
      Duração 4
      Início Datas a escolher
      • Curso
      • Beginner
      • Online
      • 8h
      • Duração:
        4
      • Início:
        Datas a escolher
      Descrição

      Microsoft Excel can be incredibly powerful in the right hands, however, often it is more than a little daunting. Knowledge of Microsoft Excel is often crucially required for gaining employment and most roles require a working knowledge. The purpose of this course is to bring you on a journey from basic level Excel use all the way through the most advanced charts, graphs, look ups and much more. The beauty here is the way the content is presented, in bite size chunks, which can be looked up at ease, almost like a video dictionary for Excel. Interactive downloadable workbooks ensure all points are grasped in real time so register now to start learning.

      Informação importante

      Desconto por inscrição antecipada:

      Instalações (1)
      Instalações e datas
      Início Localização
      Datas a escolher
      Online
      Início Datas a escolher
      Localização
      Online

      Opiniões

      4.5
      excelente
      Avaliação do curso
      100%
      O recomendam
      4.5
      excelente
      Avaliação do Centro

      Opiniões sobre este centro

      H
      Heather Lopez
      18/06/2017
      O melhor: Loved all my classes and professors, have learnt a lot. Classes are full of pertinent information, and real life needed skills are taught at a perfect for me pace. Using this as a refresher for courses taken many years ago, and still learning more than I thought. Love it!
      A melhorar: No complaints
      Curso realizado: Junho 2017
      Você recomendaria esse centro?: sim
      K
      Karol Miller
      17/05/2016
      O melhor: Highly informative courses. I’m learning new things, it doesn’t bother me part of the content is recorded.
      A melhorar: .
      Curso realizado: Maio 2016
      Você recomendaria esse centro?: sim
      P
      Paul Burns
      18/10/2011
      O melhor: I have enjoyed the course and its format so much, so I decided to take more courses. I am now on my third course. I like the span of subjects covered. I can use the courses to refresh my skills for work or simply expand my general knowledge.
      A melhorar: Nothing
      Curso realizado: Outubro 2011
      Você recomendaria esse centro?: sim
      H
      Hanna Smith Botha
      20/05/2011
      O melhor: Amazing presentation, easy to follow, very informative. Worth every second I spent in the course.
      A melhorar: All OK
      Curso realizado: Maio 2011
      Você recomendaria esse centro?: sim
      E
      Elana Theron
      10/07/2017
      O melhor: The centre is awesome, I’m so happy with the photography course, have learnt a lot. William is an amazing teacher, recommend Shaw Academy to everyone.
      A melhorar: Nothing.
      Curso realizado: Julho 2017
      Você recomendaria esse centro?: sim
      * Opiniões recebidas pela Emagister e iAgora

      O que se aprende nesse curso?

      Excel
      Options
      Microsoft Excel
      Graphics
      Printing
      Microsoft excel training
      MS Excel
      Excel Window
      Excel
      Cell pointer
      Performing Simple Calculations
      Performing Simple Calculations

      Programa

      Course Reviews
      • MODULE 1 -

        What is Excel? How to open and close Excel and a basic overview of Spreadsheet software. Topics covered in this module include:
        • Introducing Microsoft Excel
        • Starting Microsoft Excel
        • Understanding spreadsheets
        • Understanding the Excel window
        • Understanding the workbook window
        • Using the Ribbon
        • Using the Quick Access Toolbar
        • Getting help on Microsoft Excel
        • Exiting Microsoft Excel
        • Exercise / Solutions
        • Summary

      • MODULE 2 -

        What are Workbooks and Worksheets? How they work and what they assist with. Topics covered in this module include:
        • Creating and Saving Workbooks
        • Creating a new workbook
        • Saving a workbook
        • Auto-saving your work
        • Closing a workbook
        • Opening a workbook
        • Moving the cell pointer
        • Moving around a worksheet
        • Entering text 5 Entering numbers
        • Entering dates and times
        • Using the Zoom tool
        • Exercise / Solutions
        • Summary

      • MODULE 3 -

        How to alter Workbooks and make changes to the data held within them. Topics covered in this module include:
        • Editing Workbooks
        • Selecting ranges of cells
        • Editing cell contents
        • Clearing cell contents
        • Copying cell contents
        • Moving cell contents
        • Inserting and deleting cells
        • Inserting columns and rows
        • Deleting columns and rows
        • Copying cells with AutoFill
        • Inserting cell comments
        • Checking your spelling
        • Finding and replacing data
        • Exercise / Solutions
        • Summary

      • MODULE 4 -

        How to perform and generate different basic calculations upon data within Workbooks. Topics covered in this module include: • Performing Simple Calculations
        • Introducing formulae
        • Totalling columns and rows
        • Calculating with formulae
        • Calculating averages
        • Find the highest & lowest values
        • Understanding cell referencing
        • Using explicit values in formulae
        • Exercise / Solutions
        • Summary

      • MODULE 5 -

        Changing the format of Worksheets by editing Fonts, Colours and other factors. Topics covered in this module include
        • Formatting Worksheets
        • Formatting with font and colour
        • Formatting numbers
        • Formatting dates and times
        • Copying and pasting formatting
        • Adjusting column widths and row heights
        • Aligning cell contents
        • Indenting and rotating cell contents
        • Merging cells
        • Adding borders, colour and shading
        • Using styles
        • Using document themes
        • Exercise / Solutions
        • Summary

      • MODULE 6 -

        Printing Worksheets and changing options to find the most efficient print formats. Topics covered in this module include:
        • Previewing and Printing Worksheets
        • Previewing the worksheet
        • Preparing pages for printing
        • Creating headers and footers
        • Specifying the print area and titles
        • Controlling page breaks
        • Printing a worksheet
        • Exercise / Solutions
        • Summary

      • MODULE 7 -

        How to manage a multitude of similar or related Workbooks to make storing and saving more effective. Topics covered in this module include:
        • Managing Workbooks
        • Switching between worksheets
        • Renaming worksheets
        • Moving and copying worksheets
        • Inserting and deleting worksheets
        • Referencing external data
        • Exercise / Solutions
        • Summary

      • MODULE 8 -

        Using data stored in Workbooks and Worksheets to generate a wide array of charts to view data more efficiently. Topics covered in this module include: • Creating Charts
        • Creating new charts
        • Moving and resizing charts
        • Using predefined layouts and styles
        • Selecting and changing chart elements
        • Changing the chart type
        • Adding another data series
        • Naming data series
        • Formatting and aligning titles
        • Controlling gridlines
        • Controlling axes
        • Adding borders and colour
        • Working with 3-D charts
        • Updating the data series
        • Previewing and printing charts
        • Exercise / Solutions
        • Summary

      • MODULE 9 -

        A more complex look at the variety of available functions and formulae.

        Topics covered in this module include:
        • More Functions and Formulae
        • Naming cells and ranges
        • Common worksheet errors
        • Displaying and printing formulae
        • Using the COUNT function 5
        • Using the IF function
        • Exercise / Solutions
        • Summary

      • MODULE 10 -

        How to generate and run Macros to make workflow more quickly and smoothly.
        Topics covered in this module include:

        • Automating Your Work with Macros
        • Recording a macro
        • Replaying a macro
        • Exercise / Solutions
        • Summary

      • MODULE 11 -

        Using Data from a variety of external sources and how to effectively import it into Excel. Topics covered in this module include:
        • Importing Data
        • Importing from text files
        • Importing from Microsoft Access
        • Exercise / Solutions
        • Summary

      • MODULE 12 -

        How to generate tables and use the versatile range of options to filter and view the data. Topics covered in this module include:
        • Working with Tables
        • Sorting a table of records
        • Filtering a table of records
        • Subtotalling a table of records
        • Exercise / Solutions
        • Summary

      • MODULE 13 -

        Viewing data within a Workbook more efficiently by changing the format and additional formatting options. Topics covered in this module include:
        • Creating and Formatting Data
        • Combining cell contents
        • Using conditional formatting
        • Creating a custom number format
        • Creating a custom date format
        • Creating and applying a style
        • Exercise / Solutions
        • Summary

      • MODULE 14 -

        Adding external or internal content to enhance Workbooks. Topics covered in this module include:
        • Creating and Formatting Content
        • Inserting clip art
        • Inserting graphics
        • Moving graphics
        • Resizing graphics
        • Formatting graphics
        • Creating and modifying diagrams
        • Moving and resizing diagrams
        • Formatting diagrams
        • Annotating a chart
        • Filling data series with pictures
        • Changing the chart type
        • Manipulating pie charts
        • Selecting and saving a chart template
        • Exercise / Solutions
        • Summary

      • MODULE 15 -

        Using the Thesaurus and Research options to highlight and correctly collate external sources. Topics covered in this module include:
        • Using the Research Tool
        • Using the Thesaurus to find synonyms
        • Using research services
        • Exercise / Solutions
        • Summary

      • MODULE 16 -

        How to set Validation to ensure that errors are not introduced into a Workbook. Topics covered in this module include:
        • Validating Data
        • Using totals as visual checks
        • Using formulae for automatic checks
        • Using the Range Finder
        • Auditing a worksheet
        • Using error checking
        • Watching and evaluating formulae
        • Exercise / Solutions
        • Summary