Excel

KURSE PER MICROSOFT EXCEL

NIVELI FILLESTAR

 

Section 1: Basic Skills

  • Excel Introduction
  • The Excel Interface
  • Accessing and Saving Files
  • Read and Enter Data

Section 2: Efficiency of Use

  • Keyboard Shortcuts
  • Editing

Section 3: Data Analysis

  • Basic Arithmetic
  • Sorting and Filtering

Section 4: Presentation

  • Setup
  • Printing

NIVELI MESTAR PER EXCEL

Customising Excel

Changing Excel settings to suit the way you use Excel. Includes: font face, number of worksheets, frequency of autorecovery, default view, Autocorrect and Ribbon alterations. Excel Add-Ins – Solver, Analysis TookPak. PowerPivot and Inquire.

Housekeeping

Naming and storing Excel files. Version control. Making backups.

Connecting Workbooks

  • Setting up links between Workbooks. The dangers and pitfalls of doing so.
  • Managing links between Workbooks and updating external references.
  • Troubleshooting – finding ‘missing links’ and using auditing tools.

Documentation

What to document, and how, in order to produce clear and robust spreadsheets.

Cell Formatting

Basic font formatting, alignment – Including horizontal and vertical alignment, wrapping, merging, orientation, Alt-Return; consistent, sensible row heights & column

Styles – to make spreadsheets more and consistent. Formatting tools

Number Formatting

Types of number (E.g., currency, %, decimal, negative numbers) – and Excel formats best employed. Custom number formats and how to maximise impact and clarity.

Conditional Formatting

Changing the format of cells depending on their value. Graphical conditional formats. Writing conditional format formulas.

Graphs and Charts

Creating simple charts and editing them to control and improve formatting. Choosing the right chart Principles and guidelines for communicating well with charts. Sparklines and Maps (when and how to use).

Page & Print Setup

Displaying spreadsheets as pages. Page layout view, page breaks, print area,. Printing from multiple Worksheets (and that default will be to print only from active Worksheet). Headers and footers. Adjusting page setup. Printing very large sheets of data

Protecting and Sharing

Protecting Workbooks and when it’s useful or necessary locking cells, Worksheet protection, Workbook protections, allowing users to edit ranges.

Permissions and granting access to folders & files, how to work with others on the same files and different files (both in process terms and using Excel functionality; when not to use it, avoiding conflicts). Sharing via the Cloud.

GoogleSheets

What is Googlesheets and why use Google Spreadsheets?

NIVELI I  AVANCUAR

Session 1 – Excel basics

  • Introduction to spreadsheets
  • Office and Excel overview
  • Basic text and cell formatting
  • Basic arithmetic calculation
  • Special paste
  • Freeze pane
  • Auto completion of series
  • Sort and filter
  • Charts
  • Data validation

 

Session 2 – Advanced Excel capabilities

  • Conditional formatting
  • Importing data and text to columns
  • functions
    o Mathematical
    o String
    o IF, AND, OR
    o Searching: match, search, vlookup
    o Dates
    o Misc
  • Pivot tables
  • Recording and editing Macros