Скачать или смотреть Automate and track invoices using Excel - Workshop Derby 5th July 2018

This half day 'hands on' workshop delves into some of the more advanced features of Excel.

Learn how to manage data lists, use built in templates, create formula and functions and macros to automate and track your invoices.

Pre-requisites

A good working knowledge of Excel is required

Windows PC / Excel 2013/2016/O365

Automate and Track Invoices

Make your business data work for you

Data entry

Data Lists

Creating drop down lists

Sorting and Filtering




Formula for quick calculations

Add, Divide, Subtraction, Multiply

Absolute and Relative cell referencing




Professional looking templates for speed

Make use of built in templates

Creating an invoice using a template

Freeze panes




Free your time with functions

SUM, COUNT, VLOOKUP, ISBLANK, IFERROR




Printing made easy

Set/clear print area

Scaling

Margins




Macros for automation

Add the developer tab to the ribbon

Recording and saving macros

Personal macro workbook

Assign macro to a button

Click the link below for more information or to register
https://automateinvoices.eventbrite.c...