Learn Advanced Microsoft Excel

Students who have intermediate skills with Microsoft Excel 2019 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2019 interface.

What will you learn in this course?

Create pivot tables and charts.
Learn to trace precedents and dependents.
Convert text and validate and consolidate data.
Collaborate with others by protecting worksheets and workbooks.
Create, use, edit, and manage macros.
Import and export data.

Author

Infocodify

Azure Cloud | Web Development | Microsoft Official Courses

Infocodify is a Microsoft Certified Silver Partner for Learning Solutions (CPLS), authorized to distribute the latest Official Coursewares to companies and individuals helping them grow their technical skills. Web 🌐 INFOCODIFY.COM Contact Us 📧 Email: team@infocodify.com 🤙 Phone: +1 617 750 6038 Follow Us 👉 Linkedin 👉 Instagram

School

Bledar Mahmuti's School

Requirements

You should have basic and intermediate Excel experience.

Class Contents

Using Pivot Tables

Creating Pivot Tables

More Pivot Table Functionality

Inserting Slicers

Multi-Select Option in Slicers

Pivot Table Enhancements

Working with Pivot Tables

Inserting Pivot Charts

More Pivot Table Functionality

Working with Data Tools

Converting Text to Columns

Linking Data and Controlling Calculation Options

Consolidating Data

Goal Seek

Working with Others

Protecting Worksheets and Workbooks

Marking a Workbook as Final

Recording and Using Macros

Recording Macros

Running Macros

Editing Macros

Adding Macros to the Quick Access Toolbar

Random Useful Items

Sparklines

Using Microsoft Translator

Preparing a Workbook for Internationalization and Accessibility

Importing and Exporting Files

Using the Cloud in Excel

Using the Cloud

Labs

Download Labs

Preview

One-time Fee

$100

List Price: $150

You save: $50

€95.31

List Price: €142.97

You save: €47.65

£79.45

List Price: £119.18

You save: £39.72

CA$141.79

List Price: CA$212.69

You save: CA$70.89

A$157.48

List Price: A$236.22

You save: A$78.74

S$133.94

List Price: S$200.91

You save: S$66.97

HK$778.45

List Price: HK$1,167.67

You save: HK$389.22

CHF 89.97

List Price: CHF 134.96

You save: CHF 44.98

NOK kr1,111.35

List Price: NOK kr1,667.03

You save: NOK kr555.67

DKK kr711.11

List Price: DKK kr1,066.66

You save: DKK kr355.55

NZ$174.44

List Price: NZ$261.66

You save: NZ$87.22

د.إ367.30

List Price: د.إ550.95

You save: د.إ183.65

৳12,115.06

List Price: ৳18,172.59

You save: ৳6,057.53

₹8,666.83

List Price: ₹13,000.25

You save: ₹4,333.41

RM443.45

List Price: RM665.17

You save: RM221.72

₦151,060.03

List Price: ₦226,590.05

You save: ₦75,530.01

₨27,832.57

List Price: ₨41,748.86

You save: ₨13,916.28

฿3,371.62

List Price: ฿5,057.43

You save: ฿1,685.81

₺3,621.99

List Price: ₺5,432.99

You save: ₺1,810.99

B$570.48

List Price: B$855.72

You save: B$285.24

R1,837.25

List Price: R2,755.88

You save: R918.62

Лв186.40

List Price: Лв279.60

You save: Лв93.20

₩144,146

List Price: ₩216,219

You save: ₩72,073

₪356.16

List Price: ₪534.24

You save: ₪178.08

₱5,769.50

List Price: ₱8,654.25

You save: ₱2,884.75

¥15,234.50

List Price: ¥22,851.75

You save: ¥7,617.25

MX$2,030.67

List Price: MX$3,046

You save: MX$1,015.33

QR363.49

List Price: QR545.24

You save: QR181.74

P1,375.46

List Price: P2,063.20

You save: P687.73

KSh12,897.08

List Price: KSh19,345.62

You save: KSh6,448.54

E£5,059.67

List Price: E£7,589.51

You save: E£2,529.83

ብር12,771.44

List Price: ብር19,157.16

You save: ብር6,385.72

Kz91,450

List Price: Kz137,175

You save: Kz45,725

CLP$94,183.93

List Price: CLP$141,275.89

You save: CLP$47,091.96

CN¥725.40

List Price: CN¥1,088.10

You save: CN¥362.70

RD$6,198.02

List Price: RD$9,297.04

You save: RD$3,099.01

DA13,527.97

List Price: DA20,291.96

You save: DA6,763.98

FJ$229.73

List Price: FJ$344.59

You save: FJ$114.86

Q769.72

List Price: Q1,154.59

You save: Q384.86

GY$20,861.06

List Price: GY$31,291.60

You save: GY$10,430.53

ISK kr14,030.56

List Price: ISK kr21,045.85

You save: ISK kr7,015.28

DH995.45

List Price: DH1,493.18

You save: DH497.72

L1,864.55

List Price: L2,796.82

You save: L932.27

ден5,860.36

List Price: ден8,790.54

You save: ден2,930.18

MOP$799.39

List Price: MOP$1,199.08

You save: MOP$399.69

N$1,832.16

List Price: N$2,748.24

You save: N$916.08

C$3,675

List Price: C$5,512.50

You save: C$1,837.50

रु13,830.83

List Price: रु20,746.25

You save: रु6,915.41

S/370.45

List Price: S/555.67

You save: S/185.22

K401

List Price: K601.51

You save: K200.50

SAR375.05

List Price: SAR562.57

You save: SAR187.52

ZK2,809.35

List Price: ZK4,214.03

You save: ZK1,404.67

L474.34

List Price: L711.51

You save: L237.17

Kč2,385.27

List Price: Kč3,577.90

You save: Kč1,192.63

Ft38,337.82

List Price: Ft57,506.74

You save: Ft19,168.91

SEK kr1,069.32

List Price: SEK kr1,603.98

You save: SEK kr534.66

ARS$105,382.84

List Price: ARS$158,074.26

You save: ARS$52,691.42

Bs688.95

List Price: Bs1,033.43

You save: Bs344.47

COP$412,516.07

List Price: COP$618,774.11

You save: COP$206,258.03

₡50,559.60

List Price: ₡75,839.41

You save: ₡25,279.80

L2,541.98

List Price: L3,812.97

You save: L1,270.99

₲785,642.14

List Price: ₲1,178,463.21

You save: ₲392,821.07

$U4,334.26

List Price: $U6,501.39

You save: $U2,167.13

zł397.19

List Price: zł595.79

You save: zł198.59

What's Included

Language: English

Level: Advanced

Skills: Charts, Pivot Tables, Advanced Excel, Microsoft

Age groups: 18+ years

Duration: 12 hours 20 minutes

28 Documents

Learn Advanced Microsoft Excel

Learn Advanced Microsoft Excel

About the Class

Author

Infocodify

School

Bledar Mahmuti's School

Requirements

Class Contents

What's Included

Sign Up

Sign Up

Share