Excel 2007-2010 Experienced (conducted in English)
|
Kursusinfo
|
|
|||||||||||||
Excel 2007-2010 Experienced (conducted in English)
Kursusmål
On the course you will learn to create more advanced and automated Excel spreadsheets and therefore be able to use even more of Excel’s many functions. This course is also relevant for you, if you are working with Excel as a part of Office 365.
Deltagere
The course is directed to you who need to use the spreadsheet program Excel in your daily work, either as an advanced user or as a “super-user”. You are expected to have knowledge of the program corresponding to our basic course and have used Excel for some time.
Kursusmateriale
On the course you will achieve the highest level of advantage by alternating between theory, elaborated questions and practical exercises. To support these exercises you will be supplied with thoroughly-prepared course material developed by 4D Konsulenterne A/S especially for this course. In order to maintain and develop your Excel proficiency, we recommend that you use the course material as a efficient reference material after the course. If this is not sufficient, you are always welcome to contact our instructors with further questions etc.
Kursus indhold
Worksheets and Workbooks
In this module you will learn how to use several worksheets and workbooks. You will learn how to manage multiple worksheets efficiently and create formulas across worksheets. You will learn how to create links between workbooks and how to share and protect a worksheet.
- Managing Multiple Sheets
- Formulas on Multiple Sheets
- Arranging Multiple Workbooks
- Creating Links Between Workbooks
- Saving Multiple Workbooks in a Workspace
- Merge Data Using Consolidation
- Creating and Using Templates
- Sharing the Workbook, Permitting Multiple Users to Work Simultaneously
- Protection of Cells, Sheets and Workbooks
Validation and Special Tools
In this module you will learn how to control data entry in your worksheet and you will learn how to paste different properties from a copied cell or range.
- Data Validation - Check Data Entry on The Spreadsheet
- Concatenate Cells With Text
- Paste Special Options
- Select Specific Areas in the Spreadsheet
Revision of Formulas
In this module you will learn a number of tools to review formulas in a complex worksheet. It can be a visual overview with lines and colors. In addition, tools for error control are explained.
- Visual Overview of the Connection Between the Formulas on the Spreadsheet
- Methods of Error Control
- Comments
- Mark Invalid Data in Connection With Validation of Data
- Evaluate Formulas – a Tool for an Easier Way to Find Calculation Levels in a Formula
- Value Control Chart – an Overview of All the Cells in the Spreadsheet
Using Functions
Functions are an easy way to manage advanced calculations in Excel and can be used for a number of problems. In this module you will learn what functions are and how to use them. There will be a number of examples of functions from the list below.
- Exploring the Function Library
- Mathematical Functions
- Statistic Functions
- Text Functions
- Date Functions
- Financial Functions
- Logical Functions
- Information Functions
- Lookup Functions
Advanced Formatting
In this module you will learn how to make custom formats and how to make formatting’s based on a cell content or a formula.
- Creating Custom Formats
- Conditional Formatting
- Combining Text and Numbers in One Cell
Data Analysis and Calculation Tools
In this module you will be acquainted with some useful tools to work with large worksheets and huge amounts of data.
- Removing Duplicates in a List
- Grouping of Rows and Columns
- Totals and Subtotals, Ignoring Hidden Data
- Combination Functions with Criteria (ie. SUMIF, COUNTIF)
- PivotTables - Analysis, Grouping and Calculation Tool
- PivotCharts
- Goal Seek
Help and Keyboard Shortcuts
In this module you will get an overview of keyboard shortcuts and key tips.
- Using Excel Help
- Excel Standard Keyboard Shortcuts
- Accessing All Commands from the Keyboard using Key Tips
Spar helt op til 40% med et:
4D Klippekort:http://www.4d.dk/Priser/Klippekort/Pages/klippekort.aspx
Vi har mange Excel kompetencer - se alle vores::
Excel ydelser:http://www.4d.dk/Produkter/Office/Excel
Er I flere - skræddersy kurset med eksempler fra jeres hverdag:
Læs mere om firmakurser:http://www.4d.dk/kursus/kursustyper/Pages/kursus_typer.aspx
Målgruppe
Excel 2007-2010 Basic (conducted in English)
Pris
4D Konsulenterne
Microsoft kurser og certificeringer
4D Konsulenterne er eksperter i IT kurser og Microsoft certificeringer. Mere end 7000 tilfredse kursister om året, nyder godt af vores gennemarbejdede kursusmaterialer og højt kvalificerede undervisere. Både 2008 og 2009 er 4D kåret af Microsoft som Årets Learning Partner. Noget vi er meget stolte af.
Som Danmarks største udbyder af Office kurser, finder du altid mange dato at vælge imellem.
Teknisk træning - som Microsoft Gold Partner leverer vi MCP kurser, specielle Certificeringsforløb og Microsoft Partner uddannelse.
Vores instruktører er blandt Danmarks højest certificerede og løser også konsulentopgaver.
Se opdateret kursuskatalog nedenfor, hvor du finder kursusdatoer og kan læse mere om indholdet på kurserne.
Du er altid velkommen til at kontakte os for at få mere at vide om kursustyper, metoder, priser og få sparring på uddannelse, der dækker præcist dit - eller jeres firmas - behov.
Køb flere kurser - Klippekort
Har du brug for en rabatordning, der tilbyder maksimal fleksibilitet, er et klippekort fra 4D Konsulenterne en god løsning. Klippekortet kan bruges af alle medarbejdere i virksomheden.
» Få mere information – helt uforpligtende!
Udfyld en interesseforespørgsel nederst på denne side.
Vis alle uddannelser afholdt hos
4D Konsulenterne
Forespørgsel efter information
Kontaktinformation til 4D Konsulenterne
Telefon: +45 3314 7144 
For at bestille information om Excel 2007-2010 Experienced (conducted in English), venligst indtast følgende oplysninger:
