About
LearnDesk
Learn  
Topics
Topics
Topics
Topics
Topics
Topics
Topics
Teach
  Teach Online
  Schedule
  Items
  Billing
  Users
  Marketing
  Analytics
  Settings
  Change School
Account
 

Microsoft Excel from Basic to Advanced

Introduction
Introduction
Preview
Conventions and Information
The Basics of Excel
Working with Excel Files
Ribbon Menu and Quick Access Toolbar
UI theme, Background and Options
The Basics of Inputting Data
Data Types
Contextual Menus
Data Structure
Navigation
Working with Data
Editing Data and AutoFill
Creating Custom AutoFill
Undo, Redo, Save, and Save-as
The Basics of Formula
Introduction to Function, SUM and AVERAGE
XLOOKUP function
Cut, Copy, and Paste
Cell References
Cell Reference Range
Relative vs Absolute References
Mixed Reference and the ROUND Function
External Worksheet Reference
External Workbook Reference
Named Reference
Data Presentation
Formatting Basics in Excel
Number Formatting and Format Painter
Custom Formatting
Basic Date Formatting
Advanced Date Formatting
Text Formatting
Text Color
Fill Color
Border Line Settings
Border Styles and Colors
Column and Row Sizes
Text Position and Orientation
Cell Styles
Managing Table Structure
Organizing Table Structure
Hiding Columns and Rows
Merging and Splitting Cells
Preview
Graphics and Charts
Inserting Images
Insert Versus Link
Transformation and Snapping
Managing Visual Objects in Excel
Transparency and Cropping
Shape Objects Basics
Lock Drawing, Modifiers, and Alignment
Editing Shapes
Text Box
Effects and Styles
Grouping
SmartArt in Excel
Creating Charts in Excel
Managing Chart Objects and Data
Chart Design Customization
Sparkline
Preview
Advanced Data Processing
Paste Types
Notes and Comments
Find
Replace
Sorting Data
Preview
Filters
Freeze Panes
Table and PivotTable
Excel Table Basics
Advanced Excel Table
PivotTable Basics
PivotTable Field, Filter, and Slicer
PivotTable Design
Connecting Excel Table to PivotTable
Conditional Formatting
Conditional Formatting Basics
Conditional Custom Formatting
Advanced Conditional Rules
Rule Stacking
Conditional Formatting with Graphics
Active Cell in Excel
Conditional Formatting with Formulas
Printing and Exporting
Basic Printing Techniques
Selective Printing
Adding a Header or Footer
Preview
Header or Footer Content and Size
Managing Headers and Footers
Scale to Fit
Sheet Options
Locking Data in Excel
Protecting Excel Files
Preview
Print to PDF and XPS
Exporting with Insert Object
Exporting with Copy and Paste

Connecting Excel Table to PivotTable

Microsoft Excel from Basic to Advanced Table and PivotTable
By: Widhi Muttaqien
6 minutes
Share the link to this page
Copied
  Twitter
  Email
Add the class to your calendar
Print
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$129
€109.15
£95.89
CA$176.06
A$181.28
S$163.13
HK$1,009.18
CHF 99.47
NOK kr1,226.68
DKK kr815.83
NZ$215.12
د.إ473.75
৳15,738.22
₹11,749.30
RM501.97
₦175,041.57
₨35,996.79
฿4,012.41
₺5,665.68
B$661.77
R2,054.77
Лв213.50
₩185,734.20
₪404.47
₱7,448.52
¥20,129.80
MX$2,223.28
QR468.15
P1,695.07
KSh16,606.99
E£6,126.55
ብር19,976.37
Kz118,293
CLP$112,702.14
CN¥884.70
RD$7,774.16
DA16,633.63
FJ$282.83
Q987.84
GY$26,944.88
ISK kr15,618.17
DH1,179.41
L2,204.22
ден6,727.49
MOP$1,037.93
N$2,049.40
C$4,740.02
रु18,749.88
S/432.11
K562.07
SAR483.46
ZK2,433.53
L556.63
Kč2,646.97
Ft41,015.42
SEK kr1,164.98
ARS$181,400.15
Bs889.94
COP$484,894.62
₡60,770.05
L3,408.16
₲829,585.68
$U4,947.39
zł460.90
Already have an account? Log In
Previous
Next
Home
Search
Saved
Trending Classes
Filter
The latest and the best classes on LearnDesk
Filter by Interest
Close
All Topics
Academics
Business
Creative
Health and Fitness
LifeStyle
Personal Development
Software
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Other
Pharma
Research
Science
Social Science
Teaching
Test Preparation
K-12
School
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
Internet of Things
Digital Transformation
Human Resources
Industry
Management
Marketing
Media
Operations
Other
Project Management
Public Relations
Real Estate
Sales
Strategy
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
Self Defense
Sports
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
Travel
Career Development
Learning
Religion and Spirituality
Self-Improvement
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
Content Management System
Customer Relationship Management
Database
Data Mining
E-Commerce
Enterprise Asset Management
Enterprise Resource Planning
Game Development
Google Cloud
Linux
Artificial Intelligence
Machine Learning
Master Data Management
Microsoft
Music Software
Network and Security
Open Source
Operating System
Other
Process Management
Productivity Software
Programming Languages
Robotics
Supply Chain Management
Testing
Teaching
Web Development

Sign Up

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.