1. Espace Professionnels
  2. Excel 2019 and Office 365 versions - (E/E) : Text in English with the English version of the software

Excel 2019 and Office 365 versions (E/E) : Text in English with the English version of the software

Informations

Livraison possible dès le 08 décembre 2025
  • Personnalisable
  • Livres rédigés par des auteurs francophones et imprimés à Nantes

Informations

  • Consultable en ligne immédiatement après validation du paiement et pour une durée de 10 ans.
  • Version HTML
  • Livres rédigés par des auteurs francophones et imprimés à Nantes
This practical guide provides detailed information about the various functions available in Microsoft's® famous spreadsheet application Excel; it has been written for the 2019 version of Excel, including the features and differences to be found in the version included in Office 365. It is aimed at anyone who wants to explore and familiarise themselves with all its features. You will be introduced to the work environment, how to manage workbooks, templates and spreadsheets, and discover the...
  • Niveau Initié à Confirmé
  • Nombre de pages 390 pages
  • Parution janvier 2020
  • Niveau Initié à Confirmé
  • Parution janvier 2020
This practical guide provides detailed information about the various functions available in Microsoft's® famous spreadsheet application Excel; it has been written for the 2019 version of Excel, including the features and differences to be found in the version included in Office 365. It is aimed at anyone who wants to explore and familiarise themselves with all its features.

You will be introduced to the work environment, how to manage workbooks, templates and spreadsheets, and discover the techniques you can use to enter and edit data (numbers, dates, data series, flash fill, equations etc.).

You will go on to see how you can carry out all kinds of calculations, from the simplest (percentage, statistics) to the more complex (conditional formula, date calculation, lookup functions, loan repayment table calculation, double input data table, data consolidation, array formulas etc.). There is a special section to deal with analytical tools: creating scenarios, calculating a target value, auditing your worksheets and using the Solver.

Next, you will use the many functions provided to format your tables (fonts, shading, borders, conditional formatting, styles etc.). You will learn to sort and filter your data, organise your tables as outlines and print them.

Excel is a powerful tool for presenting data as charts; you will discover the many different types of chart available: bar charts, histograms, pie charts, 2D and 3D map charts, trendlines and sparklines. You will also find out how to insert graphic objects (shapes, pictures, icons, 3D models, diagrams etc.) into a spreadsheet.

But Excel is also a very powerful data analysis tool: you can create and manage data tables, and create pivot tables which can easily be filtered and/or sorted.

Part of this book is devoted to group work, and so there is a wealth of information about how to protect workbooks and share data, and co-authoring. The last few chapters look at techniques you can use to optimise data entry (creating custom lists and drop-down lists), how to import data, macros, saving a workbook as a Web page and managing your User account.

Caractéristiques

  • Reliure spirale - 17 x 21 cm (Médian)
  • ISBN : 978-2-409-02226-5
  • EAN : 9782409022265
  • Ref. ENI : ME19EXC

Caractéristiques

  • HTML
  • ISBN : 978-2-409-02131-2
  • EAN : 9782409021312
  • Ref. ENI : LNME19EXC

Téléchargements

Environment
  1. Starting Excel 2019
  2. Leaving Excel 2019
  3. Using/managing the ribbon
  4. Introducing the File tab
  5. Undoing the most recent commands
  6. Redoing the last cancelled commands
  7. Repeating the last command
  8. Using Help
    1. Intuitive help
    2. Help tab
Views
  1. Changing the display mode
    1. Normal view
    2. Page Layout view
    3. Page Break Preview
  2. Optimising the display
  3. Activating/deactivating the Touch/Mouse Mode
  4. Modifying the formula bar display
  5. Displaying/hiding gridlines, row and column headers
  6. Changing the zoom setting
  7. Activating one or more windows
  8. Viewing a workbook in two different windows
  9. Arranging the window view
  10. Displaying/hiding a window
  11. Freezing/unfreezing rows or columns
  12. Splitting a window into several panes
Workbooks
  1. Creating a new workbook
  2. Creating a workbook from a template
    1. Creating a workbook from a suggested template
    2. Creating a workbook from a custom template
    3. Look for a template online
  3. Creating a custom template
  4. Opening a workbook
  5. Saving a workbook
    1. Saving a new workbook
    2. Saving an existing workbook
  6. Using the OneDrive online storage area
    1. The advantages of using OneDrive
    2. To save a file (Excel 2019)
    3. To save a file (Excel Office 365)
    4. Opening a file saved to OneDrive
  7. Using Excel 2019 workbooks in previous versions
    1. Checking the compatibility of a workbook
    2. Saving a workbook in Excel 97-2003 format
  8. Using workbooks from pre-2007 versions of Excel
    1. Working in compatibility mode in Excel 2019
    2. Converting a workbook to Excel 2019 format
  9. Saving a workbook in PDF or XPS format
  10. Displaying/editing workbook properties
    1. Managing advanced properties
  11. Comparing two workbooks side-by-side
  12. Closing a workbook
  13. Choosing the default working folder
  14. Managing settings for automatic workbook recovery
  15. Recovering a previous version of a file
    1. Recovering a workbook which has been saved at leastonce
    2. Recovering a workbook which has not been saved
  16. Sending a workbook by e-mail
  17. Using the accessibility checker
Movement/selection
  1. Moving around in a worksheet
  2. Accessing a particular cell
  3. Searching for a cell
    1. By contents
    2. By format
  4. Selecting cells
    1. Adjacent cells
    2. Non-adjacent cells
  5. Selecting rows/columns
  6. Selecting cells by content
Data entry and editing
  1. Entering constant data (text, values, etc.)
  2. Inserting special characters
  3. Inserting the system date/time in a cell
  4. Using the AutoComplete feature
  5. Using Flash Fill to complete a column
    1. To activate/deactivate the function
    2. Filling a column using the contents of several columns
    3. Achieving consistent formatting of data
    4. Splitting one column into several columns
    5. Managing Flash Filled data
  6. Entering the same data in several cells
  7. Creating line breaks in a cell
    1. Creating a line break
    2. Defining an automatic line break
  8. Creating series of data
    1. Creating a simple series
    2. Creating a complex series
      1. Using the fill handle
      2. Using the dialogue box
  9. Using the Equation editor
    1. Inserting a preset equation
    2. Creating an equation
    3. Creating a handwritten equation
  10. Modifying the contents of a cell
  11. Clearing cell contents
  12. Replacing the contents/format of one cell with the contents/ format of another
    1. Replacing text
    2. Replacing formatting
  13. Checking the spelling
  14. Using an defining AutoCorrect
Copying and moving
  1. Copying into adjacent cells
  2. Copying and moving cells
    1. Using drag-and-drop
    2. Using the Clipboard
  3. Copying cells to other sheets
  4. Using the Clipboard pane
    1. Displaying and hiding the Clipboard task pane
    2. Defining Clipboard pane settings
    3. Copying/moving multiple items
  5. Copying a format
  6. Copying cell content, results and/or formats
  7. Transposing data as you copy
  8. Copying Excel data and establishing a link
  9. Making simple calculations while you copy
  10. Copying data as a picture
Worksheets
  1. Activating a worksheet
  2. Renaming a sheet
  3. Selecting worksheets
  4. Changing the colour of the worksheet tabs
  5. Displaying/hiding a worksheet
  6. Displaying a background picture in the worksheet
  7. Moving/copying one or more sheets
    1. Within the active workbook
    2. From one workbook to another
  8. Inserting/adding worksheets
  9. Deleting worksheets
Rows, columns, cells
  1. Inserting rows/columns
  2. Deleting rows/columns
  3. Modifying the row height/column width
  4. Adjusting row height and column width
  5. Inserting empty cells
  6. Deleting cells
  7. Moving and inserting cells/rows/columns
  8. Removing rows containing duplicates
Named areas
  1. Naming cell range
    1. First method
    2. Second method
    3. Third method
  2. Managing cell names
    1. Accessing the Name Manager
    2. Deleting a name
    3. Modifying the name applied to a range of cells
    4. Modifying a name’s cell range
  3. Selecting a range of cells by name
  4. Displaying a list of names and associated references
Calculations
  1. Learning about calculation formulas
  2. Creating a basic calculation formula
  3. Creating an absolute cell reference in a formula
  4. Entering a formula from more than one sheet
  5. Using calculation functions
  6. Using AutoComplete to enter a function
  7. Summing a group of cells
  8. Using simple statistical functions
  9. Creating a basic conditional formula
  10. Creating a nested conditional formula
  11. Combining the OR and the AND operators in a conditional formula
  12. Counting cells which meet specific criteria (COUNTIF)
  13. Calculating the sum of a range which meets a criterion (SUMIF)
  14. Using named ranges in calculations
  15. Inserting rows of statistics
Advanced calculations
  1. Using dates in calculations
    1. Calculating days
    2. Combining text with a date
    3. Calculating the difference between two dates (DATEDIFfunction)
    4. Calculating the number of workdays or non-workdaysbetween two dates
    5. Calculating the date after a number of working days
    6. Calculating public holidays
    7. Adding up months and years
  2. Calculating using time
    1. Calculating times
    2. Calculating the difference between two times
    3. Converting times
  3. Using the LOOKUP function
  4. Using the new calculation functions
    1. CONCAT function
    2. TEXTJOIN function
    3. MAXIFS and MINIFS functions
    4. IFS function
    5. SWITCH function
  5. Consolidating data
  6. Creating double entry data tables
  7. Calculating with array formulas
Scenarios and goals
  1. Setting a value goal
  2. Making scenarios
    1. Creating scenarios
    2. Running a scenario
Auditing
  1. Displaying formulas instead of results
  2. Finding and correcting errors in formulas
    1. Displaying errors
    2. Analysing errors in a formula
    3. Analysing the errors in all formulas
  3. Evaluating formulas
  4. Using the Watch Window
  5. Tracing relationships between formulas and cells
    1. Showing precedents
    2. Showing dependent cells
Solver
  1. Finding and activating the Solver Add-in
  2. Defining and solving a problem using the Solver
  3. Show intermediate Solver solutions
Standard formatting
  1. Modifying the font and/or font size
    1. Changing the font or the size
    2. Shrinking character size to fit
    3. Applying Bold, Underscore and Italics
    4. Applying more character formats
    5. Changing character colour
    6. Using the mini toolbar
  2. Applying a number format
  3. Creating a custom format
Data alignment
  1. Distribute an entry across the height of the row
  2. Modifying the orientation of cell content
  3. Aligning cell content
  4. Indenting cell contents
  5. Merging cells
  6. Centring content across several columns
Borders and fills
  1. Applying cell borders
    1. Applying preset borders
    2. Applying more borders
    3. Drawing borders
  2. Applying a fill to cells
  3. Applying a pattern or fill effect to cells
    1. Applying a pattern to cells
    2. Applying a fill effect to cells
Conditional formatting
  1. Applying preset conditional formatting
  2. Creating a conditional formatting rule
    1. Creating Data Bar conditional formatting
    2. Creating a colour scale format
    3. Creating icon set formatting
  3. Formatting cells according to their content
    1. Applying a preset format
    2. Customising a format
  4. Remove conditional formatting
  5. Managing conditional formatting rules
Styles and themes
  1. Applying a cell style
  2. Creating a cell style
  3. Managing existing cell styles
  4. Applying a table style
  5. Applying a theme to a workbook
  6. Customising theme colours
    1. Modifying the colour set associated with a theme
    2. Creating a colour set
  7. Customising theme fonts
    1. Modifying theme font sets
    2. Creating a font set
  8. Choosing theme effects
  9. Saving a theme
Sorting and Outlines
  1. Sorting data in a table by the content of one column
  2. Sorting data by cell or font colour, or icon set
  3. Sorting table data using several criteria
    1. Sorting using several content criteria
    2. Sorting using several colour/icon criteria
    3. Managing sort criteria
  4. Using an outline
    1. Creating an outline automatically
    2. Creating an outline manually
    3. Using an outline
    4. Removing an outline
Filtering data
  1. Activating/deactivating automatic filtering
  2. Filtering data by content or formatting
    1. Filtering by column value
    2. Filtering using a cell colour, font colour or iconset
    3. Filtering by active cell content or formatting
  3. Filtering using custom criteria
  4. Using data specific filters
    1. Filtering by a data range (numeric or chronological)
    2. Filtering by highest and lowest values (numeric filter)
    3. Filtering using the average value (number filter)
    4. Using a dynamic filter
  5. Filtering using several criteria
    1. Two criteria for the same column
    2. Several criteria on different columns
  6. Clearing a filter or all filters
  7. Creating a complex filter
    1. Creating a criteria field
    2. Filtering data using a criteria range
    3. Copying data from a complex filter
  8. Filtering an Excel table using slicers
  9. Generating statistics for data filtered using a criteria range
Page setup
  1. Modifying page setup options
  2. Creating a print area
  3. Inserting/deleting a manual page break
  4. Repeating lines/columns on each page
  5. Creating and managing page headers and footers
    1. Accessing the create/modify header/footerpage
    2. Inserting a predefined page header or footer
    3. Inserting a custom page header or footer
    4. Defining page header and footer options
    5. Deleting page headers and footers
  6. Creating a watermark
  7. Using views
    1. Creating a view
    2. Using a view
Printing
  1. Using print preview
  2. Printing a workbook/worksheet/selection
Creating charts
  1. Creating a chart
    1. Creating a chart from the Quick Analysis tool
    2. Creating a recommended chart
    3. Choosing a chart to create
    4. Managing charts
  2. Creating a 2D Map Chart
  3. Activating/deactivating an embedded chart
  4. Moving a chart
  5. Switching chart data
  6. Changing the chart data source
    1. First method
    2. Second method
  7. Adding one or more data series to a chart
  8. Deleting a chart data series
  9. Changing the order of the chart data series
  10. Changing the axis data labels
  11. Managing chart templates
    1. Saving a chart as a chart template
    2. Applying a chart template
    3. Deleting a chart template
  12. Creating/deleting sparklines
  13. Changing a sparkline
Chart options
  1. Selecting elements in a chart
  2. Changing the type of chart/data series
  3. Applying a predefined chart layout
    1. Applying a layout
    2. Applying a colour palette
  4. Displaying/hiding chart elements
    1. First method
    2. Second method
  5. Changing the category axis options
    1. Axis Options list
    2. Tick Marks list
    3. Labels list
    4. Number list
  6. Changing the value axis options
    1. Axis Options list
    2. Tick Marks list
    3. Labels list
    4. Number list
  7. Adding a secondary vertical axis
  8. Editing data labels
    1. Changing the shape of a data label
    2. Restoring label text
  9. Applying a quick style to the chart
    1. First method
    2. Second method
  10. Adding a trendline to a chart
  11. Changing the orientation of text in an element
  12. Formatting a 3D chart
  13. Changing the orientation/perspective of a 3D chart
  14. Modifying a pie chart
    1. Using Pie of Pie or Bar of Pie charts
    2. Creating a half-pie chart
  15. Linking the points in a line chart
Graphic objects
  1. Creating a graphic object
    1. Drawing a shape
    2. Drawing a text box
    3. Inserting a WordArt object
  2. Inserting an icon
  3. Inserting a picture file
  4. Inserting a 3D model
    1. From a file
    2. From the 3D Remix online library
    3. Adjusting a 3D model
  5. Inserting a screenshot
  6. Inserting a diagram (SmartArt)
    1. Adding bullets to a shape
    2. Displaying/hiding the Text pane
  7. Managing diagram shapes
    1. Creating a new shape
    2. Modifying the level of a shape
    3. Deleting a shape
    4. Moving shapes or pictures in a diagram
  8. Modifying the general appearance of a diagram
Managing objects
  1. Selecting objects
    1. Without the Selection pane
    2. With the Selection pane
  2. Managing objects
  3. Changing the formatting of an object
  4. Modifying the format of a picture
  5. Cropping a picture
  6. Removing the background from a picture
  7. Changing picture resolution
    1. Changing the default picture resolution
    2. Changing the resolution of selected pictures
  8. Formatting object text
    1. Without the Format Shape pane
    2. With the Office Format Shape pane
Excel tables
  1. Creating an Excel table
  2. Naming an Excel table
  3. Resizing an Excel table
  4. Hiding/displaying table headers
  5. Adding a row/column to an Excel table
  6. Selecting rows/columns in an Excel table
  7. Displaying a totals row in an Excel table
    1. First method
    2. Second method
  8. Creating a calculated column in an Excel table
  9. Applying a table style to an Excel table
  10. Converting an Excel table to a data range
  11. Deleting an Excel table and its data
Pivot Tables
  1. Choosing a recommended Pivot Table
  2. Creating a Pivot Table
  3. Creating a Pivot Table based on more than one table
  4. Managing fields in a Pivot Table
    1. Adding/deleting fields
    2. Rearranging fields
  5. Inserting a calculated field
  6. Changing the summary function or custom calculation type on a field
  7. Using total and subtotal fields
  8. Filtering a Pivot Table
    1. The field used for the filter is part of the table
    2. The field used for the filter is not part of the table
    3. Filtering a Pivot Table using a segment filter (”slicer”)
  9. Grouping elements in a Pivot Table
    1. Grouping by field
    2. Grouping by selection
  10. Filtering dates interactively (timeline filter)
  11. Modifying the layout/presentation of a Pivot Table
    1. Modifying the format of the Pivot Table
    2. Modifying the format of a row field
    3. Modifying the layout and format of the Pivot Table
    4. Modifying the style of the Pivot Table
  12. Refreshing Pivot Tables
  13. Deleting a Pivot Table
PivotChart
  1. Choosing a recommended PivotChart
  2. Creating a PivotChart
  3. Deleting a PivotChart
  4. Filtering a PivotChart
Protection
  1. Protecting a workbook with a password
  2. Protecting workbook elements
  3. Protecting worksheet cells
    1. Unlocking a cell range
    2. Activating worksheet protection
  4. Authorising cell access for certain users
  5. Creating and using a digital signature
    1. Creating a digital signature
    2. Inserting a digital signature
    3. Displaying information about a digital signature
    4. Revalidating a digital signature
    5. Removing a digital signature from a workbook
Sharing
  1. Introduction
  2. Sharing a workbook
  3. Managing access to a shared workbook
  4. Creating a sharing link
  5. Coauthoring a workbook
Optimising data entry
  1. Creating a custom list
  2. Modifying/deleting custom lists
  3. Creating a drop-down list
  4. Defining acceptable data
    1. Defining validation criteria
    2. Circling invalid data
  5. Adding comments to cells
    1. Creating a comment
    2. Displaying comments
  6. Splitting the content of one cell across several cells
Hyperlink
  1. Introduction
  2. Creating a hyperlink
    1. Creating a link to a new file
    2. Creating a link to an existing file or a web page
    3. Creating a link to a place in the workbook
    4. Creating a link to an e-mail address
  3. Activating a hyperlink
  4. Selecting a cell/object without activating the hyperlink
  5. Changing a hyperlink’s destination
  6. Editing a hyperlink’s text or graphic object
  7. Removing a hyperlink
Importing data
  1. Importing data from an Access database
  2. Importing data from a web page
  3. Importing data from a text file
  4. Refreshing imported data
Macros
  1. Setting up Excel to use Macros
    1. Displaying the Developer tab
    2. Defining macro security
  2. Recording a macro
  3. Running a macro
  4. Assigning a macro to a graphic object
  5. Modifying a macro
  6. Deleting a macro
  7. Saving a workbook containing macros
  8. Enabling macros in the active workbook
Customising
  1. Moving the Quick Access toolbar
  2. Customizing the Quick Access Toolbar
    1. Adding a command to the Quick Access Toolbar
    2. Removing a command from the Quick Access toolbar
    3. Changing the order of commands in the Quick AccessToolbar
  3. Displaying/hiding ScreenTips
  4. Customising the status bar
  5. Customising the Ribbon
    1. Creating a new tab/group
    2. To rename a tab or a group
    3. Adding commands to a custom group
    4. Removing a tab, custom group or command
  6. Exporting/importing a custom Ribbon
    1. Exporting Ribbon and Quick Access Toolbar customisations
    2. Importing Ribbon and Quick Access Toolbar customisations
Managing accounts
  1. General information about user accounts
  2. Adding or signing into an account
  3. Activating an account
  4. Changing the Office theme and background
  5. Adding or removing a service
  6. Managing Office software updates
Keyboard shortcuts
  1. Keyboard shortcuts
    1. Find/Replace
    2. Insert
    3. Show row/column
    4. Macro
    5. Calculations and formulas
    6. Special entries
    7. Formula bar
    8. Cell format
    9. Number and date format
    10. Go to
    11. Selection
    12. Layout mode

Nos nouveautés

voir plus
Les réseaux informatiques Guide pratique pour l'administration, la sécurité et la supervision (3e édition) Les réseaux informatiques - Guide pratique pour l'administration, la sécurité et la supervision (3e édition) L’informatique Des transistors aux microservices L’informatique - Des transistors aux microservices Certified Ethical Hacker Préparation à la certification CEH Certified Ethical Hacker - Préparation à la certification CEH Excel (versions 2024 et Microsoft 365) Excel (versions 2024 et Microsoft 365) - ITIL® 4 Préparation à la certification ITIL® 4 Foundation (3e édition) ITIL® 4 - Préparation à la certification ITIL® 4 Foundation (3e édition) Java Les fondamentaux du langage (avec exercices pratiques et corrigés) (2e édition) Java - Les fondamentaux du langage (avec exercices pratiques et corrigés) (2e édition) VBA Excel (versions 2024 et Microsoft 365) Programmer sous Excel : macros et langage VBA VBA Excel (versions 2024 et Microsoft 365) - Programmer sous Excel : macros et langage VBA InDesign 2025 InDesign 2025 - Langage C Maîtriser la programmation procédurale (avec exercices pratiques) (3e édition) Langage C - Maîtriser la programmation procédurale (avec exercices pratiques) (3e édition) Macros et langage VBA Découvrez la programmation sous Excel (3e édition) Macros et langage VBA - Découvrez la programmation sous Excel (3e édition) Gérez vos projets (3ème édition) De novice à maestro en gestion de projet Gérez vos projets (3ème édition) - De novice à maestro en gestion de projet La norme ISO/IEC 27005 Maîtriser la gestion des risques en sécurité de l'information (2e édition) La norme ISO/IEC 27005 - Maîtriser la gestion des risques en sécurité de l'information (2e édition)