-
Sorting data for presentation or organization is an essential Excel skill. Learn the basics of sorting data and some of the common techniques for problem-solving.
-
Learn how to analyze your data with these very useful functions.
-
Learn how to use the Query Wizard in Access to generate useful information.
-
Percentage change is a very common business calculation. It can be used to better understand changes in sales, budgets, prices, etc. Learn the principles behind this…
-
Learn the basic techniques of creating formulas, including data entry, filling (copying) a formula, and formatting.
-
Crosstab queries help to summarize data in a very effective way--think of Aggregate Queries, but even more awesome! Learn how to use the Query Wizard to create a…
-
Aggregate queries can take large amounts of information and summarize this into more meaningful results.
-
Learn how to search your database for specific information and results. You will also learn how to manipulate your data using a calculated field.
-
Pivot tables are used to analyze and summarize large amounts of data. Learn how this tool can help you manage information.
-
Printing requirements for Excel assignments and exams at SaskPolytech include a results sheet and a formula sheet, complete with headers and footers to ensure that the…
-
Learn how to use the two most common functions in Excel. You will also learn about an essential Excel concept--relative cell referencing. You will learn how to use…
-
Start learning about Excel. You will see how to enter and format numerical and text data.
-
Access reports are powerful tools for summarizing and presenting data. Learn some tips and techniques for creating meaningful reports.
-
Forms are used in Microsoft Access for data entry and also for output. Learn the basics of creating forms and adding features, such as graphics and command buttons.
-
You will review the importance of referential integrity when creating relationships in Access. Then you will learn a second way of creating relationships between…