0(0)

General Purpose Software

Topics for this course

55 Lessons

Spreadsheet

Layout of a spreadsheet screen. Help features. Loading/saving models
Cell formatting. Font/size. Alignment. Column width, row height. Boxing grouped cells. Moving/copying/deleting cell(s)
Data types including NUMBER, TEXT, CURRENCY, SCIENTIFIC, DATE, TIME
Data formatting – decimal places. Alignment. Date/time options
Formulae. Cell addresses. Absolute and relative addressing. Replicating a formula to a block of cells
Functions
a. Number: SUM, COUNT, AVERAGE, MAX, MIN, INT, ROUND, RANDOM, SQRT, ODD, SIN, COS, TAN, POWER
b. Text: CHAR, VALUE, TRIM, RIGHT, LEFT, UPPER, LOWER
c. Decision: IF, AND, OR, NOT
Nesting functions within functions
Lookup tables and their use
Design and construct spreadsheet models for a given problem. Layout design
Print data, print formulae adjusting column widths as necessary. Print with/without grid lines. Print with/without row/column labels. Fitting to a page
Charts. Pie chart, histogram, bar chart, line graph. Customising output
“What-if” models for the determinations of best results. Practical use in business.
Exporting/importing data to/from other packages

Word Processing

Document formatting. Margins. Alignment. Indentation. Bullet points. Page breaks

Database

Graphics and Presentation Packages

Operating Systems

About the instructors

0 (0 ratings)

50 Courses

45 students

$35.00
error: Content is protected !!
Select your currency
USD United States (US) dollar