Excel Essentials for the Real World (Complete Excel Course)

Offered byUDEMY

Excel Essentials for the Real World (Complete Excel Course)
at
UDEMY
Overview

This Course Covers and includes Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, NEW Formulas... (Excel 365, 2019 & 2016)

Duration	11 hours
Mode of learning	Online
Credential	Certificate

Excel Essentials for the Real World (Complete Excel Course)
at
UDEMY
Highlights

Certificate will be issued after completion of Training
30-Day Money-Back Guarantee
Full Lifetime Access

Excel Essentials for the Real World (Complete Excel Course)
at
UDEMY
Course details

Skills you will learn

Excel Conditional Formatting Vlookup Data analysis Data Entry

Who should do this course?

Business professionals looking to become more confident in Excel.
Absolute beginners who want a structured, engaging, fun and practical Excel course.
Excel users who want to discover & showcase new tips and tricks from Excel MVPs.
Students who want to make sure they have the Excel knowledge to succeed at their next job.
Data analysts looking to discover new tools to help them do more in less time.

What are the course deliverables?

Master the ESSENTIAL Excel formulas and features to accelerate your career
Learn Excel from scratch or fill in the gaps to become immediately confident
Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports
Hacks and hidden Excel features from a Microsoft MVP with 15+ years of Experience
Explore the potential of Power Query. You'll be surprised at what you achieve with a bit of Power Query knowledge.
Get lifetime access to a proven and state-of-the-art Excel course including challenges, quizzes & exercises
Learn what's new in Excel for Microsoft 365 and how these changes impact the way you use Excel
Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions

More about this course

Course will allow choose the right Excel formula to automate your data analysis (Excel VLOOKUP, IF Function, ROUND and more) cover important formulas like VLOOKUP, SUMIFS and nested IF Functions. move on to more advanced topics like Conditional Formatting, Excel Pivot Tables and Power Query

Excel Essentials for the Real World (Complete Excel Course)
at
UDEMY
Curriculum

Before You Dive In

Download Course Files

Course Outline for Quick Reference

Quick Toor Of Excel

Excel Workbook, Worksheet, Cell Structure

Quick Tour of Excel - Ribbon & Quick Access Toolbar

Data Input& Hidden Feautres To Save time

Data Entry and Editing Excel Data

Basic Excel Formulas

Work sheet Navigation, Copying And Protecting

Overview - Worksheet Navigation in Excel

Useful Excel Shortcuts for Navigation (Become Pro)

Excel Formulaes And what to be Aware of

How Excel Calculates - Order of Precedence

Absolute and Relative Cell Referencing in Excel

Important Excel Functions( Everything You Need to Become Pro

Overview & Finding Excel Functions from Insert Function

Important! Working with Excel Functions

Data Cleaning and Management: Sorting, Filtering& Replacing Data

Sort Data (Organize & Create Order) in Excel

Unsort Data to Revert to Original Order

Formatting Including conditional & Number Formatting In Excel

Excel Formatting Tips - Alignment, Borders & More

Better Than Merge (Become Pro)

Printing Excel Files & Saving as PDF

Checklist Before Printing

Useful Printing Options in Excel

Work Book Design Principles

Good Spreadsheet Design Principles (with Examples)

Adding Hyperlinks (Plus a Smart Workaround) in Excel

Excel Essentials for the Real World (Complete Excel Course)
at
UDEMY
Faculty details

Leila Gharani

Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes. Since 5 years, Leila runs her own site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques to large corporations. She also teaches at the University of Applied Sciences in Upper Austria. Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions. She places great value on keeping her courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.