110
Published 11/2022
Created by Kennth Ogbebor
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 19 Lectures ( 4h 35m ) | Size: 2.39 GB
Microsoft Excel Course compatible with MS Excel and suitable for beginners and intermediate users
What you'll learn
Build a solid understanding on the Basics of the Microsoft Excel software
Maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, Pivot Tables and Pivot Charts
Harness the full power of Microsoft Excel by automating your day-to-day tasks through Macros and VBA
Create Interactive Dashboards, applying slicers
Requirements
A computer or laptop with Windows (some techniques might not work on Mac)
No prior Excel knowledge is needed.
Microsoft Excel 2016, Excel 2019 or Microsoft 365 (You mostly follow along with ALL Excel versions though - see course description for more details)
Willingness to learn.
Let's do this!
Description
DescriptionGet the Excel Advantage.Knowledge of Excel will set you at an advantage on the job, in your business or as a freelancer.This course will give you a complete understanding of the basics of Excel from the interface and features, through intermediate functions and formulas to advanced excel functions and analytics.This course will not teach you formulas and functions in isolation, instead you will learn through practical application of the Excel formulas and functions.By the end of the course, you will be able to write simple, complex and elegant formulas from scratch.This will help you to:Easily calculate and analyze data with Excel.Easily build dynamic tools & Excel dashboards to filter your dataCreate your own formula-based Excel formatting rulesManipulate dates, times, text, and arraysCreate charts and visuals in ExcelWe'll dive into a broad range of Excel formulas & functions, including:Statistical functionsFormula-based formattingDate & Time functionsLogical operatorsDynamic Array formulasText functionsI have seen the power of Excel in the course of my work as an Engineer and it give me great joy to teach others the immense power and functionality of Excel.My teaching style is practical, conversational, authentic and to the point, and I help student grasp complex concepts in a way that is clear and easy to comprehend.If you're looking for the ONE course with all of the basic and advanced Excel formulas and functions that you need to know to use Excel to your advantage, you've found it.See you in the course!-Kenneth Ogbebor
Who this course is for
This course is for everyone looking to take their Excel skills from beginner or intermediate level to advanced level and beyond.
It is good for people looking to pursue a career in data analytics, business analytics or similar fields
Excel users looking to build powerful analytical thinking and business intelligence skills
Excel users hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
