You may also be interested in Excel shortcuts dune buggy Excel shortcuts job interview Excel Excel

Tutor MS Office - Excel, Word, PowerPoint, Outlook, Access Services IT lecturer Word Excel PowerPoint Outlook Edit theses dune buggy Reference FAQs Articles Excel Word ECDL Video tutorials Prices Contact
Start Excel difference between older and newer versions of Excel Save a workbook to multiple formats (. Xls,. Xlsx,. ... Pdf) Operate keyboard shortcuts for quicker and more efficient working Copying and moving cells / Tables Text Formatting Borders cells use basic cell formatting Use automatic Listings (numeric, date and text) Work with columns / rows / sheets Working with comments the calculations in the cells, using formulas basic functions: sum, average, minimum, maximum, number of simple filtering using an automatic filter Easy to create a chart Printing Excel spreadsheet intermediate
All skills levels are a beginner Excel Advanced cell formatting - Advanced custom format options - Paste Create Custom List Using Conditional Formatting all the options AutoFilter Sorting records in tables combined filters and conditional formatting to use the tools to find and replace Inserting formulas into cells - relative and absolute references anchoring options cells in formulas Insert function in different ways to work with: County, COUNTBLANK, LARGE, SMALL, SUBTOTAL, ROUND, ROUNDUP, ROUNDDOWN, IF, AND, OR, SUMIF, AVERAGEIF, COUNTIF, dune buggy VLOOKUP, HLOOKUP Create a simple PivotTable and PivotChart Creating chart and add fields to the graph print tables, set the repeat rows and columns, page setup and margins are set headers and footers Excel Intermediate
All knowledge levels contained in Excel Intermediate and beginner Nested dune buggy functions Advanced functions: DSUM, DMIN, DMAX ..., IFERROR, CHOOSE, MATCH, INDEX, TODAY, DAY, MONTH, YEAR, DATE, HOUR, MINUTE, SECOND, TIME, WEEKDAY, dune buggy LEFT, RIGHT, MID, LEN, REPLACE, SUBSTITUTE, FIND, TRIM, LOWER, UPPER, PROPER, CLEAN, CONCATENATE, PMT, NPER Work with the name and cell interconnection works with extensions filter and wildcard Find duplicates in tables dune buggy and show them the Remove verify the data and set limits Utilize a calculated field in PivotTables Protect Document / workbook use the tools to search for solutions and scenarios Create a simple message and nested subtotals Create forms to create simple and advanced macros
You may also be interested in Excel shortcuts dune buggy Excel shortcuts job interview Excel Excel PivotTable and PivotChart Excel functions Excel Excel charts automatic and advanced filter Excel conditional formatting Excel data validation
www.itlektor.eu | 2013 List of Companies