Teaching & Academics | Microsoft Excel
Daniel Walter Scott
Language: English Updated: 02-Feb-2022
Hi there, Welcome to this Microsoft Excel BootCamp. Together we’re going to learn how helpful Excel is in nearly every part of our professional lives.
This course is for beginners. You do not need any previous knowledge of Excel. We will stick closely to the powerful built in features of Excel and will not get bogged down in confusing code & complicated formulae.
This training course is project based. We start with a simple company branded invoice and explain how to calculate totals & tax. Using a complex and messy spreadsheet we will clean it up using Excels automatic features. With our new tidy data you’ll learn how easy pivot tables can turn long and hard to understand information into simple tables & beautiful graphs. Before you’re finished you’ll be making helpful drop down menus to help you fill out & sort your financial data. . You will learn how to turn uninspiring profit & loss statements into a good looking, easy to use documents.
Class projects
Who should attend
What do you need?
Lesson- 1: Introduction 00:01:43
Lesson- 2: All the files 00:01:45
Lesson- 1: Setting up printable page sizes 00:02:37
Lesson- 2: Adding images & logos 00:01:40
Lesson- 3: Adding text & aligning cells 00:07:17
Lesson- 4: Date formatting 00:03:43
Lesson- 5: Borders & lines 00:05:12
Lesson- 6: Formulas to calculate sales tax 00:05:27
Lesson- 7: Creating a template 00:04:48
Lesson- 8: Printing & exporting PDFs 00:03:53
Lesson- 1: Using pre-made templates 00:01:43
Lesson- 1: Cleaning up messy spreadsheets 00:04:02
Lesson- 2: Date & currency formatting 00:03:57
Lesson- 3: Remove blank rows & columns 00:02:25
Lesson- 4: Removing duplicates 00:04:27
Lesson- 5: Splitting cell contents 00:04:17
Lesson- 6: Sorting & Reordering 00:02:30
Lesson- 7: Repeating formulas 00:02:32
Lesson- 8: Practise exercise 00:02:29
Lesson- 1: GRAPHS IN EXCEL 00:07:34
Lesson- 2: Graphs for Word, PowerPoint, InDesign & Illustrator 00:07:22
Lesson- 1: How to make a Pivot Table 00:11:00
Lesson- 1: Profit & loss spreadsheet 00:17:24
Lesson- 1: Cheat Sheet & Shortcuts 00:04:30
We can send you everything you need to know about this course through email.
We respect your privacy. your information is safe and will never be shared.
ISC (India Skill Capital) is an online platform for students and professionals. You can learn and teach anything online. Be future ready.
Copyright © 2021 ISC.online All Rights Reserved.