Excel 2010 Course E-learning Basics, Intermediate & Expert, Companies Gain Time, Money and Energy. How Much Will You Gain? Start Today! 1 Million+ Students Online Worldwide.
Discover Excel, work with a simple tableDiscover Excel and carry out simple tasks: opening a workbook saving it, entering and modifying data etc…You need to know: About your spreadsheet applicationOverview of the environmentOpening a workbook Moving around a workbookYou need to know: Text made easy Entering dataYou need to know: Selecting, copying, moving Selecting and deleting cellsUndoing and redoing an action Column width/row heightYou need to know: Saving files Saving a workbookModifying the contents of a cell
Set out your first Excel calculationsA spreadsheet application is designed to calculate. Learn how to enter simple formulas.
Entering a calculation formulaCalculating a sum and other basic functions Calculating a percentageReproducing data in adjacent cells
Look good with easy formattingGet the presentation of your tables right: apply colour, borders, currency symbols etc…
Simple numerical formats Applying a themeYou need to know: Formatting characters Formatting charactersCharacter font and size Aligning cell content Cell colourCell borders
Create a workbook and print your workSome basic skills: how to print your work, or create a new workbook.
Page layoutPrint preview and printing Creating a new workbook
Increase your efficiencyYou will find yourself getting more done in less time once you have mastered these simple skills with cells, text and formulas, and learned how to make the most of Excel’s help. Using Microsoft Excel HelpChecking spelling Find and replace ZoomInserting/deleting rows, columns and cells Moving cellsCopying to non-adjacent cells Copying cell format quickly Merging cellsOrientation of cell contentDisplaying several lines of data in one cell Cell stylesAbsolute reference in a formulaCopying values, copying with a link, transposing
Customise your worksheetsAn Excel workbook contains several sheets so that you can manage your data efficiently.Learn to name them, move them, insert new ones…
Sheet name, tab colourInserting and deleting sheets, sheet background Moving, copying, hiding sheets
Move on to more complex tablesYou are ready for more complex calculations or a more sophisticated presentation of your tables? Among other things, learn how to sort data, set conditions, work with automatic dates.
You need to know: Calculating with functions Control date, date formatsSimple conditions Custom formatsApplying a conditional format Managing conditional formats Sorting dataNaming a range of cells Validation criteriaSplitting the window, freezing a column/row
Print an attractive documentMake sure that your table looks as good on paper as it does on the screen: find out all about printing in Excel.
Repeating row/column headings on printed pages Hiding elements of a sheetPage breaks Print areaYou need to know: Headers and footers Headers and footers
Let charts explain your dataPresent your data visually: learn about creating and customising charts.
You need to know: Charts Creating and positioning a chart Managing a chartSelecting items in a chart Adding and removing items Formatting chart items Modifying a chart's text items Legend and plot areaData series and chart axes Managing seriesChart type options Managing chart templatesPrinting and page layout of a chart
Illustrate your dataUse simple techniques with charts, shapes, text boxes and pictures to brighten up your data.
Creating a sparkline Managing sparklines Creating a drawing objectSelecting and deleting objects Copying and moving objects Resizing a drawing object Modifying a text box Modifying a drawing Formatting drawing objects Inserting a pictureManaging picturesRotating and aligning objects Stacking and grouping objects
Move up a gearNow that you are at ease with the basic commands, see how Excel can help you to work better, faster.
Converting data Creating a data seriesUsing cell ranges in functions Summarising data with an outline Custom viewsAttaching a comment to a cell Detecting errorsEvaluating formulas The Watch Window Subtotal rows
Do more with your Excel tablesBy declaring your data as a table, you have access to easy sorting and filtering and other time-saving options. If your needs are not too specific, these functionalities can even replace a database management system.
Creating and managing a table Presenting and sorting data in a table Automatic calculations in a table Automatic filteringCustom filtersBlank cells and duplicatesYou need to know: Advanced filtering with a criteria range Criteria rangesCopying rows filtered using a criteria range Statistics with a criteria range
Pivot your dataThey constitute one of the main advantages of a spreadsheet like Excel, so make full use of pivot tables.
You need to know: Pivot tables and pivot charts Creating a pivot tableModifying a pivot tableSelecting, copying, moving or deleting in a pivot table Defining the layout and the presentation of a pivot table Filtering and searching for data in a pivot tablePivot charts
Find the right formulaHow to calculate with text, dates, times, arrays, conditions… and also how to use tools like Solver.
Lookup functions Text functions Time calculations Date calculationsCondition with AND, OR, NOT Nested conditionsConditional functions Array formulasCalculating with copied values ConsolidationFinancial functions Double entry data table Goal seekThe Solver Managing scenarios
Find out what's new and excitingDiscover some new functionality, most of it easy to grasp, for presenting and processing data, managing workbooks etc…
HyperlinksCreating and customising a themeYou need to know: Styles and templates Creating and working with templates Modifying and deleting templatesYou need to know: Exporting dataDiffusing Excel data: PDF, XPS, e-mail and Web page Converting Excel filesImporting dataUpdating and managing imported data Workbook properties
Share and collaborate effectivelyExcel proposes different solutions for a safe exchange of data: sharing, merging, various degrees of protection, signing the data etc…
Protecting workbooks Protecting specific cells Sharing a workbookTracking changes in a workbook Merging workbooksFinalising a workbook Digital signatures
Find out more…Tips on methodology, approaches to teamwork… skills that will help you optimise your use of Excel.
MacrosVersions and recovery of filesYou need to know: Customising the ribbon You need to know: The SharePoint siteYou need to know: Sharing a document over the internetYou need to know: Best practice with a spreadsheet application
Theme by InStijl Media