-
310 plays 0Sorting 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.
-
1,285 plays 0Learn how to analyze your data with these very useful functions.
-
999 plays 0Learn how to use the Query Wizard in Access to generate useful information.
-
610 plays 0Percentage 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…
-
735 plays 0Learn the basic techniques of creating formulas, including data entry, filling (copying) a formula, and formatting.
-
1,196 plays 0Crosstab 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…
-
1,652 plays 0Aggregate queries can take large amounts of information and summarize this into more meaningful results.
-
1,901 plays 0Learn how to search your database for specific information and results. You will also learn how to manipulate your data using a calculated field.
-
1,648 plays 0Pivot tables are used to analyze and summarize large amounts of data. Learn how this tool can help you manage information.
-
1,092 plays 0Printing 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…
-
1,266 plays 0Learn 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…
-
1,380 plays 0Start learning about Excel. You will see how to enter and format numerical and text data.
-
1,311 plays 0Access reports are powerful tools for summarizing and presenting data. Learn some tips and techniques for creating meaningful reports.
-
1,251 plays 0Forms 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.
-
1,032 plays 0You will review the importance of referential integrity when creating relationships in Access. Then you will learn a second way of creating relationships between…