E-learning Excel 2016 Basic - Advanced - Expert UK 1yr pre
Excel 2016 Course Basic Advanced Expert
Course Content Excel 2016: Part 1 - Basic Beginner
You need to know: About your spreadsheet application
Opening a workbook Overview of the environment Moving around a workbook You need to know: Text made easy Entering data You need to know: Selecting, copying, moving Selecting and deleting cells Undoing and redoing an action Column width/row height You need to know: Saving files Saving a workbook Modifying the contents of a cell Creating a new workbook Entering a calculation formula Calculating a sum and other basic functions Calculating a percentage Reproducing data in adjacent cells Simple numerical formats Applying a theme You need to know: Formatting characters Formatting characters Character font and size Aligning cell content Cell colour Cell borders Page layout Print preview and printing Page breaks Print areas You need to know: Headers and footers Headers and footers Using Microsoft Excel Help Checking spelling Find and replace Zoom Inserting/deleting rows columns and cells Moving cells Copying to non-adjacent cells Copying cell format quickly Merging cells Orientation of cell content Cell styles Sorting data Sheet name, tab colour Inserting and deleting sheets, sheet background Moving, copying, hiding sheets Splitting the window, freeze a column/row Repeating rows/columns on printed pages Hiding elements of a sheet Summarising data with an outline
Course Content Excel 2016: Part 2 - Advanced
Displaying several lines of data in one cell Absolute reference in a formula Copying values, copying with a link You need to know: Calculating with functions Control date, date formats Simple conditions Custom formats Applying a conditional format Managing conditional formats Naming a range of cells Validation rules Multiple cell ranges and calculations in functions You need to know: Charts Creating and positioning a chart Managing a chart Selecting items in a chart Adding and removing items Formatting chart items Modifying a chart's text items Legend and plot area Printing and page layout of a chart Modifying data labels Data series and chart axes Managing series Chart type options Managing chart templates Creating a sparkline Managing sparklines Creating a drawing object Selecting and deleting objects Copying and moving objects Resizing a drawing object Modifying a text box Modifying a drawing Formatting drawing objects Inserting a picture Managing pictures Rotating and aligning objects Stacking and grouping objects Subtotal rows Creating and managing a table Presenting and sorting data in a table Automatic calculations in a table Automatic filtering Custom filters Blank cells and duplicates You need to know: Advanced filtering with a criteria range Criteria ranges Copying rows filtered using a criteria range Statistics with a criteria range You need to know: Flash Fill You need to know: Pivot tables and pivot charts Creating a pivot table Modifying a pivot table Selecting Defining the layout and the presentation of a pivot table Filtering and searching for data in a pivot table Pivot charts
Course Content Excel 2016: Part 3 - Expert
Converting data Creating a data series Custom views Attaching a comment to a cell Detecting errors Evaluating formulas The Watch Window Lookup functions Text functions Time calculations Date calculations Condition with AND Nested conditions Conditional functions Array formulas Calculating with copied values Consolidation Financial functions Double entry data table Goal seek The Solver Managing scenarios Hyperlinks Creating and customising a theme You need to know: Styles and templates Creating and working with templates Modifying and deleting templates You need to know: Exporting data Diffusing Excel data: PDF Converting Excel files Importing data Updating and managing imported data Workbook properties Protecting workbooks Protecting specific cells Sharing a workbook Tracking changes in a workbook Merging workbooks Finalising a workbook Digital signatures Creating a form Protecting and using a form Macros Versions and recovery of files You need to know: Customising the ribbon You need to know: The SharePoint site You need to know: Office Online and Office 365 You need to know: Best practice with a spreadsheet application You need to know: Sharing a workbook
Deze training wordt digitaal aangeboden.
Trainingsdetails
Aangeboden door:
Office Elearning Menu
vanaf €125.00
Engels
Deze website maakt gebruik van cookies
Om deze website naar behoren te laten functioneren plaatsen wij noodzakelijke cookies. Noodzakelijke
cookies helpen een website bruikbaarder te maken, door basisfuncties als paginanavigatie en toegang
tot beveiligde gedeelten van de website mogelijk te maken. Deze cookies gebruiken geen
persoonsgegevens. Geef hieronder uw toestemming voor cookies die wel persoonsgegevens verwerken.
Meer informatie vindt u in onze Privacy
Statement.
Sociale Media koppelingen
Hiermee kunnen cookies van social medianetwerken geplaatst worden, deze netwerken kunnen u volgen en
deze informatie gebruiken voor eigen doeleinden.
Marketing
Marketingcookies worden gebruikt om bezoekers te volgen wanneer ze verschillende websites bezoeken.
Hun doel is advertenties weergeven die zijn toegesneden op en relevant zijn voor de individuele
gebruiker. Deze advertenties worden zo waardevoller voor uitgevers en externe adverteerders.