Course Excel Database Functions
The Excel database functions course is intended for users who face the requirement to process large amounts of data as well as outputs from external databases. Users will learn to choose an effective way of working and automate it as much as possible.
Minimum input knowledge
Standard PC operation, experience with Excel - moving around a document, working with worksheets, working with toolbars, setting cell format, copying content and format, basics of working with formulas and functions.
Course dates Excel Database Functions
Daily courses (2 days): 09:00 - 15:00
Course price: 250.00 / 307.50 EUR
without VAT / incl. VAT
Training syllabus Excel Database Functions
Principles for Creating a Database Table
- Excel limitations and their possible solutions.
- Data validation in a database table.
Logical Functions
- IF, nested IF.
- AND, OR.
Lookup Functions
- INDIRECT.
- LOOKUP, VLOOKUP.
- HLOOKUP, CHOOSE.
- MATCH, INDEX.
Database Functions
- DSUM, DAVERAGE.
- DMIN, DMAX.
- DCOUNT, DSTDEV etc.
Debugging Formulas
- Watch window.
- Formula checking mode and panel.
- Arrows, tools.
- Evaluate formula.
- Error checking.
Working with Automatic and Advanced Filters
- Limitations of the automatic filter.
- Entering complicated filter conditions.
- Using wildcard characters in text criteria.
- Using a macro over a table.
- Creating simple and nested subtotals.
- Tool for consolidating multiple ranges.
Working with Pivot Tables
- Working with row, column, page and data area fields.
- Setting properties of a table field as well as properties of the whole table.
- Multiple consolidation ranges.
- Calculated field, grouping.
Printing Large Tables
- Selecting the print area.
- Page setup.
- Discussion.
- Conclusion.
Output knowledge
Independent mastery of working with extensive data in Excel as well as in external databases. Making work with a table more efficient and mastering its print output.
Recommended courses after completing Excel Database Functions
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Excel Database Functions
Average rating