Excel for Beginners
What you will learn
Excel Fundamentals: Start your journey by building a solid foundation in Excel.
Formula Magic: Dive into the world of Excel formulas and functions. Understand the logic behind calculations, create dynamic formulas, and leverage functions.
Data Analysis and Visualization: Explore advanced data analysis techniques using Excel’s powerful tools. Learn to create pivot tables, sort and filter data.
Clean Data Using Power Query
How to Work with Tabular Data
Conditional Formatting
IF Functions, Nested IF Functions
Charts, Pivot Charts
V-Lookup, H-Lookup, X-Lookup
Data validation
Flash Fill
Auditing an Excel Worksheet
Pivot Tables
Description
Unlock the full potential of Microsoft Excel with my comprehensive course designed for learners at all levels. Whether you’re a complete novice or an intermediate user looking to enhance your skills, “Microsoft Excel Mastery: From Beginner to Advanced Level” is your ultimate guide to mastering this powerful spreadsheet software.
What You’ll Learn:
- Excel Fundamentals: Start your journey by building a solid foundation in Excel. Learn how to navigate the interface, enter and format data, and use essential functions. Master the basics of cells, rows, and columns to lay the groundwork for more advanced techniques.
- Formula Magic: Dive into the world of Excel formulas and functions. Understand the logic behind calculations, create dynamic formulas, and leverage functions like SUM, VLOOKUP, and IF statements. Gain the skills to automate tasks and streamline your workflow.
- Data Analysis and Visualization: Explore advanced data analysis techniques using Excel’s powerful tools. Learn to create pivot tables, sort and filter data, and generate insightful charts and graphs. Uncover hidden trends and patterns within your datasets.
- Advanced Data Management: Take control of large datasets with advanced data management features. Master techniques for data validation, conditional formatting, and custom sorting. Organize and clean your data like a pro.
Why Take This Course?
- Practical Application: Each module includes real-world examples and hands-on exercises to reinforce your learning and ensure practical application.
- Lifetime Access: Gain unlimited access to course materials, updates, and resources. Continue learning at your own pace, anytime, anywhere.
- Expert Instruction: Benefit from the expertise of a seasoned Excel professional who will guide you through each step of the learning process.
English
language
Content
Introduction
Introduction
Definitions
Saving & Opening a WorkBook
Navigating the Worksheet
Ribbon, Tabs
Entering & Editing Worksheet Data
Data Types
Entering Text
Entering a Formula
Entering Dates
Inserting Charts
Inserting Objects & Pictures
Modifying Cell Contents
Working with Worksheets
Delete & Name a Worksheet
Add a Worksheet, Change a Tab Colour
Hiding Rows & Columns, Zoom In & Zoom Out
Formatting & Aligning Data
Formatting Data 1
Formatting Data 2
Working with Cells & Ranges
Define Cells & Ranges
Selecting Cells & Ranges
Adding Comments to Cells
Printing Your Work in Excel
Printing Navigation 1
Printing Navigation 2
Convert Excel Worksheet to PDF
Page Breaks
Manual Page Breaks
Working with Tables in Excel
Define & Create Tables, Examples
Filter & Sort Data in an Excel Table
Sorting Continued
Formatting a Table
Formatting a Table
Protecting Your Worksheet & Workbook
Protect a Workbook 1
Protecting a Workbook 2
Protecting a Worksheet
Working with Formulas & Functions
Add, Subtract, Multiply, Devide
Relative & Absolute References
V-Lookup
V-Lookup Application
H-Lookup
X-Lookup
SUM, MAX, MIN, AVERAGE
SUMIF, COUNTIF, AGGREGATE
CONCANTENATE & TEXT JOIN
TRIM, LEFT, RIGHT
UPPER, LOWER, PROPER
Date Formulas: NOW, TODAY, DAYS, NETWORKING DAYS
Date Formulas: WORKING DAY
Date Formulas: YEAR, MONTH, DAY
IF FUNCTIONS: BASIC IF FUNCTION
IF FUNCTION: NESTED IF FUNCTION
IF FUNCTION: IF ERROR
IF FUNCTION: IF AND, IF OR
PIVOT TABLES
Definition, Navigation
EXAMPLE PIVOT TABLE
POWER QUERY
DEFINITION
Getting Data From Excel, PDF, WEB
Cleaning Data
Connecting Power Query to the WEB
Consolidating Data From Different Files into One File
CHARTS
Definition, Types and Examples
Example, Pie Chart, Customisation, Formatting
PIVOT CHART
Definition, Example Pivot Charts
CONDITIONAL FORMATTING
Definition & Examples
DATA VALIDATION
Definition, Examples
AUDITING AN EXCEL WORKSHEET
Auditing Excel Formulas in a Worksheet
FLASH FILL
Definition, Examples