Microsoft Excel 2016 - nanforiberica

 

    ACCIÓN FORMATIVA

    Excel 2016

    IDIOMA

    Inglés

    CONTACTO

    soporte@nanforiberica.com

    TUTORES

     Julio García- juliog@nanforiberica.com

    Javier Lozano – javierl@nanforiberica.com

     

    Objetivos del curso

    • Quickly set up workbooks, enter data, and format it for easier viewing
    • Perform calculations and find and correct errors
    • Filter, sort, summarize, and combine data
    • Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
    • Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
    • Build data models and use them in business intelligence analyses
    • Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
    • Look up just the tasks and lessons you need


    Contenido del curso

    Introduction

    Who this book is for
    The Step by Step approach 
    Download the practice files  
    Sidebar: Adapt exercise steps    
    Ebook edition     
    Get support and give feedback     
    Errata and support     
    We want to hear from you     
    Stay in touch      

    Part 1: Create and format workbooks

    • Chapter 1: Set up a workbook     
      Explore the editions of Excel 2016    
      Excel 2016     
      Excel Online     
      Excel Mobile Apps    
      Become familiar with new features in Excel 2016    
      Create workbooks    
      Modify workbooks     
      Modify worksheets    
      Merge and unmerge cells    
      Customize the Excel 2016 app window      
      Zoom in on a worksheet    
      Arrange multiple workbook windows    
      Add buttons to the Quick Access Toolbar     
      Customize the ribbon    
      Skills review    
      Practice tasks     
    • Chapter 2: Work with data and Excel tables    
      Enter and revise data    
      Manage data by using Flash Fill    
      Move data within a workbook    
      Find and replace data    
      Correct and expand upon data    
      Define Excel tables    
      Skills review    
      Practice tasks    
    • Chapter 3: Perform calculations on data    
      Name groups of data    
      Create formulas to calculate values    
      Sidebar: Operators and Precedence    
      Summarize data that meets specific conditions    
      Set iterative calculation options and enable or disable automatic calculation    
      Use array formulas    
      Find and correct errors in calculations    
      Skills review    
      Practice tasks    
    • Chapter 4: Change workbook appearance    
      Format cells  
      Define styles    
      Apply workbook themes and Excel table styles    
      Make numbers easier to read   
      Change the appearance of data based on its value   
      Add images to worksheets   
      Skills review    
      Practice tasks    


    Part 2: Analyze and present data

    • Chapter 5: Manage worksheet data    
      Limit data that appears on your screen    
      Manipulate worksheet data   
      Sidebar: Select list rows at random    
      Summarize data in worksheets that have hidden and filtered rows   
      Find unique values within a data set   
      Define valid sets of values for ranges of cells   
      Skills review   
      Practice tasks   
    • Chapter 6: Reorder and summarize data    
      Sort worksheet data    
      Sort data by using custom lists    
      Organize data into levels    
      Look up information in a worksheet   
      Skills review    
      Practice tasks    
    • Chapter 7: Combine data from multiple sources    
      Use workbooks as templates for other workbooks    
      Link to data in other worksheets and workbooks   
      Consolidate multiple sets of data into a single workbook   
      Skills review   
      Practice tasks   
    • Chapter 8: Analyze alternative data sets   
      Examine data by using the Quick Analysis Lens   
      Define an alternative data set   
      Define multiple alternative data sets   
      Analyze data by using data tables  
      Vary your data to get a specific result by using Goal Seek    
      Find optimal solutions by using Solver   
      Analyze data by using descriptive statistics   
      Skills review    
      Practice tasks  
    • Chapter 9: Create charts and graphics  
      Create charts   
      Create new types of charts   
      Customize chart appearance   
      Find trends in your data   
      Create dual-axis charts  
      Summarize your data by using sparklines    
      Create diagrams by using SmartArt    
      Create shapes and mathematical equations    
      Skills review     
      Practice tasks   
    • Chapter 10: Create dynamic worksheets by using PivotTables   
      Analyze data dynamically by using PivotTables   
      Filter, show, and hide PivotTable data   
      Edit PivotTables   
      Format PivotTables   
      Create PivotTables from external data   
      Create dynamic charts by using PivotCharts    
      Skills review   
      Practice tasks   

    Part 3: Collaborate and share in Excel 

    • Chapter 11: Print worksheets and charts    
      Add headers and footers to printed pages   
      Prepare worksheets for printing   
      Fit your worksheet contents to the printed page   
      Change page breaks in a worksheet   
      Change the page printing order for worksheets   
      Print worksheets   
      Print parts of worksheets   
      Print charts   
      Skills review  
      Practice tasks   
    • Chapter 12: Automate repetitive tasks by using macros   
      Enable and examine macros    
      Set macro security levels in Excel 2016   
      Examine macros   
      Create and modify macros   
      Run macros when you click a button    
      Run a macro when you open a workbook   
      Insert form controls into a worksheet   
      Skills review   
      Practice tasks   
    • Chapter 13: Work with other Microsoft Office apps   
      Include Office documents in workbooks and other files  
      Link Office documents to Excel workbooks   
      Embed files in Excel and other Office apps   
      Create hyperlinks   
      Paste charts into documents   
      Skills review  
      Practice tasks   
    • Chapter 14: Collaborate with colleagues    
      Share workbooks    
      Save workbooks for electronic distribution   
      Manage comments   
      Track and manage colleagues’ changes    
      Add protection to workbooks and worksheets   
      Finalize workbooks    
      Authenticate workbooks   
      Save workbooks for the web   
      Import and export XML data    
      Work with OneDrive and Excel Online   
      Skills review   
      Practice tasks   

    Part 4: Perform advanced analysis 

    • Chapter 15: Perform business intelligence analysis   
      Enable the Data Analysis add-ins   
      Define relationships between tables   
      Analyze data by using Power Pivot   
      View data by using timelines  
      Bring in external data by using Power Query   
      Skills review   
      Practice tasks  
    • Chapter 16: Create forecasts and visualizations   
      Create Forecast Worksheets   
      Define and manage measures    
      Define and display Key Performance Indicators   
      Create 3D maps  
      Skills review  
      Practice tasks

     

    Requisitos previos 

    Para realizar este curso se requieren conocimientos básicos de manejos de PC e Internet.

    Requisitos de Software y Hardware

    Hardware: PC Multimedia

    Pentium IV o superior, 1 Gb de memoria, tarjeta de sonido, altavoces/cascos

    Software:

    Windows XP, Windows Vista o Windows 7

    Navegadores: Explorer 6,7 y 8 o firefox 2 y 3

    Java 1.5 o superior

    Adobe Flash Player 7.0 o superior

    Javascript habilitado

    Adobe Reader 8.0 o superior

    €665.00