• Description
    • To go deeper

Video Training Microsoft Excel - Discovery level

Video Training Microsoft Excel - Discovery level

  • 2h 7 min
  • Viewed 1259 times

Training Theme 

This course introduces you to Excel, the spreadsheet program developed by Microsoft. You'll learn the basics of Excel, from discovering the interface and ribbon to creating clear, optimized tables. The aim is for you to be self-sufficient in using formulas that exploit mathematical operators, as well as the main statistical functions to generate averages, maximums and minimums, for example. You'll also be able to highlight your results using conditional formatting tools and simple, synthetic graphs, all of which will be covered during this training course with the aim of deepening your knowledge and developing your skills. Processing large volumes of data is also on the agenda, notably through the use of sorting and filtering functions. 
Finally, once your tables and data have been organized and processed, you'll discover how to lay out your workbook for printing, or how to collaborate in real time on a document.

Training Objectives 

You need to familiarize yourself with the Microsoft Excel spreadsheet tool and understand its basic functions. 

By the end of this course, you'll be able to: 

  • Understand how Excel works and familiarize yourself with the interface 
  • Create your own tables quickly and independently 
  • Master Excel's basic calculations and functions 
  • Improve and automate formatting to enhance the visual impact of your data 
  • Synthesize your tables using graphs 
  • Make effective use of sorting and filters associated with data lists 
  • Layout and collaborate quickly and easily

Prerequisite and Target Audience 

Target audience: Users wishing to learn the basics of using the Microsoft Excel spreadsheet tool.
Startup Level: Beginner 
Prerequisite: Independent mastery of basic computer navigation and use.

Means and Methods 

  • E-Learning Modules: A video series to help you achieve the defined educational objective.
  • Documents and other materials: Additional information or educational activities to complement this course.  

Training Content 

59 video tutorials on Microsoft Excel broken down into 9 lessons 

  • First Steps
    • Introduction to Excel
    • Start using Excel
    • How things are organized
    • A closer look at the ribbon
    • Microsoft Search
    • Cell references
    • Save and print an Excel workbook
    • Improved version history
    • Save, publish, and share
    • AutoFill
    • AutoFill and Flash Fill
    • Insert columns and rows
    • Advanced formulas and references
    • How to create a table
  • Page Layout & Printing
    • Print worksheets and workbooks
    • Insert headers and footers
    • Header and footer details
    • Print a worksheet on a specific number of pages
    • Print headings, gridlines, formulas, and more
  • Conditional Formatting
    • Use conditional formatting
    • Functions - Overall
    • Add numbers
    • Basic math
    • Operator order
    • Add formulas and references
    • Copying formulas
    • Using functions
    • Figure too long
    • Problem in cell selection
    • Logical operators
    • Functions and formulas
  • Functions Type - Statistical
    • Average a group of numbers
    • The SUM function
    • Determine minimums and maximums
    • Knowing the number of items in a table
    • Knowing the number of numeric values in a column
  • Functions Type - Date & Time
    • Add time
  • Charts
    • Introduction to Data Visualization
    • The main principles of data visualization
    • The data analysis cycle
    • Create your first chart
    • Create a chart
    • Change chart type
    • Create pie, bar, and line charts
    • Bar chart
    • Tips and best practices
    • Customize charts
    • Add a chart to a dedicated sheet
  • Sort & Filter
    • Sort and filter data
    • Use slicers to filter data
    • Tips & Tricks
    • Chat with your co-editors in real-time
    • Top tips for working in Excel Online
    • Start with "Ideas" in Excel
    • Work simultaneously with others on a workbook
    • Three ways to add numbers in Excel Online
    • Get going fast
    • Translate your Excel spreadsheets
    • Share documents

Learn more about Microsoft Excel

Microsoft's flagship spreadsheet tool, Excel, needs no further introduction, but this table processing solution has continued to evolve over the years.

Through advanced research into the tool's uses, Microsoft has made its interface more accessible and its functionalities even richer. Whether you're working with a simple table or a large amount of data, you can count on Microsoft Excel's advanced calculation, processing and formatting capabilities.

The application's interface makes it easy to find your bearings: the formula bar, the grid of columns and rows and the tabs, a system you may have seen and experienced in other Microsoft applications. However, the logic of the navigation ribbon has been rethought to be more logical: from left to right, you'll find the categories of functionalities, ranked from most-used to least-used.

As you familiarize yourself with this tool, you'll gain in time and efficiency in the basic uses of Microsoft Excel and in the processing of your data.

Cours e-learning Consultation en autonomie

Ce cours est composé de ressources libres d'accès.

Reminder

Show