1. Supports de cours
  2. Excel 2013 - (E/E) :Text in English with the English version of the software

Excel 2013 (E/E) :Text in English with the English version of the software

  • En stock
  • Expédié en 24h00
  • Personnalisable
  • Accessible immédiatement
  • Version HTML
  • Accès illimité 24h/24, 7J/7

Présentation

This practical guide teaches you how to get the most out of Microsoft® Excel 2013.
After a description of the new environment, which has been improved from the previous versions, and learning how to manage files, templates and datasheets, you will quickly become familiar with entering and editing data (numbers, dates, calculation formulas, data series). You will then learn how to use the tools for formatting data (fonts, colours, borders, AutoFormats, styles, etc), create outlines, use worksheet auditing, and print your tables replete with various graphics and charts.
The guide also explains the different ways you can use Excel to create tables and pivot charts by using datasheets. As a portion of this guide focuses on working with multiple users, it includes all you need to know about sharing and protecting your data.
The latter chapters discuss techniques for improving data entry (creating custom data series or drop-down lists), and how to insert hyperlinks, import and export data, use macro commands, and create Web pages.

Table des matières

  • Environment
    • Starting Excel 2013
    • Leaving Excel 2013
    • Using/managing the ribbon
    • Introducing the FILE tab
    • Undoing the most recent actions
    • Redoing the last cancelled actions
    • Repeating the last action
  • Views
    • Changing the display mode
    • Activating/deactivating the Touch or Mouse mode
    • Modifying the formula bar display
    • Displaying/hiding gridlines, line and column headers
    • Changing the zoom setting
    • Activating one or more windows
    • Viewing a workbook in two different windows
    • Arranging the window view
    • Displaying/hiding a window
    • Freezing/unfreezing rows or columns
    • Splitting a window into several panes
  • Workbooks
    • Creating a new workbook
    • Creating a workbook from a template
    • Creating a custom template
    • Opening a workbook
    • Saving a workbook
    • Using Excel 2013 workbooks in previous versions
    • Using workbooks from pre-2007 versions of Excel
    • Saving a workbook in PDF or XPS format
    • Displaying/editing workbook properties
    • Comparing two workbooks side-by-side
    • Closing a workbook
    • Choosing the default local working folder
    • Managing settings for automatic workbook recovery
    • Recovering a previous version of a file
    • Sending a workbook by e-mail
    • Using the accessibility checker
  • Movement/selection
    • Moving around in a worksheet
    • Accessing a particular cell
    • Searching for a cell
    • Selecting cells
    • Selecting rows/columns
    • Selecting cells by content
  • Data entry and editing
    • Entering constant data (text, values, etc.)
    • Inserting special characters
    • Inserting the system date/time in a cell
    • Using the AutoComplete feature
    • Using Flash Fill to complete a column
    • Entering the same data in several cells
    • Entering line breaks in a cell
    • Creating series of data
    • Using the Equation editor
    • Creating a hyperlink
    • Activating a hyperlink
    • Modifying/deleting a hyperlink
    • Modifying the contents of a cell
    • Clearing cell contents
    • Replacing the contents/format of one cell with the contents/format of another
    • Checking the spelling
  • Copying and moving
    • Copying into adjacent cells
    • Copying and moving cells
    • Copying cells to other sheets
    • Using the Office Clipboard
    • Copying a format
    • Copying cell content, results and/or formats
    • Transposing data as you copy
    • Copying Excel data and establishing a link
    • Making simple calculations while you copy
    • Copying data as a picture
  • Worksheets
    • Activating a worksheet
    • Renaming a sheet
    • Selecting worksheets
    • Changing the colour of the worksheet tabs
    • Displaying/hiding a worksheet
    • Displaying a background picture in the worksheet
    • Moving/copying one or more sheets
    • Inserting/adding worksheets
    • Deleting worksheets
  • Rows, columns, cells
    • Inserting rows/columns
    • Deleting rows/columns
    • Modifying the row height/column width
    • Adjusting row height and column width
    • Inserting empty cells
    • Deleting cells
    • Moving and inserting cells/rows/columns
    • Removing rows containing duplicates
  • Named areas
    • Naming cell range
    • Managing cell names
    • Selecting a range of cells by name
    • Displaying a list of names and associated references
  • Calculations
    • Learning about calculation formulas
    • Creating a basic calculation formula
    • Creating an absolute cell reference in a formula
    • Entering a formula from more than one sheet
    • Creating a formula with a function
    • Using AutoComplete to enter a function
    • Summing a group of cells
    • Using simple statistical functions
    • Creating a basic conditional formula
    • Creating a nested conditional formula
    • Counting cells which meet specific criteria (COUNTIF)
    • Calculating the sum of a range which meets a criterion (SUMIF)
    • Using named ranges in calculations
    • Inserting rows of statistics
  • Advanced calculations
    • Using dates in calculations
    • Calculating using time
    • Using the LOOKUP function
    • Consolidating data
    • Creating double input data tables
    • Calculating with array formulas
  • Scenarios and goals
    • Setting a value goal
    • Making scenarios
  • Auditing
    • Displaying formulas instead of results
    • Finding and correcting errors in formulas
    • Evaluating formulas
    • Using the Watch Window
    • Tracing relationships between formulas and cells
    • Using the Inquire add-in
  • Solver
    • Finding and activating the Solver Add-in
    • Defining and solving a problem using the Solver
    • Show intermediate Solver solutions
  • Standard formatting
    • Modifying the font and/or font size
    • Formatting cell contents
    • Creating a custom format
  • Data alignment
    • Modifying the orientation of cell content
    • Aligning cell content
    • Indenting cell contents
    • Merging cells
  • Borders and fills
    • Applying cell borders
    • Applying a background colour to cells
    • Applying a pattern or fill effect to cells
  • Conditional formatting
    • Applying preset conditional formatting
    • Creating a conditional formatting rule
    • Formatting cells according to their content
    • Remove all conditional formatting
    • Managing conditional formatting rules
  • Styles and themes
    • Applying a cell style
    • Creating a cell style
    • Managing existing cell styles
    • Applying a theme to a workbook
    • Customising theme colours
    • Customising theme fonts
    • Customising theme effects
    • Saving a theme
  • Sorting and Outlines
    • Sorting data in a table by the content of one column
    • Sorting data by cell or font colour, or icon set
    • Sorting table data using several criteria
    • Using an outline
  • Filtering data
    • Activating automatic filtering
    • Filtering data by content or formatting
    • Filtering using custom criteria
    • Using data specific filters
    • Filtering using several criteria
    • Clearing a filter
    • Creating a complex filter
    • Filtering an Excel table using slicers
  • Page setup
    • Modifying page setup options
    • Creating a print area
    • Inserting/deleting a manual page break
    • Repeating lines/columns on each page
    • Creating and managing page headers and footers
    • Creating a watermark
    • Using views
  • Printing
    • Using print preview
    • Printing a workbook/worksheet/selection
  • Creating charts
    • Creating a chart
    • Activating/deactivating an embedded chart
    • Moving a chart
    • Switching chart data
    • Changing the chart data source
    • Adding one or more data series to a chart
    • Deleting a chart data series
    • Changing the order of the chart data series
    • Changing the axis data labels
    • Managing chart templates
    • Creating/deleting sparklines
    • Changing a sparkline
  • Chart options
    • Selecting elements in a chart
    • Changing the type of chart/data series
    • Applying a predefined chart layout
    • Displaying a chart element
    • Changing the category axis options
    • Changing the value axis options
    • Creating a combination chart with a secondary axis
    • Editing data labels
    • Applying a quick style to the chart
    • Adding a trendline to a chart
    • Changing the orientation of text in an element
    • Formatting a 3D chart
    • Changing the orientation/perspective of a 3D chart
    • Modifying a pie chart
    • Linking the points in a line chart
  • Graphic objects
    • Creating a graphic object
    • Insert a picture file or clipart
    • Inserting a screenshot
    • Inserting a diagram (SmartArt)
    • Managing diagram shapes
    • Modifying the general appearance of a diagram
  • Managing objects
    • Selecting objects
    • Managing objects
    • Changing the style of an object
    • Modifying the format of a picture
    • Cropping a picture
    • Removing the background from a picture
    • Changing picture resolution
    • Formatting object text
  • Excel tables
    • Creating an Excel table
    • Naming an Excel table
    • Resizing an Excel table
    • Hiding/displaying table headers
    • Adding a row/column to an Excel table
    • Selecting rows/columns in an Excel table
    • Displaying a totals row in an Excel table
    • Creating a calculated column in an Excel table
    • Applying a table style to an Excel table
    • Converting an Excel table to a data range
    • Deleting an Excel table and its data
  • Pivot Tables
    • Choosing a recommended Pivot Table
    • Creating a Pivot Table
    • Creating a Pivot Table based on more than one table
    • Managing fields in a Pivot Table
    • Inserting a calculated field
    • Changing the summary function or custom calculation type on a field
    • Using total and subtotal fields
    • Filtering a Pivot Table
    • Grouping elements in a Pivot Table
    • Filtering dates interactively (timeline filter)
    • Modifying the layout/presentation of a Pivot Table
    • Refreshing Pivot Tables
    • Deleting a Pivot Table
  • PivotChart
    • Choosing a recommended PivotChart
    • Creating a PivotChart
    • Deleting a PivotChart
    • Filtering a PivotChart
  • Protection
    • Protecting a workbook with a password
    • Protecting workbook elements
    • Protecting worksheet cells
    • Authorising cell access for certain users
  • Group work
    • Introduction
    • Allowing several users to edit the same workbook
    • Protecting a shared workbook
    • Modifying a shared workbook
    • Resolving conflicting changes
    • Tracking changes
    • Accepting or rejecting changes
    • Remove a user from a shared workbook
    • Stop sharing a workbook
  • Optimising data entry
    • Creating a custom list
    • Modifying/deleting custom lists
    • Creating a drop-down list
    • Defining acceptable data
    • Adding comments to cells
    • Adding handwritten annotations
    • Splitting the content of one cell across several cells
  • Importing data
    • Importing data from an Access database
    • Importing data from a web page
    • Importing data from a text file
    • Refreshing imported data
  • Macros
    • Setting up Excel to use Macros
    • Recording a macro
    • Running a macro
    • Running a macro on a graphic object
    • Modifying a macro
    • Deleting a macro
    • Saving a workbook containing macros
    • Enabling macros in the active workbook
  • Web pages
    • Introduction
    • Saving a workbook as a Web page
    • Publishing a workbook
  • Customising
    • Moving the Quick Access toolbar
    • Customizing the Quick Access toolbar
    • Displaying/hiding ScreenTips
    • Customising the status bar
    • Customising the Ribbon
    • Exporting/importing a custom Ribbon
  • Managing accounts
    • General information about accounts
    • Creating a connected account
    • Activating a connected account
    • Customising a connected account
    • Adding or removing a service
  • Appendices
    • Keyboard shortcuts
    • Index

Auteur

CollectifEn savoir plus

Caractéristiques

  • Niveau Initié à Confirmé
  • Nombre de pages 387 pages
  • Parution septembre 2013
    • Reliure spirale - 17 x 21 cm (Médian)
    • ISBN : 978-2-7460-0839-1
    • EAN : 9782746083981
    • Ref. ENI : MME13EXC
  • Niveau Initié à Confirmé
  • Parution octobre 2017
    • HTML
    • ISBN : 978-2-7460-8399-8
    • EAN : 9782746083998
    • Ref. ENI : LNMME13EXC