Microsoft Excel: Beginner to Pro Level in Microsoft Excel

Microsoft Excel: Beginner to Pro Level in Microsoft Excel, available at $44.99, has an average rating of 4.05, with 14 lectures, based on 18 reviews, and has 2038 subscribers.

You will learn about Basic, intermediate and advanced Microsoft Excel formulas and functions Creation and editing of database sheets including filter functions Creation and editing of charts and graphs Data linking across cells, spreadsheets and excel files Spreadsheet designing and data presentation (for specialized work books such as invoices, timetables, task-schedules, cash books, cost entries and more) Hot Microsoft Excel Short Cuts This course is ideal for individuals who are Beginners and intermediate users of Microsoft Excel It is particularly useful for Beginners and intermediate users of Microsoft Excel.

Enroll now: Microsoft Excel: Beginner to Pro Level in Microsoft Excel

Summary

Title: Microsoft Excel: Beginner to Pro Level in Microsoft Excel

Price: $44.99

Average Rating: 4.05

Number of Lectures: 14

Number of Published Lectures: 14

Number of Curriculum Items: 14

Number of Published Curriculum Objects: 14

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

Basic, intermediate and advanced Microsoft Excel formulas and functions
Creation and editing of database sheets including filter functions
Creation and editing of charts and graphs
Data linking across cells, spreadsheets and excel files
Spreadsheet designing and data presentation (for specialized work books such as invoices, timetables, task-schedules, cash books, cost entries and more)
Hot Microsoft Excel Short Cuts

Who Should Attend

Beginners and intermediate users of Microsoft Excel

Target Audiences

Beginners and intermediate users of Microsoft Excel

Microsoft Excel has deep and wide features, functions and tools can seem a little complex to new and intermediate users.

XL Skillz Lab offers a series of video lectures that seek to guide you as you navigate through the spreadsheet world. After 21 years of continuous use of the package, I have put together a course that will make your journey of discovering Microsoft Excel a little easier.

With practical examples taken from modern day typical and professional settings, my aim is to show how the tools, features and functions can be used in day-to-day scenarios.

Topics covered include:

An introductory video for new users. In it we discuss the different excel data types, rules to remember when typing data, understanding the MS Excel Menu, and many other key principles to remember.

Spreadsheet Designs,

Formatting tools and functions

Data sheet creation for Excel based databases

MS Excel basic and advanced formulas

Database Filter functions and navigation tools

Spreadsheet links

Creation of charts and graphs

Use and manipulation of time (and date) based data

Printable worksheets and formatting tips

…And many more tools, tips and tricks

There are a number of practice sheets and quizzes included with the course.

There’s always something new to learn with Microsoft Excel…

Course Curriculum

Chapter 1: Introduction to Data Entry

Lecture 1: Introduction and Data Entry Types

Lecture 2: Data Entry and Spreadsheet Design

Lecture 3: Data Presentation and Cell Editing

Chapter 2: Cell Manipulation & Basic Formula Creation

Lecture 1: Cell Manipulation and Programming

Lecture 2: MS Excel Hot Shortcuts

Lecture 3: MS Excel Formulas – Part 1

Lecture 4: Date and Time Entry

Lecture 5: Formatting & Printable Spreadsheets

Chapter 3: Advanced Excel Functions and Tools

Lecture 1: Spreadsheet Links

Lecture 2: Introduction to Microsoft Excel Charts

Lecture 3: Database Navigation Part One

Lecture 4: Database Navigation Part Two

Lecture 5: MS Excel Formulas – Part 2A

Lecture 6: MS Excel Formulas – Part 2B

Instructors

PN Misheck
Quantity Surveyor and Cost Estimator

Rating Distribution

1 stars: 0 votes
2 stars: 2 votes
3 stars: 1 votes
4 stars: 7 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu