Du er her: Søg IT kursus /
Excel 2007-2010 Basic (conducted in English), 4D Konsulenterne
Excel 2007-2010 Basic (conducted in English)
|
Kursusinfo
|
|
|||||||||||||
Excel 2007-2010 Basic (conducted in English)
Kursusmål
Excel is a spreadsheet that allows you to work with all kinds of numbers and graphs. By participating in this course you will obtain substantial knowledge of Excel’s most basic, relevant and used functions, and this will enable you to use Excel more effectively and efficiently than before. This course is also relevant for you, if you are working with Excel as a part of Office 365. The course will be conducted in English.
Deltagere
The course is aimed at you who need and want to learn Excel’s most basic, relevant and used functions and enables you to work independently and efficiently with the program. You do not need to have previous experience with Excel, but we assume that you have used a PC before.
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
Getting Started with Excel
This module covers the basics. Surveying the screen, getting acquainted with the user interface.
- The User Interface – Surveying the Excel Screen
- Workbooks and Worksheets
- Columns, Rows and Cells
- The Ribbon - Find Your Tools Easily
- Tabs and Contextual Tabs
- The Microsoft Office Button (2007) / File Tab (2010)
- Quick Access Toolbar – Adding Your Own Commands
- Customizing the Status Bar
- Dialogues
- Zooming In or Out
Building a Workbook
Navigating the worksheet and selecting cells. Entering and editing text and numbers in cells. Copying cells, mastering the fill-handle. Saving your work.
- Using Worksheets
- Entering and Editing Data
- Comments - Inserting Comments to Cells
- Columns, Rows and Cells
- File Management - Keep Track of Your Worksheets
Formulas And Calculations
In this module you will learn how to make basic calculations. You will learn how to do the math on numbers, referring to a cell or referring to named range in the worksheet. You will also learn to master the five most common functions from the Excel function library.
- Calculation Operators and Calculation Rules
- Excel Formulas with Cell References
- Introduction to Functions - An Easy and Automatic Way of Carrying Out Calculations
- Autosum
- Statistical Functions
- Logical Functions
- Copying Formulas and Functions
- Relative or Absolute Cell References
- Assigning Names in Formulas
- Error Checking Settings
Formatting
In this module you will learn how to improve the way Excel displays your data. You will learn how to change fonts and character sizes and how to add color to emphasize important cells.
- Formatting Cells
- Formatting Tools
- Format Numbers, Dates, Percentages, Font, Colors, Borders etc.
- Automatic Formatting While Writing
- Clear Formats
- Format Painter - An Easy Way of Copying Formats
Printing And Page Layout
In this module you will learn how to improve the way Excel prints your data on paper. How to adjust the layout (ie. margins, layout, orientation, paper size), and how to scale your print to fit a fixed number of pages.
- Preview The Sheet Before Printing
- Make Adjustments to The Page Layout
- Printing The Spreadsheet
The Use of Multiple Sheets
After you’ve built your workbook, you can reorganize to your own needs. If you use data in a specific sheet often, you can move it to the front of the workbook. Another way to save time is to enter the same data or apply the same format to multiple cells in several worksheets simultaneously.
- Managing Multiple Sheets
- Navigation Between Sheets
- Creating And Working with Multiple Sheets
- Entering Data on Multiple Sheets
- Formulas on Multiple Sheets
Charts
The limitation of working with numbers, even in summary, is that it is hard to keep track of several numbers at a time. By summarizing your data using a chart, you can make it much easier to see patterns and relationships.
- Enhancing Your Worksheets Using Charts
- Creating Charts
- Chart Tools – Design, Layout and Format
Lists
Having entered a lot of data in Excel, you may want to change the order in which the worksheet rows are displayed. So you need to sort your data. Or you may want hide certain rows not meeting your criteria. So you will have to use the Excel AutoFilter.
- Organizing Data Using Lists
- Creating Lists
- Sorting Lists
- Filtering Data Using Auto Filter
- Creating Tables
- Table Styles
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
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 
Bestil information
For at bestille information om Excel 2007-2010 Basic (conducted in English), venligst indtast følgende oplysninger:
Giv din anmeldelse
