I am new to ArcGIS Pro. Having trouble adding an XY point (lat/long) to see where it is like you could do in ArcMap, don't see how you can do this. Tried creating an Excel file with the lat/longs and displaying XY data (right clicking the table). That brings up the Make XY Event Layer, but my lat and long fields are not recognized as X field and X field and I don't see how to add them. I tried the conversion too to convert Excel to a table but when I run it I get a failed error, ERROR 000055: Cannot create a Query Table for this workspace. My Excel header uses no prohibited word and no funky characters that I am aware of.
Can anyone please help me with
1) how to add a quick lat/long to view location on map
2) how to use Excel so lat/longs show as points